ขอตัวอย่างโค๊ด Generate รหัสสินค้าหน่อยครับ

$sql1 = "SELECT CM_CODE FROM rm_cm where CM_CODE like '%".date('Y')."' ORDER BY CM_CODE DESC";
$MOR1 = mysql_db_query($db,$sql1) or die(mysql_error());
$numpi1 = mysql_fetch_assoc($MOR1);

 if (mysql_num_rows($MOR1)>0){
			$id=mysql_result($MOR1,0,0);
			if (strlen($id)==10){ 
				$id=mysql_result($MOR1 ,0,0);
				$getyear=substr($id,6,4);
			
						if(date('Y')==$getyear){
						$id=substr($id,2,3);
						$id=(int)$id+1;
						 }
						else{
						$id=1;
						}
						
			}else{
			
				$id=mysql_result($MOR1,0,0);
				$getyear=substr($id,7,4);
			
						if(date('Y')==$getyear){
						$id=substr($id,2,3);
						$id=(int)$id+1;
						 }
						else{
						$id=1;
						}
			}
}
else{
		$id=1;
  	}
	 
	
	 $autoid1="CM".AutoID($id)."/".date('Y');

 private void GenerateID()
        {
            string _runPIDNew = string.Empty;

            if (con.State == ConnectionState.Open) con.Close();
            con.ConnectionString = "Data Source=127.0.0.1;Initial Catalog=dbProduct;Integrated Security=True";
            con.Open();

            sb.Remove(0, sb.Length);
            sb.Append(" select max(ProductId) as maxID from product ");
            sql = sb.ToString();

            da = new SqlDataAdapter(sql, con);
            if (ds.Tables["dtProductId"] != null)
            {
                ds.Tables["dtProductId"].Clear();
            }
            da.Fill(ds, "dtProductId");

            DataTable dt = new DataTable();
            dt = ds.Tables["dtProductId"];

            if (dt.Rows.Count != 0)
            {
                string _oldID = dt.Rows[0]["ProductId"].ToString();
                int _runningID = int.Parse(_oldID.Substring(3, 5).ToString());
                int _runningIDNew = _runningID + 1;
                _runPIDNew = "PID" + _runningIDNew.ToString("00000");
            }
            else
            {
                _runPIDNew = "PID00001";
            }

        }