/// <summary>
/// 删除
/// </summary>
public override void EntityDelete()
{
ShipBoatRule rule = new ShipBoatRule();
ShipBoat entity = EntityGet();
rule.RDelete(entity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
ShipBoat MasterEntity = (ShipBoat)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM Ship_ShipBoat 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 ShipBoat EntityGet()
{
ShipBoat entity = new ShipBoat();
entity.ID = HTDataID;
return(entity);
}
/// <summary>
/// 修改
/// </summary>
public override void EntityUpdate()
{
ShipBoatRule rule = new ShipBoatRule();
ShipBoat entity = EntityGet();
ShipBoatDts[] entitydts = EntityDtsGet();
entity.SubmitFlag = this.HTSubmitFlagUpdateGet();
decimal PieceQty = 0;
decimal NetWeight = 0;
decimal CroosWeight = 0;
//decimal BoxNum = 0;
decimal BulkSize = 0;
for (int i = 0; i < entitydts.Length; i++)
{
PieceQty += entitydts[i].PieceQty;
NetWeight += entitydts[i].NetWeight;
CroosWeight += entitydts[i].CrossWeight;
// CroosWeight += entitydts[i].CrossWeight;
// BoxNum += entitydts[i].BoxNum;
BulkSize += entitydts[i].BulkSize;
}
entity.PackNum = SysConvert.ToDecimal(PieceQty, 0);
entity.NetWeight = SysConvert.ToDecimal(NetWeight, 0);
entity.CroosWeight = SysConvert.ToDecimal(CroosWeight, 0);
// entity.PortDischarge = BoxNum.ToString();
entity.TotalBulk = SysConvert.ToDecimal(BulkSize, 1);
rule.RUpdate(entity, entitydts);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_BE">要修改的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RUpdate(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ShipBoat entity = (ShipBoat)p_BE;
ShipBoatCtl control = new ShipBoatCtl(sqlTrans);
control.Update(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);
ShipBoat entity = (ShipBoat)p_BE;
ShipBoatCtl control = new ShipBoatCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Ship_ShipBoat, sqlTrans);
control.AddNew(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 RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ShipBoat entity = (ShipBoat)p_BE;
ShipBoatCtl control = new ShipBoatCtl(sqlTrans);
string sql = "DELETE FROM Ship_ShipBoatDts WHERE MainID=" + entity.ID.ToString();
sqlTrans.ExecuteNonQuery(sql);//删除原单据明细数据
control.Delete(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 保存(传入事务处理)
/// </summary>
/// <param name="p_Entity"></param>
/// <param name="p_BE"></param>
/// <param name="sqlTrans"></param>
public void RSave(ShipBoat p_Entity, BaseEntity[] p_BE, IDBTransAccess sqlTrans)
{
try
{
string sql = "DELETE FROM Ship_ShipBoatDts WHERE MainID=" + p_Entity.ID.ToString();
sqlTrans.ExecuteNonQuery(sql);//删除原单据明细数据
for (int i = 0; i < p_BE.Length; i++)
{
ShipBoatDts entitydts = (ShipBoatDts)p_BE[i];
sql = "SELECT ISNULL(MAX(Seq),0)+1 As MSEQ FROM Ship_ShipBoatDts WHERE MainID=" + p_Entity.ID.ToString();
entitydts.Seq = SysConvert.ToInt32(sqlTrans.Fill(sql).Rows[0][0].ToString());//找到最大的Seq
entitydts.MainID = p_Entity.ID;
this.RAdd(entitydts, sqlTrans);
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
ShipBoat entity = (ShipBoat)p_BE;
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
ShipBoat MasterEntity = (ShipBoat)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Ship_ShipBoat(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("IvoiceNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.IvoiceNo) + ",");
MasterField.Append("CompanyTypeID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CompanyTypeID) + ",");
MasterField.Append("SaleNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SaleNo) + ",");
MasterField.Append("VendorID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ",");
MasterField.Append("Model" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Model) + ",");
MasterField.Append("ModelEn" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ModelEn) + ",");
MasterField.Append("ShipDate" + ",");
if (MasterEntity.ShipDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ShipDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("RevisedDate" + ",");
if (MasterEntity.RevisedDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.RevisedDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("OutDate" + ",");
if (MasterEntity.OutDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.OutDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("TradeType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.TradeType) + ",");
MasterField.Append("GainType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.GainType) + ",");
MasterField.Append("ReceiveType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ReceiveType) + ",");
MasterField.Append("TransType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.TransType) + ",");
MasterField.Append("ShipTo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ShipTo) + ",");
MasterField.Append("FactoryID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FactoryID) + ",");
MasterField.Append("OutFacDate" + ",");
if (MasterEntity.OutFacDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.OutFacDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ExportDate" + ",");
if (MasterEntity.ExportDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ExportDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Messrs" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Messrs) + ",");
MasterField.Append("SpeRequest" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SpeRequest) + ",");
MasterField.Append("SCNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SCNo) + ",");
MasterField.Append("BoatName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.BoatName) + ",");
MasterField.Append("Container" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Container) + ",");
MasterField.Append("Special" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Special) + ",");
MasterField.Append("CroosWeight" + ",");
if (MasterEntity.CroosWeight != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CroosWeight) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("NetWeight" + ",");
if (MasterEntity.NetWeight != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.NetWeight) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("PackNum" + ",");
if (MasterEntity.PackNum != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.PackNum) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Shippers" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Shippers) + ",");
MasterField.Append("Consignee" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Consignee) + ",");
MasterField.Append("NotifyParty" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.NotifyParty) + ",");
MasterField.Append("PortLoading" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PortLoading) + ",");
MasterField.Append("PortDischarge" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PortDischarge) + ",");
MasterField.Append("LCNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.LCNo) + ",");
MasterField.Append("DelFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ",");
MasterField.Append("AddTime" + ",");
if (MasterEntity.AddTime != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.AddTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("AddOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.AddOPID) + ",");
MasterField.Append("UpdTime" + ",");
if (MasterEntity.UpdTime != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.UpdTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("UpdOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.UpdOPID) + ",");
MasterField.Append("SubmitFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitFlag) + ",");
MasterField.Append("SubmitTime" + ",");
if (MasterEntity.SubmitTime != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("SubmitOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitOPID) + ",");
MasterField.Append("AuditFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.AuditFlag) + ",");
MasterField.Append("FromOPName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FromOPName) + ",");
MasterField.Append("ToOPName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ToOPName) + ",");
MasterField.Append("GoodsINWHDate" + ",");
if (MasterEntity.GoodsINWHDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.GoodsINWHDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FormListAID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FormListAID) + ",");
MasterField.Append("BoatDate" + ",");
if (MasterEntity.BoatDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.BoatDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("dex" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.dex) + ",");
MasterField.Append("Code" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Code) + ",");
MasterField.Append("PrintStatus" + ",");
if (MasterEntity.PrintStatus != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.PrintStatus) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("TotalBulk" + ")");
if (MasterEntity.TotalBulk != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.TotalBulk) + ")");
}
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
{
ShipBoat MasterEntity = (ShipBoat)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Ship_ShipBoat SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" IvoiceNo=" + SysString.ToDBString(MasterEntity.IvoiceNo) + ",");
UpdateBuilder.Append(" CompanyTypeID=" + SysString.ToDBString(MasterEntity.CompanyTypeID) + ",");
UpdateBuilder.Append(" SaleNo=" + SysString.ToDBString(MasterEntity.SaleNo) + ",");
UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ",");
UpdateBuilder.Append(" Model=" + SysString.ToDBString(MasterEntity.Model) + ",");
UpdateBuilder.Append(" ModelEn=" + SysString.ToDBString(MasterEntity.ModelEn) + ",");
if (MasterEntity.ShipDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" ShipDate=" + SysString.ToDBString(MasterEntity.ShipDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" ShipDate=null,");
}
if (MasterEntity.RevisedDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" RevisedDate=" + SysString.ToDBString(MasterEntity.RevisedDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" RevisedDate=null,");
}
if (MasterEntity.OutDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" OutDate=" + SysString.ToDBString(MasterEntity.OutDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" OutDate=null,");
}
UpdateBuilder.Append(" TradeType=" + SysString.ToDBString(MasterEntity.TradeType) + ",");
UpdateBuilder.Append(" GainType=" + SysString.ToDBString(MasterEntity.GainType) + ",");
UpdateBuilder.Append(" ReceiveType=" + SysString.ToDBString(MasterEntity.ReceiveType) + ",");
UpdateBuilder.Append(" TransType=" + SysString.ToDBString(MasterEntity.TransType) + ",");
UpdateBuilder.Append(" ShipTo=" + SysString.ToDBString(MasterEntity.ShipTo) + ",");
UpdateBuilder.Append(" FactoryID=" + SysString.ToDBString(MasterEntity.FactoryID) + ",");
if (MasterEntity.OutFacDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" OutFacDate=" + SysString.ToDBString(MasterEntity.OutFacDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" OutFacDate=null,");
}
if (MasterEntity.ExportDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" ExportDate=" + SysString.ToDBString(MasterEntity.ExportDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" ExportDate=null,");
}
UpdateBuilder.Append(" Messrs=" + SysString.ToDBString(MasterEntity.Messrs) + ",");
UpdateBuilder.Append(" SpeRequest=" + SysString.ToDBString(MasterEntity.SpeRequest) + ",");
UpdateBuilder.Append(" SCNo=" + SysString.ToDBString(MasterEntity.SCNo) + ",");
UpdateBuilder.Append(" BoatName=" + SysString.ToDBString(MasterEntity.BoatName) + ",");
UpdateBuilder.Append(" Container=" + SysString.ToDBString(MasterEntity.Container) + ",");
UpdateBuilder.Append(" Special=" + SysString.ToDBString(MasterEntity.Special) + ",");
if (MasterEntity.CroosWeight != 0)
{
UpdateBuilder.Append(" CroosWeight=" + SysString.ToDBString(MasterEntity.CroosWeight) + ",");
}
else
{
UpdateBuilder.Append(" CroosWeight=null,");
}
if (MasterEntity.NetWeight != 0)
{
UpdateBuilder.Append(" NetWeight=" + SysString.ToDBString(MasterEntity.NetWeight) + ",");
}
else
{
UpdateBuilder.Append(" NetWeight=null,");
}
if (MasterEntity.PackNum != 0)
{
UpdateBuilder.Append(" PackNum=" + SysString.ToDBString(MasterEntity.PackNum) + ",");
}
else
{
UpdateBuilder.Append(" PackNum=null,");
}
UpdateBuilder.Append(" Shippers=" + SysString.ToDBString(MasterEntity.Shippers) + ",");
UpdateBuilder.Append(" Consignee=" + SysString.ToDBString(MasterEntity.Consignee) + ",");
UpdateBuilder.Append(" NotifyParty=" + SysString.ToDBString(MasterEntity.NotifyParty) + ",");
UpdateBuilder.Append(" PortLoading=" + SysString.ToDBString(MasterEntity.PortLoading) + ",");
UpdateBuilder.Append(" PortDischarge=" + SysString.ToDBString(MasterEntity.PortDischarge) + ",");
UpdateBuilder.Append(" LCNo=" + SysString.ToDBString(MasterEntity.LCNo) + ",");
UpdateBuilder.Append(" DelFlag=" + SysString.ToDBString(MasterEntity.DelFlag) + ",");
if (MasterEntity.AddTime != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" AddTime=" + SysString.ToDBString(MasterEntity.AddTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" AddTime=null,");
}
UpdateBuilder.Append(" AddOPID=" + SysString.ToDBString(MasterEntity.AddOPID) + ",");
if (MasterEntity.UpdTime != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" UpdTime=" + SysString.ToDBString(MasterEntity.UpdTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" UpdTime=null,");
}
UpdateBuilder.Append(" UpdOPID=" + SysString.ToDBString(MasterEntity.UpdOPID) + ",");
UpdateBuilder.Append(" SubmitFlag=" + SysString.ToDBString(MasterEntity.SubmitFlag) + ",");
if (MasterEntity.SubmitTime != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" SubmitTime=" + SysString.ToDBString(MasterEntity.SubmitTime.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" SubmitTime=null,");
}
UpdateBuilder.Append(" SubmitOPID=" + SysString.ToDBString(MasterEntity.SubmitOPID) + ",");
UpdateBuilder.Append(" AuditFlag=" + SysString.ToDBString(MasterEntity.AuditFlag) + ",");
UpdateBuilder.Append(" FromOPName=" + SysString.ToDBString(MasterEntity.FromOPName) + ",");
UpdateBuilder.Append(" ToOPName=" + SysString.ToDBString(MasterEntity.ToOPName) + ",");
if (MasterEntity.GoodsINWHDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" GoodsINWHDate=" + SysString.ToDBString(MasterEntity.GoodsINWHDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" GoodsINWHDate=null,");
}
UpdateBuilder.Append(" FormListAID=" + SysString.ToDBString(MasterEntity.FormListAID) + ",");
if (MasterEntity.BoatDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" BoatDate=" + SysString.ToDBString(MasterEntity.BoatDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" BoatDate=null,");
}
UpdateBuilder.Append(" dex=" + SysString.ToDBString(MasterEntity.dex) + ",");
UpdateBuilder.Append(" Code=" + SysString.ToDBString(MasterEntity.Code) + ",");
if (MasterEntity.PrintStatus != 0)
{
UpdateBuilder.Append(" PrintStatus=" + SysString.ToDBString(MasterEntity.PrintStatus) + ",");
}
else
{
UpdateBuilder.Append(" PrintStatus=null,");
}
if (MasterEntity.TotalBulk != 0)
{
UpdateBuilder.Append(" TotalBulk=" + SysString.ToDBString(MasterEntity.TotalBulk));
}
else
{
UpdateBuilder.Append(" TotalBulk=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>
/// <returns></returns>
private ShipBoat EntityGet()
{
ShipBoat entity = new ShipBoat();
entity.ID = HTDataID;
entity.SelectByID();
entity.IvoiceNo = txtIvoiceNo.Text.Trim();
entity.CompanyTypeID = SysConvert.ToInt32(txtCompanyTypeID.Text.Trim());
entity.SaleNo = txtSaleNo.Text.Trim();
entity.VendorID = drpVendorID.EditValue.ToString();
entity.Model = txtModel.Text.Trim();
entity.ModelEn = txtModelEn.Text.Trim();
entity.TradeType = drpTradeType.EditValue.ToString();
entity.GainType = drpGainType.EditValue.ToString();
entity.ReceiveType = drpReceiveType.EditValue.ToString();
entity.TransType = drpTransType.EditValue.ToString();
entity.ShipTo = txtShipTo.Text.Trim();
entity.FactoryID = txtCode.Text.Trim();
//entity.FactoryID = drpFactoryID.EditValue.ToString();
entity.FormListAID = this.FormListAID;
entity.Messrs = txtMessrs.Text.Trim();
entity.SpeRequest = txtSpeRequest.Text.Trim();
entity.SCNo = SysConvert.ToString(drpY_DPay.EditValue); //预到付
entity.BoatName = SysConvert.ToString(drpZY.EditValue); //是否转运
entity.Container = SysConvert.ToString(drpFS.EditValue); //B/L份数 7月21日改是否分批
entity.GoodsINWHDate = Common.GetWorkDays(txtINWHDate.DateTime);
entity.FromOPName = SysConvert.ToString(drpFROM.EditValue);
entity.ToOPName = SysConvert.ToString(drpTO.EditValue);
entity.Special = txtSpecial.Text.Trim();
entity.TotalBulk = SysConvert.ToDecimal(txtTotalBulk.Text.Trim());
entity.CroosWeight = SysConvert.ToDecimal(txtCroosWeight.Text.Trim());
entity.NetWeight = SysConvert.ToDecimal(txtNetWeight.Text.Trim());
entity.PackNum = SysConvert.ToDecimal(txtPackNum.Text.Trim());
entity.Shippers = txtShippers.Text.Trim();
//entity.Shippers = SysConvert.ToString(txtShippers.Text.Trim());
entity.Consignee = txtConsignee.Text.Trim();
entity.NotifyParty = txtNotifyParty.Text.Trim();
entity.PortLoading = txtPortLoading.Text.Trim();
entity.dex = txtdex.Text.Trim();
entity.Code = txtCode.Text.Trim();
entity.PortDischarge = txtXL.Text.Trim();
entity.LCNo = txtLCNo.Text.Trim();//公司编号
if (entity.AddOPID == "")
{
entity.AddOPID = FParamConfig.LoginName;
entity.AddTime = Common.GetWorkDays(DateTime.Now);
}
entity.UpdOPID = FParamConfig.LoginName;
entity.UpdTime = Common.GetWorkDays(DateTime.Now);
if (txtShipDate.DateTime != SystemConfiguration.DateTimeDefaultValue && txtShipDate.Text != "")
{
entity.ShipDate = Common.GetWorkDays(txtShipDate.DateTime.Date);
}
if (txtRevisedDate.DateTime != SystemConfiguration.DateTimeDefaultValue && txtRevisedDate.Text != "")
{
entity.RevisedDate = Common.GetWorkDays(txtRevisedDate.DateTime.Date);
}
if (txtOutDate.DateTime != SystemConfiguration.DateTimeDefaultValue && txtOutDate.Text != "")
{
entity.OutDate = Common.GetWorkDays(txtOutDate.DateTime.Date);
}
if (txtOutFacDate.DateTime != SystemConfiguration.DateTimeDefaultValue && txtOutFacDate.Text != "")
{
entity.OutFacDate = Common.GetWorkDays(txtOutFacDate.DateTime.Date);
}
if (txtExportDate.DateTime != SystemConfiguration.DateTimeDefaultValue && txtExportDate.Text != "")
{
entity.ExportDate = Common.GetWorkDays(txtExportDate.DateTime.Date);
}
return(entity);
}
/// <summary>
/// 设置
/// </summary>
public override void EntitySet()
{
ShipBoat entity = new ShipBoat();
entity.ID = HTDataID;
bool findFlag = entity.SelectByID();
txtIvoiceNo.Text = entity.IvoiceNo.ToString();
txtCompanyTypeID.Text = entity.CompanyTypeID.ToString();
txtSaleNo.Text = entity.SaleNo.ToString();
drpVendorID.EditValue = entity.VendorID.ToString();
txtModel.Text = entity.Model.ToString();
txtModelEn.Text = entity.ModelEn.ToString();
drpTradeType.EditValue = entity.TradeType.ToString();
drpGainType.EditValue = entity.GainType.ToString();
drpReceiveType.EditValue = entity.ReceiveType.ToString();
drpTransType.EditValue = entity.TransType.ToString();
txtShipTo.Text = entity.ShipTo.ToString();
drpFactoryID.EditValue = entity.FactoryID.ToString();
txtMessrs.Text = entity.Messrs.ToString();
txtSpeRequest.Text = entity.SpeRequest.ToString();
//txtSCNo.Text = entity.SCNo.ToString();
//txtBoatName.Text = entity.BoatName.ToString();
txtdex.Text = entity.dex.ToString();
txtCode.Text = entity.Code.ToString();
drpY_DPay.EditValue = entity.SCNo.ToString(); //预到付
drpZY.EditValue = entity.BoatName.ToString(); //是否分批/转运
drpFS.EditValue = entity.Container.ToString(); //B/L份数
txtINWHDate.DateTime = entity.GoodsINWHDate;
drpFROM.EditValue = entity.FromOPName;
drpTO.EditValue = entity.ToOPName;
txtSpecial.Text = entity.Special.ToString();
txtTotalBulk.Text = entity.TotalBulk.ToString();
txtCroosWeight.Text = entity.CroosWeight.ToString();
txtNetWeight.Text = entity.NetWeight.ToString();
txtPackNum.Text = entity.PackNum.ToString();
txtShippers.Text = entity.Shippers.ToString();
//drpShippers.EditValue = entity.Shippers.ToString();
txtConsignee.Text = entity.Consignee.ToString();
txtNotifyParty.Text = entity.NotifyParty.ToString();
txtPortLoading.Text = entity.PortLoading.ToString();
txtXL.EditValue = entity.PortDischarge.ToString();
txtLCNo.Text = entity.LCNo.ToString();
txtShipDate.DateTime = entity.ShipDate;
txtRevisedDate.DateTime = entity.RevisedDate;
txtOutDate.DateTime = entity.OutDate;
txtOutFacDate.DateTime = entity.OutFacDate;
txtExportDate.DateTime = entity.ExportDate;
if (txtShipDate.DateTime == SystemConfiguration.DateTimeDefaultValue)
{
txtShipDate.Text = "";
}
if (txtOutDate.DateTime == SystemConfiguration.DateTimeDefaultValue)
{
txtOutDate.Text = "";
}
if (txtRevisedDate.DateTime == SystemConfiguration.DateTimeDefaultValue)
{
txtRevisedDate.Text = "";
}
if (txtOutFacDate.DateTime == SystemConfiguration.DateTimeDefaultValue)
{
txtOutFacDate.Text = "";
}
if (txtExportDate.DateTime == SystemConfiguration.DateTimeDefaultValue)
{
txtExportDate.Text = "";
}
HTDataSubmitFlag = entity.SubmitFlag;
HTDataDelFlag = entity.DelFlag;
if (!findFlag)
{
}
BindGridDts();
}
