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);
}
