/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
Storge MasterEntity = (Storge)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM WH_Storge WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(Sql);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E);
}
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private Storge EntityGet()
{
Storge entity = new Storge();
entity.ID = HTDataID;
return(entity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
Storge entity = (Storge)p_BE;
StorgeCtl control = new StorgeCtl(sqlTrans);
control.Delete(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
Storge entity = (Storge)p_BE;
StorgeCtl control = new StorgeCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WH_Storge, sqlTrans);
control.AddNew(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除库存0的数据--没有交易记录的
/// </summary>
/// <param name="entity"></param>
public void DeleteZeroIOForm(Storge entity)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
string sql = "Delete From WH_STORGE WHERE ID =" + entity.ID;
sqlTrans.ExecuteNonQuery(sql);
sql = "Delete From WH_IOFormLedger WHERE 1=1";
sql += " AND isnull(ColorNum,'')=" + SysString.ToDBString(entity.ColorNum);
sql += " AND isnull(ColorName,'')=" + SysString.ToDBString(entity.ColorName);
sql += " AND isnull(Batch,'')=" + SysString.ToDBString(entity.Batch);
sql += " AND isnull(VendorBatch,'')=" + SysString.ToDBString(entity.VendorBatch);
sql += " AND isnull(JarNum,'')=" + SysString.ToDBString(entity.JarNum);
//sql += " AND isnull(SizeName,'')=" + SysString.ToDBString(entity.SizeName);
sql += " AND isnull(ItemCode,'')=" + SysString.ToDBString(entity.ItemCode);
//sql += " AND isnull(YarnStatus,'')=" + SysString.ToDBString(entity.YarnStatus);
sql += " AND isnull(WHID,'')=" + SysString.ToDBString(entity.WHID);
sqlTrans.ExecuteNonQuery(sql);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 保存库存汇总实体
/// </summary>
private void RSaveEntity(BaseEntity p_BE, bool p_ZeroExitFlag, IDBTransAccess sqlTrans)
{
try
{
Storge entity = (Storge)p_BE;
///2010.2.1修改--周富春
if (entity.ID == 0)//新增
{
this.RAdd(entity, sqlTrans);
}
if (entity.ID != 0)//更新
{
this.RUpdate(entity, sqlTrans);
}
if (!p_ZeroExitFlag) //如果不允许为0的库存存在，则清除记录
{
if (entity.ID != 0 && (entity.Qty == 0)) //更新 && entity.PieceQty==0
{
this.RDelete(entity, sqlTrans);
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 校验是否存在出入库操作
/// </summary>
/// <param name="entity"></param>
/// <param name="state">状态：0非期初，1期初</param>
/// <returns></returns>
public bool CheckIOForm(Storge entity)
{
string sql = "SELECT * FROM UV1_WH_IOFormDts WHERE 1=1";
sql += " AND isnull(ColorNum,'')=" + SysString.ToDBString(entity.ColorNum);
sql += " AND isnull(ColorName,'')=" + SysString.ToDBString(entity.ColorName);
sql += " AND isnull(Batch,'')=" + SysString.ToDBString(entity.Batch);
sql += " AND isnull(VendorBatch,'')=" + SysString.ToDBString(entity.VendorBatch);
sql += " AND isnull(JarNum,'')=" + SysString.ToDBString(entity.JarNum);
//sql += " AND isnull(SizeName,'')=" + SysString.ToDBString(entity.SizeName);
sql += " AND isnull(ItemCode,'')=" + SysString.ToDBString(entity.ItemCode);
//sql += " AND isnull(YarnStatus,'')=" + SysString.ToDBString(entity.YarnStatus);
//sql += " AND isnull(WHID,'')=" + SysString.ToDBString(entity.WHID);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
Storge MasterEntity = (Storge)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO WH_Storge(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("WHID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WHID) + ",");
MasterField.Append("SectionID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SectionID) + ",");
MasterField.Append("SBitID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SBitID) + ",");
MasterField.Append("VendorID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ",");
MasterField.Append("CustomerID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CustomerID) + ",");
MasterField.Append("WHType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WHType) + ",");
MasterField.Append("ItemCode" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemCode) + ",");
MasterField.Append("ItemName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemName) + ",");
MasterField.Append("ItemStd" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemStd) + ",");
MasterField.Append("Batch" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Batch) + ",");
MasterField.Append("VendorBatch" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VendorBatch) + ",");
MasterField.Append("Twist" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Twist) + ",");
MasterField.Append("YarnType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.YarnType) + ",");
MasterField.Append("Weight" + ",");
if (MasterEntity.Weight != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Weight) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("TubeGW" + ",");
if (MasterEntity.TubeGW != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.TubeGW) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("TubeQty" + ",");
if (MasterEntity.TubeQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.TubeQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Qty" + ",");
if (MasterEntity.Qty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Qty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("LockQty" + ",");
if (MasterEntity.LockQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.LockQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FreeQty" + ",");
if (MasterEntity.FreeQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.FreeQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Needle" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Needle) + ",");
MasterField.Append("SinglePrice" + ",");
if (MasterEntity.SinglePrice != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.SinglePrice) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Amount" + ",");
if (MasterEntity.Amount != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Amount) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("PieceQty" + ",");
if (MasterEntity.PieceQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.PieceQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Unit" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Unit) + ",");
MasterField.Append("ColorNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorNum) + ",");
MasterField.Append("ColorName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorName) + ",");
MasterField.Append("JarNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.JarNo) + ",");
MasterField.Append("JarNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.JarNum) + ",");
MasterField.Append("SO" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SO) + ",");
MasterField.Append("LastUpdTime" + ",");
if (MasterEntity.LastUpdTime != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.LastUpdTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("LastUpdOP" + ",");
if (MasterEntity.LastUpdOP != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.LastUpdOP.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Remark" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ",");
MasterField.Append("Indate" + ",");
if (MasterEntity.Indate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Indate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("DutyOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DutyOPID) + ",");
MasterField.Append("CostPrice" + ",");
if (MasterEntity.CostPrice != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CostPrice) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("WHQualityFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WHQualityFlag) + ",");
MasterField.Append("WHQualityFFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WHQualityFFlag) + ",");
MasterField.Append("WHXiePianFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WHXiePianFlag) + ",");
MasterField.Append("VColorNum" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VColorNum) + ",");
MasterField.Append("VColorName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VColorName) + ",");
MasterField.Append("VItemCode" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VItemCode) + ",");
MasterField.Append("GoodsCode" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GoodsCode) + ",");
MasterField.Append("GoodsLevel" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GoodsLevel) + ",");
MasterField.Append("MWidth" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MWidth) + ",");
MasterField.Append("MWeight" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MWeight) + ",");
MasterField.Append("WeightUnit" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.WeightUnit) + ",");
MasterField.Append("OrderFormNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.OrderFormNo) + ",");
MasterField.Append("MLType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MLType) + ",");
MasterField.Append("PDDate" + ",");
if (MasterEntity.PDDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.PDDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("PDFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PDFlag) + ",");
MasterField.Append("DVendorID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DVendorID) + ",");
MasterField.Append("StyleNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.StyleNo) + ",");
MasterField.Append("Yard" + ")");
if (MasterEntity.Yard != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Yard) + ")");
}
else
{
MasterValue.Append("null)");
}
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
Storge MasterEntity = (Storge)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE WH_Storge SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" WHID=" + SysString.ToDBString(MasterEntity.WHID) + ",");
UpdateBuilder.Append(" SectionID=" + SysString.ToDBString(MasterEntity.SectionID) + ",");
UpdateBuilder.Append(" SBitID=" + SysString.ToDBString(MasterEntity.SBitID) + ",");
UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ",");
UpdateBuilder.Append(" CustomerID=" + SysString.ToDBString(MasterEntity.CustomerID) + ",");
UpdateBuilder.Append(" WHType=" + SysString.ToDBString(MasterEntity.WHType) + ",");
UpdateBuilder.Append(" ItemCode=" + SysString.ToDBString(MasterEntity.ItemCode) + ",");
UpdateBuilder.Append(" ItemName=" + SysString.ToDBString(MasterEntity.ItemName) + ",");
UpdateBuilder.Append(" ItemStd=" + SysString.ToDBString(MasterEntity.ItemStd) + ",");
UpdateBuilder.Append(" Batch=" + SysString.ToDBString(MasterEntity.Batch) + ",");
UpdateBuilder.Append(" VendorBatch=" + SysString.ToDBString(MasterEntity.VendorBatch) + ",");
UpdateBuilder.Append(" Twist=" + SysString.ToDBString(MasterEntity.Twist) + ",");
UpdateBuilder.Append(" YarnType=" + SysString.ToDBString(MasterEntity.YarnType) + ",");
if (MasterEntity.Weight != 0)
{
UpdateBuilder.Append(" Weight=" + SysString.ToDBString(MasterEntity.Weight) + ",");
}
else
{
UpdateBuilder.Append(" Weight=null,");
}
if (MasterEntity.TubeGW != 0)
{
UpdateBuilder.Append(" TubeGW=" + SysString.ToDBString(MasterEntity.TubeGW) + ",");
}
else
{
UpdateBuilder.Append(" TubeGW=null,");
}
if (MasterEntity.TubeQty != 0)
{
UpdateBuilder.Append(" TubeQty=" + SysString.ToDBString(MasterEntity.TubeQty) + ",");
}
else
{
UpdateBuilder.Append(" TubeQty=null,");
}
if (MasterEntity.Qty != 0)
{
UpdateBuilder.Append(" Qty=" + SysString.ToDBString(MasterEntity.Qty) + ",");
}
else
{
UpdateBuilder.Append(" Qty=null,");
}
if (MasterEntity.LockQty != 0)
{
UpdateBuilder.Append(" LockQty=" + SysString.ToDBString(MasterEntity.LockQty) + ",");
}
else
{
UpdateBuilder.Append(" LockQty=null,");
}
if (MasterEntity.FreeQty != 0)
{
UpdateBuilder.Append(" FreeQty=" + SysString.ToDBString(MasterEntity.FreeQty) + ",");
}
else
{
UpdateBuilder.Append(" FreeQty=null,");
}
UpdateBuilder.Append(" Needle=" + SysString.ToDBString(MasterEntity.Needle) + ",");
if (MasterEntity.SinglePrice != 0)
{
UpdateBuilder.Append(" SinglePrice=" + SysString.ToDBString(MasterEntity.SinglePrice) + ",");
}
else
{
UpdateBuilder.Append(" SinglePrice=null,");
}
if (MasterEntity.Amount != 0)
{
UpdateBuilder.Append(" Amount=" + SysString.ToDBString(MasterEntity.Amount) + ",");
}
else
{
UpdateBuilder.Append(" Amount=null,");
}
if (MasterEntity.PieceQty != 0)
{
UpdateBuilder.Append(" PieceQty=" + SysString.ToDBString(MasterEntity.PieceQty) + ",");
}
else
{
UpdateBuilder.Append(" PieceQty=null,");
}
UpdateBuilder.Append(" Unit=" + SysString.ToDBString(MasterEntity.Unit) + ",");
UpdateBuilder.Append(" ColorNum=" + SysString.ToDBString(MasterEntity.ColorNum) + ",");
UpdateBuilder.Append(" ColorName=" + SysString.ToDBString(MasterEntity.ColorName) + ",");
UpdateBuilder.Append(" JarNo=" + SysString.ToDBString(MasterEntity.JarNo) + ",");
UpdateBuilder.Append(" JarNum=" + SysString.ToDBString(MasterEntity.JarNum) + ",");
UpdateBuilder.Append(" SO=" + SysString.ToDBString(MasterEntity.SO) + ",");
if (MasterEntity.LastUpdTime != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" LastUpdTime=" + SysString.ToDBString(MasterEntity.LastUpdTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" LastUpdTime=null,");
}
if (MasterEntity.LastUpdOP != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" LastUpdOP=" + SysString.ToDBString(MasterEntity.LastUpdOP.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" LastUpdOP=null,");
}
UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ",");
if (MasterEntity.Indate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" Indate=" + SysString.ToDBString(MasterEntity.Indate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" Indate=null,");
}
UpdateBuilder.Append(" DutyOPID=" + SysString.ToDBString(MasterEntity.DutyOPID) + ",");
if (MasterEntity.CostPrice != 0)
{
UpdateBuilder.Append(" CostPrice=" + SysString.ToDBString(MasterEntity.CostPrice) + ",");
}
else
{
UpdateBuilder.Append(" CostPrice=null,");
}
UpdateBuilder.Append(" WHQualityFlag=" + SysString.ToDBString(MasterEntity.WHQualityFlag) + ",");
UpdateBuilder.Append(" WHQualityFFlag=" + SysString.ToDBString(MasterEntity.WHQualityFFlag) + ",");
UpdateBuilder.Append(" WHXiePianFlag=" + SysString.ToDBString(MasterEntity.WHXiePianFlag) + ",");
UpdateBuilder.Append(" VColorNum=" + SysString.ToDBString(MasterEntity.VColorNum) + ",");
UpdateBuilder.Append(" VColorName=" + SysString.ToDBString(MasterEntity.VColorName) + ",");
UpdateBuilder.Append(" VItemCode=" + SysString.ToDBString(MasterEntity.VItemCode) + ",");
UpdateBuilder.Append(" GoodsCode=" + SysString.ToDBString(MasterEntity.GoodsCode) + ",");
UpdateBuilder.Append(" GoodsLevel=" + SysString.ToDBString(MasterEntity.GoodsLevel) + ",");
UpdateBuilder.Append(" MWidth=" + SysString.ToDBString(MasterEntity.MWidth) + ",");
UpdateBuilder.Append(" MWeight=" + SysString.ToDBString(MasterEntity.MWeight) + ",");
UpdateBuilder.Append(" WeightUnit=" + SysString.ToDBString(MasterEntity.WeightUnit) + ",");
UpdateBuilder.Append(" OrderFormNo=" + SysString.ToDBString(MasterEntity.OrderFormNo) + ",");
UpdateBuilder.Append(" MLType=" + SysString.ToDBString(MasterEntity.MLType) + ",");
if (MasterEntity.PDDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" PDDate=" + SysString.ToDBString(MasterEntity.PDDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" PDDate=null,");
}
UpdateBuilder.Append(" PDFlag=" + SysString.ToDBString(MasterEntity.PDFlag) + ",");
UpdateBuilder.Append(" DVendorID=" + SysString.ToDBString(MasterEntity.DVendorID) + ",");
UpdateBuilder.Append(" StyleNo=" + SysString.ToDBString(MasterEntity.StyleNo) + ",");
if (MasterEntity.Yard != 0)
{
UpdateBuilder.Append(" Yard=" + SysString.ToDBString(MasterEntity.Yard));
}
else
{
UpdateBuilder.Append(" Yard=null");
}
UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
Storge entity = (Storge)p_BE;
}
/// <summary>
/// 结算库存
/// </summary>
/// <param name="p_Entity">IOForm实体</param>
/// <param name="p_EntityDts">IOFormDts实体</param>
/// <param name="p_Type">1/3 审核通过/审核拒绝</param>
public void RSubmit(int p_FormTopType, IOForm p_Entity, IOFormDts p_EntityDts, int p_Type, IDBTransAccess sqlTrans)
{
try
{
Storge entityst = new Storge(sqlTrans); //出入库结算
int StorgeID = 0;
bool p_NegativeFlag = false; //负数标志
bool p_ZeroExitFlag = false; //为0标志
int p_ISJK = 0; //寄库标志
WH entityWH = new WH(sqlTrans);
string sqlWH = "Select ID,ISJK FROM WH_WH WHERE WHID=" + SysString.ToDBString(p_EntityDts.WHID);
DataTable dtWH = sqlTrans.Fill(sqlWH);
if (dtWH.Rows.Count != 0)
{
entityWH.ID = SysConvert.ToInt32(dtWH.Rows[0]["ID"]);
entityWH.SelectByID();
p_ISJK = SysConvert.ToInt32(dtWH.Rows[0]["ISJK"]);//寄库
}
StorgeID = FindStorge(p_EntityDts, sqlTrans);
if (StorgeID != 0)//找到历史记录
{
entityst.ID = StorgeID;
entityst.SelectByID();
}
else//找不到历史记录
{
entityst.Indate = p_Entity.FormDate;
entityst.DutyOPID = p_Entity.DutyOP;
entityst.WHID = p_EntityDts.WHID;
entityst.SectionID = p_EntityDts.SectionID;
entityst.SBitID = p_EntityDts.SBitID;
entityst.ItemCode = p_EntityDts.ItemCode;
entityst.ItemName = p_EntityDts.ItemName;
entityst.ItemStd = p_EntityDts.ItemStd;
entityst.ColorNum = p_EntityDts.ColorNum;
entityst.ColorName = p_EntityDts.ColorName;
entityst.JarNum = p_EntityDts.JarNum;
entityst.Batch = p_EntityDts.Batch;
entityst.VendorBatch = p_EntityDts.VendorBatch;
entityst.YarnType = p_EntityDts.YarnType;
entityst.Unit = p_EntityDts.Unit;
entityst.SinglePrice = p_EntityDts.SinglePrice;
entityst.TubeGW = p_EntityDts.TubeGW;
entityst.Remark = p_EntityDts.Remark;
entityst.VColorNum = p_EntityDts.VColorNum;
entityst.VColorName = p_EntityDts.VColorName;
entityst.VItemCode = p_EntityDts.VItemCode;
entityst.GoodsCode = p_EntityDts.GoodsCode;
entityst.GoodsLevel = p_EntityDts.GoodsLevel;
entityst.MWidth = p_EntityDts.MWidth;
entityst.MWeight = p_EntityDts.MWeight;
entityst.WeightUnit = p_EntityDts.WeightUnit;
entityst.MLType = p_EntityDts.MLType; //用于区分成品面料和坯布
if (p_FormTopType != (int)WHFormList.出库) //非出库状态
{
entityst.VendorID = p_EntityDts.DtsVendorID; //
entityst.SO = p_EntityDts.DtsSO; //单据号
entityst.DutyOPID = p_EntityDts.DtsSaleOPID; //业务员
entityst.OrderFormNo = p_EntityDts.DtsOrderFormNo; //合同号
}
else//出库状态
{
entityst.VendorID = p_EntityDts.DtsInVendorID; //入库客户
entityst.SO = p_EntityDts.InSO; //入库订单
entityst.DutyOPID = p_EntityDts.InSaleOPID; //入库业务员
entityst.OrderFormNo = p_EntityDts.InOrderFormNo; //入库合同号
}
entityst.DVendorID = p_EntityDts.DVendorID;//销售合同
entityst.Needle = p_EntityDts.Needle;
}
if (p_Entity.SubmitFlag == (int)ConfirmFlag.审核通过)
{
switch (p_FormTopType)
{
case (int)WHFormList.入库:
entityst.Qty += p_EntityDts.Qty;
entityst.PieceQty += p_EntityDts.PieceQty;
entityst.Weight += p_EntityDts.Weight;
entityst.Amount += p_EntityDts.Qty * p_EntityDts.SinglePrice; //计算金额
break;
case (int)WHFormList.出库:
entityst.Qty -= p_EntityDts.Qty;
entityst.PieceQty -= p_EntityDts.PieceQty;
entityst.Weight -= p_EntityDts.Weight;
entityst.Amount -= p_EntityDts.Qty * p_EntityDts.SinglePrice; //计算金额
break;
case (int)WHFormList.期初入库:
goto case (int)WHFormList.入库;
}
}
else
{
switch (p_FormTopType)
{
case (int)WHFormList.入库:
entityst.Qty -= p_EntityDts.Qty;
entityst.PieceQty -= p_EntityDts.PieceQty;
entityst.Weight -= p_EntityDts.Weight;
entityst.Amount -= p_EntityDts.Qty * p_EntityDts.SinglePrice; //计算金额
break;
case (int)WHFormList.出库:
entityst.Qty += p_EntityDts.Qty;
entityst.PieceQty += p_EntityDts.PieceQty;
entityst.Weight += p_EntityDts.Weight;
entityst.Amount += p_EntityDts.Qty * p_EntityDts.SinglePrice; //计算金额
break;
case (int)WHFormList.期初入库:
goto case (int)WHFormList.入库;
}
}
if (entityst.Qty < -0.001m)//库存数量大于0
{
throw new Exception("操作后库存数量低于0，不能操作，编码：" + entityst.ItemCode + " 色号：" + entityst.ColorNum + " 颜色：" + entityst.ColorName + " 数量：" + entityst.Qty.ToString());
}
if (entityst.FreeQty < -0.001m)//库存可使用数量大于0
{
throw new Exception("操作后库存可使用数量低于0，不能操作，编码：" + entityst.ItemCode + " 色号：" + entityst.ColorNum + " 颜色：" + entityst.ColorName + " 数量：" + entityst.FreeQty.ToString());
}
this.RSaveEntity(entityst, p_ZeroExitFlag, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
