예제 #1
0
 public void orderCustomerInserUpdate(Order_Model order_Model)
 {
     DAL2.onOnLine();
     MySqlParameter[] param = new MySqlParameter[11];
     param[0]  = new MySqlParameter("@id", order_Model.id);
     param[1]  = new MySqlParameter("@uuid", order_Model.uuid);
     param[2]  = new MySqlParameter("@customerName", order_Model.customerName);
     param[3]  = new MySqlParameter("@customerPhone", order_Model.customerPhone);
     param[4]  = new MySqlParameter("@address", order_Model.address);
     param[5]  = new MySqlParameter("@note", order_Model.note);
     param[6]  = new MySqlParameter("@order_general_deatils_uuid", order_Model.order_general_deatils_uuid);
     param[7]  = new MySqlParameter("@amount", order_Model.amount);
     param[8]  = new MySqlParameter("@uuidUser", order_Model.useruuid);
     param[9]  = new MySqlParameter("@dateCreated", order_Model.date);
     param[10] = new MySqlParameter("@state", order_Model.state);
     DAL2.ExcuCommane("CALL orderCustomerInserUpdate( @id, @uuid,@customerName,@customerPhone, @address, @note, @order_general_deatils_uuid,@amount,@uuidUser,@dateCreated,@state);", param);
 }