/// <summary>
/// Deprecated Method for adding a new object to the tinplinewarehouseSet EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotinplinewarehouseSet(tinplinewarehouse tinplinewarehouse)
{
base.AddObject("tinplinewarehouseSet", tinplinewarehouse);
}
/// <summary>
/// Create a new tinplinewarehouse object.
/// </summary>
/// <param name="customerid">Initial value of the customerid property.</param>
/// <param name="custorderno">Initial value of the custorderno property.</param>
/// <param name="cartonNumber">Initial value of the cartonNumber property.</param>
/// <param name="styleno">Initial value of the styleno property.</param>
/// <param name="color">Initial value of the color property.</param>
/// <param name="size">Initial value of the size property.</param>
/// <param name="pairqty">Initial value of the pairqty property.</param>
/// <param name="step">Initial value of the step property.</param>
/// <param name="workgroup">Initial value of the workgroup property.</param>
public static tinplinewarehouse Createtinplinewarehouse(global::System.String customerid, global::System.String custorderno, global::System.String cartonNumber, global::System.String styleno, global::System.String color, global::System.String size, global::System.Decimal pairqty, global::System.String step, global::System.String workgroup)
{
tinplinewarehouse tinplinewarehouse = new tinplinewarehouse();
tinplinewarehouse.customerid = customerid;
tinplinewarehouse.custorderno = custorderno;
tinplinewarehouse.cartonNumber = cartonNumber;
tinplinewarehouse.styleno = styleno;
tinplinewarehouse.color = color;
tinplinewarehouse.size = size;
tinplinewarehouse.pairqty = pairqty;
tinplinewarehouse.step = step;
tinplinewarehouse.workgroup = workgroup;
return tinplinewarehouse;
}
/** x线封箱不满箱暂时存放产线*/
public bool lineWarehouseSave(DataTable dt, string user, string workGroup)
{
try
{
dbInstance.BeginTransaction();
OpenBoxDal dal = new OpenBoxDal(dbInstance);
///////////////////////////
String recid = GENLSYS.MES.Common.Function.GetGUID();
String pktype = MES_PackingType.Unpacking.ToString();
DateTime actiondate = System.DateTime.Now;
String factory = "";
String userid = user;
decimal? ttlqty = 0;
string custorderno = "";
int dtl = dt.Rows.Count;
//delete old carton if exists
//delete line warehouse, if exists
string customerid = dt.Rows[0]["customerid"].ToString();
custorderno = dt.Rows[0]["poid"].ToString();
string cartonno = dt.Rows[0]["cartonNumber"].ToString();
//get checktype from receiving
List<MESParameterInfo> lstParam = new List<MESParameterInfo>()
{
new MESParameterInfo(){ParamName="custorderno",ParamValue=custorderno},
new MESParameterInfo(){ParamName="cartonno",ParamValue=cartonno} ,
new MESParameterInfo(){ParamName="customerid",ParamValue=customerid}
};
List<tinpreceivingctndtl> ctlDtl = baseDal.GetSelectedObjects<tinpreceivingctndtl>(lstParam);
string checktype = ctlDtl[0].checktype;
List<MESParameterInfo> lstParam2 = new List<MESParameterInfo>() {
new MESParameterInfo(){ParamName="custorderno",ParamValue=custorderno},
new MESParameterInfo(){ParamName="cartonNumber",ParamValue= cartonno},
new MESParameterInfo(){ParamName="customerid",ParamValue= customerid}
};
baseDal.DoDelete<tinplinewarehouse>(lstParam2);
for (int i = 0; i < dtl; i++)
{
//
tinplinewarehouse obj = new tinplinewarehouse();
obj.customerid = dt.Rows[i]["customerid"].ToString();
custorderno = dt.Rows[i]["poid"].ToString();
obj.custorderno = custorderno;
obj.cartonNumber = dt.Rows[i]["cartonNumber"].ToString();
obj.color = dt.Rows[i]["color"].ToString();
obj.size = dt.Rows[i]["size"].ToString();
obj.styleno = dt.Rows[i]["type"].ToString();
obj.step = "X"; //目前只有X线才暂存
decimal qty = decimal.Parse((dt.Rows[i]["qty2"].ToString()));
obj.pairqty = qty;
obj.checktype = checktype;
// obj.lastmodifiedtime = DateTime.Now;
// obj.user = user;
obj.workgroup = workGroup;
//insert opening box detail
localDal.DoInsert<tinplinewarehouse>(obj);
}
dbInstance.Commit();
return true;
}
catch (Exception ex)
{
dbInstance.Rollback();
return false;
throw ex;
}
finally
{
dbInstance.CloseConnection();
}
}
