/// <summary>
/// 查询装箱单对应的底座条码
/// </summary>
/// <param name="cartonNo"></param>
/// <returns></returns>
public List <CtRelCarton> queryRelCTByCartonNo(string cartonNo)
{
List <CtRelCarton> ctRelCartons = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,ct_code,cartonNo,op_user,create_time,update_user,update_time FROM t_ct_carton where cartonNo=@cartonNo and del_flag is null order by create_time");
MySqlParameter[] parameters =
{
new MySqlParameter("@cartonNo", MySqlDbType.VarChar, 900),
};
parameters[0].Value = cartonNo;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ctRelCartons = new List <CtRelCarton>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
CtRelCarton ctRelCarton = new CtRelCarton();
ctRelCarton.Uuid = dr["uuid"].ToString();
ctRelCarton.Ctcode = dr["ct_code"].ToString();
ctRelCarton.CartonNo = dr["cartonNo"].ToString();
ctRelCarton.Opuser = dr["op_user"].ToString();
ctRelCarton.Createtime = dr["create_time"].ToString();
ctRelCarton.Updateser = dr["update_user"].ToString();
ctRelCarton.Updatetime = dr["update_time"].ToString();
ctRelCartons.Add(ctRelCarton);
}
}
return(ctRelCartons);
}
/// <summary>
/// 保存CT碼和Carton的關係
/// </summary>
/// <param name="carton"></param>
/// <returns></returns>
public bool saveCartonRelation(CtRelCarton ctRelCarton)
{
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.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
saveMark = true;
}
else
{
saveMark = false;
}
return(saveMark);
}
/// <summary>
/// TODO 保存裝箱單號與CT碼的關係
/// </summary>
/// <param name="ctRelCarton"></param>
/// <returns></returns>
public bool saveCartonRelation(CtRelCarton ctRelCarton)
{
ctRelCarton.Uuid = Auxiliary.Get_UUID();
ctRelCarton.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ctRelCarton.Opuser = Auxiliary.loginName;
return(cartonDao.saveCartonRelation(ctRelCarton));
}
public bool saveCartonByTrans(Carton carton)
{
//1.获得数据库连接.
MySqlConnection conn = new MySqlConnection(SQLHelper.ConnectionString);
//2.打开数据库连接
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
//3.开启事务.
MySqlTransaction mysqlTrans = conn.BeginTransaction();
bool mark = true;
carton.Uuid = Auxiliary.Get_UUID();
carton.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
carton.Opuser = Auxiliary.loginName;
if (carton.PackType.Equals("0"))
{
foreach (string ctcode in carton.CtCodeList)
{
CtRelCarton ctRelCarton = new CtRelCarton();
ctRelCarton.Ctcode = ctcode;
ctRelCarton.CartonNo = carton.CartonNo;
ctRelCarton.Uuid = Auxiliary.Get_UUID();
ctRelCarton.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ctRelCarton.Opuser = Auxiliary.loginName;
mark = cartonDao.saveCartonRelationByTrans(ctRelCarton, conn, mysqlTrans);
if (!mark)
{
conn.Close();
return(mark);
}
}
}
mark = cartonDao.saveCartonByTrans(carton, conn, mysqlTrans);
if (!mark)
{
conn.Close();
return(mark);
}
mysqlTrans.Commit();
conn.Close();
return(mark);
}
/// <summary>
/// TODO 保存箱号信息
/// </summary>
/// <param name="carton"></param>
/// <returns></returns>
public bool saveCarton(Carton carton)
{
bool mark = true;
carton.Uuid = Auxiliary.Get_UUID();
carton.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
carton.Opuser = Auxiliary.loginName;
if (carton.PackType.Equals("0"))
{
foreach (string ctcode in carton.CtCodeList)
{
CtRelCarton ctRelCarton = new CtRelCarton();
ctRelCarton.Ctcode = ctcode;
ctRelCarton.CartonNo = carton.CartonNo;
mark = saveCartonRelation(ctRelCarton);
if (!mark)
{
return(mark);
}
}
}
return(cartonDao.saveCarton(carton));
}
