public bool saveCartonRelationByTrans(CtRelCarton ctRelCarton, MySqlConnection conn, MySqlTransaction mysqlTrans) { bool saveMark = true; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_ct_carton (uuid,ct_code,cartonNo,op_user,create_time)"); strSql.Append("values(@uuid,@ctCode,@cartonNo,@opuser,@createtime)"); MySqlParameter[] parameters = { new MySqlParameter("@uuid", MySqlDbType.VarChar, 900), new MySqlParameter("@ctCode", MySqlDbType.VarChar, 900), new MySqlParameter("@cartonNo", MySqlDbType.VarChar, 900), new MySqlParameter("@opuser", MySqlDbType.VarChar, 900), new MySqlParameter("@createtime", MySqlDbType.VarChar, 900), new MySqlParameter("@soOrder", MySqlDbType.VarChar, 900), }; parameters[0].Value = ctRelCarton.Uuid; parameters[1].Value = ctRelCarton.Ctcode; parameters[2].Value = ctRelCarton.CartonNo; parameters[3].Value = ctRelCarton.Opuser; parameters[4].Value = ctRelCarton.Createtime; int rows = SQLHelper.ExecuteNonQueryTrans(conn, mysqlTrans, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { saveMark = true; } else { saveMark = false; } return(saveMark); }
public bool saveCTInfo(CTCode ctCode, MySqlConnection conn, MySqlTransaction mysqlTrans) { bool saveMark = true; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_code_info (uuid,ct_code,rule_no,work_no,cus_no,cus_name,cus_po,po_qty,cus_matno,del_matno,offi_no,ver_no,wo_quantity,model_no,op_user,create_time,so_order,quantity,capacity_no)"); strSql.Append("values(@uuid,@ctcode,@ruleno,@workno,@cusno,@cusname,@cuspo,@poqty,@cusmatno,@delmatno,@offino,@verno,@woquantity,@model_no,@opuser,@createtime,@soOrder,@quantity,@capacityNo)"); MySqlParameter[] parameters = { new MySqlParameter("@uuid", MySqlDbType.VarChar, 900), new MySqlParameter("@ctcode", MySqlDbType.VarChar, 900), new MySqlParameter("@ruleno", MySqlDbType.VarChar, 900), new MySqlParameter("@workno", MySqlDbType.VarChar, 900), new MySqlParameter("@cusno", MySqlDbType.VarChar, 900), new MySqlParameter("@cuspo", MySqlDbType.VarChar, 900), new MySqlParameter("@cusmatno", MySqlDbType.VarChar, 900), new MySqlParameter("@delmatno", MySqlDbType.VarChar, 900), new MySqlParameter("@offino", MySqlDbType.VarChar, 900), new MySqlParameter("@verno", MySqlDbType.VarChar, 900), new MySqlParameter("@woquantity", MySqlDbType.VarChar, 900), new MySqlParameter("@opuser", MySqlDbType.VarChar, 900), new MySqlParameter("@createtime", MySqlDbType.VarChar, 900), new MySqlParameter("@model_no", MySqlDbType.VarChar, 900), new MySqlParameter("@poqty", MySqlDbType.VarChar, 900), new MySqlParameter("@soOrder", MySqlDbType.VarChar, 900), new MySqlParameter("@cusname", MySqlDbType.VarChar, 900), new MySqlParameter("@quantity", MySqlDbType.Int32, 900), new MySqlParameter("@capacityNo", MySqlDbType.VarChar, 900) }; parameters[0].Value = ctCode.Uuid; parameters[1].Value = ctCode.Ctcode; parameters[2].Value = ctCode.Ruleno; parameters[3].Value = ctCode.Workno; parameters[4].Value = ctCode.Cusno; parameters[5].Value = ctCode.Cuspo; parameters[6].Value = ctCode.Cusmatno; parameters[7].Value = ctCode.Delmatno; parameters[8].Value = ctCode.Offino; parameters[9].Value = ctCode.Verno; parameters[10].Value = ctCode.Woquantity; parameters[11].Value = ctCode.Opuser; parameters[12].Value = ctCode.Createtime; parameters[13].Value = ctCode.Modelno; parameters[14].Value = ctCode.Orderqty; parameters[15].Value = ctCode.SoOrder; parameters[16].Value = ctCode.Cusname; parameters[17].Value = ctCode.Quantity; parameters[18].Value = ctCode.CapacityNo; int rows = SQLHelper.ExecuteNonQueryTrans(conn, mysqlTrans, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { saveMark = true; } else { saveMark = false; } return(saveMark); }
public bool saveCartonByTrans(Carton carton, MySqlConnection conn, MySqlTransaction mysqlTrans) { bool saveMark = true; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_carton_info (uuid,cartonNo,cartonQty,prodline_id,carton_status,capacity_no,rule_no,work_no,cus_no,cus_name,cus_po,po_qty,cus_matno,del_matno,offi_no,ver_no,wo_quantity,model_no,op_user,create_time,so_order,packType,box_No,special_Field,union_Field,prodLine_val,date_code,batchNo)"); strSql.Append("values(@uuid,@cartonNo,@cartonQty,@prodlineId,@cartonStatus,@capacityNo,@ruleno,@workno,@cusno,@cusName,@cuspo,@poqty,@cusmatno,@delmatno,@offino,@verno,@woquantity,@model_no,@opuser,@createtime,@soOrder,@packType,@boxNo,@specialField,@unionField,@prodLineVal,@dateCode,@batchNo)"); MySqlParameter[] parameters = { new MySqlParameter("@uuid", MySqlDbType.VarChar, 900), new MySqlParameter("@cartonNo", MySqlDbType.VarChar, 900), new MySqlParameter("@cartonQty", MySqlDbType.VarChar, 900), new MySqlParameter("@cartonStatus", MySqlDbType.VarChar, 900), new MySqlParameter("@capacityNo", MySqlDbType.VarChar, 900), new MySqlParameter("@ruleno", MySqlDbType.VarChar, 900), new MySqlParameter("@workno", MySqlDbType.VarChar, 900), new MySqlParameter("@cusno", MySqlDbType.VarChar, 900), new MySqlParameter("@cuspo", MySqlDbType.VarChar, 900), new MySqlParameter("@poqty", MySqlDbType.VarChar, 900), new MySqlParameter("@cusmatno", MySqlDbType.VarChar, 900), new MySqlParameter("@delmatno", MySqlDbType.VarChar, 900), new MySqlParameter("@offino", MySqlDbType.VarChar, 900), new MySqlParameter("@verno", MySqlDbType.VarChar, 900), new MySqlParameter("@woquantity", MySqlDbType.VarChar, 900), new MySqlParameter("@model_no", MySqlDbType.VarChar, 900), new MySqlParameter("@opuser", MySqlDbType.VarChar, 900), new MySqlParameter("@createtime", MySqlDbType.VarChar, 900), new MySqlParameter("@soOrder", MySqlDbType.VarChar, 900), new MySqlParameter("@prodlineId", MySqlDbType.VarChar, 900), new MySqlParameter("@cusName", MySqlDbType.VarChar, 900), new MySqlParameter("@packType", MySqlDbType.VarChar, 900), new MySqlParameter("@boxNo", MySqlDbType.VarChar, 900), new MySqlParameter("@specialField", MySqlDbType.VarChar, 900), new MySqlParameter("@unionField", MySqlDbType.VarChar, 900), new MySqlParameter("@prodLineVal", MySqlDbType.VarChar, 900), new MySqlParameter("@dateCode", MySqlDbType.VarChar, 900), new MySqlParameter("@batchNo", MySqlDbType.VarChar, 900) }; parameters[0].Value = carton.Uuid; parameters[1].Value = carton.CartonNo; parameters[2].Value = carton.CartonQty; parameters[3].Value = carton.CartonStatus; parameters[4].Value = carton.CapacityNo; parameters[5].Value = carton.Ruleno; parameters[6].Value = carton.Workno; parameters[7].Value = carton.Cusno; parameters[8].Value = carton.Cuspo; parameters[9].Value = carton.Orderqty; parameters[10].Value = carton.Cusmatno; parameters[11].Value = carton.Delmatno; parameters[12].Value = carton.Offino; parameters[13].Value = carton.Verno; parameters[14].Value = carton.Woquantity; parameters[15].Value = carton.Modelno; parameters[16].Value = carton.Opuser; parameters[17].Value = carton.Createtime; parameters[18].Value = carton.SoOrder; parameters[19].Value = carton.ProdId; parameters[20].Value = carton.Cusname; parameters[21].Value = carton.PackType; parameters[22].Value = carton.BoxNo; parameters[23].Value = carton.SpecialField; parameters[24].Value = carton.UnionField; parameters[25].Value = carton.ProdLineVal; parameters[26].Value = carton.Datecode; parameters[27].Value = carton.BatchNo; int rows = SQLHelper.ExecuteNonQueryTrans(conn, mysqlTrans, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { saveMark = true; } else { saveMark = false; } return(saveMark); }