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