/// <summary>
/// 修改
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="p_BE3">原料</param>
/// <param name="p_BE4">颜色</param>
/// <param name="p_BE5">类别</param>
/// <param name="p_BE6">物理指标</param>
/// <param name="p_BE7">替代白坯</param>
/// <param name="p_BE8">工厂编码及报价</param>
public void RUpdate(BaseEntity p_BE, BaseEntity[] p_BE3, BaseEntity[] p_BE4, BaseEntity[] p_BE5, BaseEntity[] p_BE6, BaseEntity[] p_BE7, BaseEntity[] p_BE8)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RUpdate(p_BE, p_BE3, p_BE4, p_BE5, p_BE6, p_BE7, p_BE8, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, BaseEntity[] p_BE3, BaseEntity[] p_BE4, int p_Flag)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RAdd(p_BE, p_BE2, p_BE3, p_BE4, p_Flag, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RSave(BaseEntity p_BEMain, ArrayList p_BEDts)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RSave(p_BEMain, p_BEDts, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
public void RDelete(BaseEntity p_BE)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RDelete(p_BE, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
private void btnJYClear_Click(object sender, EventArgs e)//清除留样客户名称sc 2013.11.13
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.BaseFocusLabel.Focus();
string sql = "";
for (int i = 0; i < gridView1.RowCount; i++)
{
if (SysConvert.ToInt32(gridView1.GetRowCellValue(i, "SelectFlag")) == 1)
{
sql = "Update Dev_GBJCDts set JYVendorID = '',JYVendorName = '' ";
sql += "WHERE (MainID = " + SysConvert.ToString(gridView1.GetRowCellValue(i, "MainID"));
sql += " AND";
sql += " Seq = " + SysConvert.ToString(gridView1.GetRowCellValue(i, "Seq")) + ")";
sqlTrans.ExecuteNonQuery(sql);
}
}
sqlTrans.CommitTrans();
BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 获得单据号码
/// </summary>
/// <param name="p_FormNoID">单据ID</param>
/// <param name="p_Num">第几个单据号码0,1,2,</param>
public string RGetFormNo(int p_FormNoID, int p_Num)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
string outstr = this.RGetFormNo(p_FormNoID, p_Num, sqlTrans);
sqlTrans.CommitTrans();
return(outstr);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="p_BE"></param>
/// <param name="p_BESub"></param>
public void RSave(BaseEntity[] p_BE, BaseEntity[] p_BESub, string p_AuthGrpID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RSave(p_BE, p_BESub, p_AuthGrpID, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RAdd(int p_ID, string p_IDStr)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RAdd(p_ID, p_IDStr, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_TableName"></param>
/// <param name="p_TableID"></param>
/// <param name="p_Val"></param>
public void RDelete(string p_TableName, int p_TableID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RDelete(p_TableName, p_TableID, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 撤销核销处理
/// </summary>
public void RHXCancel(InvoiceOperation entity, int p_DtsID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RHXCancel(entity, p_DtsID, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
public void RDelLR(int HTDataID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RDelLR(HTDataID, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_BE">要修改的实体</param>
public void RUpdate(string p_GBCode, int p_SubmitFlag, int p_MainID, int LYFlag, string p_OPID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RUpdate(p_GBCode, p_SubmitFlag, p_MainID, LYFlag, p_OPID, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增
/// </summary>
public int RAdd(byte[] p_File, int winListID, int headtype, int subtype, int dataid, int dataSeq, string fileName, string filetitle, string fileExec, string p_Remark, string p_FileProt1, string p_FileProt2, decimal fileSize, string LoginID, string LoginName, int loginLogID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess(SystemConfiguration.ConnectionString);
try
{
sqlTrans.OpenTrans();
int outid = RAdd(p_File, winListID, headtype, subtype, dataid, dataSeq, fileName, filetitle, fileExec, p_Remark, p_FileProt1, p_FileProt2, fileSize, LoginID, LoginName, loginLogID, sqlTrans);
sqlTrans.CommitTrans();
return(outid);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 扫描数据
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public int RScan(int p_ID, string p_ISN, int p_YPQty, string p_Vendorid, int p_ZHID, DateTime p_Time)
{
int outi = 0;
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
outi = this.RScan(p_ID, p_ISN, p_YPQty, p_Vendorid, p_ZHID, p_Time, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
return(outi);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RSave(int p_ID, int p_MainID, int p_Seq, BaseEntity[] p_BE, bool p_UpdateFlag)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RSave(p_ID, p_MainID, p_Seq, p_BE, p_UpdateFlag, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
//public int FindStorge(string p_WHID, string p_SectionID, string p_SBitID, int p_CompanyTypeID, string p_ItemCode, string p_Batch, string p_VendorBatch, string p_JarNum, string p_ColorNum, string p_ColorName, string p_Needle, string p_YarnStatus, string p_DtsSO, int p_WHTypeID, string p_SizeName)
//{
// try
// {
// IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
// try
// {
// sqlTrans.OpenTrans();
// return FindStorge(p_WHID, p_SectionID, p_SBitID, p_CompanyTypeID, p_ItemCode, p_Batch, p_VendorBatch, p_JarNum, p_ColorNum, p_ColorName, p_Needle, p_YarnStatus, p_DtsSO, p_WHTypeID, p_SizeName, sqlTrans);
// sqlTrans.CommitTrans();
// }
// catch (Exception TE)
// {
// sqlTrans.RollbackTrans();
// throw TE;
// }
// }
// catch (BaseException)
// {
// throw;
// }
// catch (Exception E)
// {
// throw new BaseException(E.Message);
// }
//}
///// <summary>
///// 判断库存表是否存在该记录
///// </summary>
///// <param name="p_WHID"></param>
///// <param name="p_SectionID"></param>
///// <param name="p_SBitID"></param>
///// <param name="p_ItemCode"></param>
///// <param name="p_Batch"></param>
///// <param name="p_JarNum"></param>
///// <param name="p_ColorNum"></param>
///// <param name="sqlTrans"></param>
///// <returns>返回ID</returns>
//public int FindStorge(string p_WHID, string p_SectionID, string p_SBitID, int p_CompanyTypeID, string p_ItemCode, string p_Batch, string p_VendorBatch, string p_JarNum, string p_ColorNum, string p_ColorName, string p_Needle, string p_YarnStatus, string p_DtsSO, int p_WHTypeID, string p_SizeName, IDBTransAccess sqlTrans)
//{
// string sql="SELECT WHCalMethodID FROM WH_WH WHERE WHID="+SysString.ToDBString(p_WHID);
// int CalType = (int)EnumWHCalMethod.按编号;//
// DataTable dt = sqlTrans.Fill(sql);//获得当前仓库的结算方式
// if (dt.Rows.Count != 0)
// {
// CalType = SysConvert.ToInt32(dt.Rows[0][0].ToString());
// }
// else
// {
// CalType = (int)EnumWHCalMethod.按编号客户批号本厂批号;
// }
// sql="SELECT ID FROM WH_Storge WHERE WHID="+SysString.ToDBString(p_WHID)+" AND SectionID="+SysString.ToDBString(p_SectionID);
// sql+=" AND SBitID="+SysString.ToDBString(p_SBitID);
// switch (CalType)
// {
// case (int)EnumWHCalMethod.按编号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// break;
// case (int)EnumWHCalMethod.按编号客户批号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// break;
// case (int)EnumWHCalMethod.按编号本厂批号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// break;
// case (int)EnumWHCalMethod.按编号色号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// break;
// case (int)EnumWHCalMethod.按编号缸号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// break;
// case (int)EnumWHCalMethod.按编号色号缸号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号色号缸号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// break;
// case (int)EnumWHCalMethod.按编号针型:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Needle=" + SysString.ToDBString(p_Needle);
// break;
// case (int)EnumWHCalMethod.按编号色号缸号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号色号缸号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号订单号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND DtsSO=" + SysString.ToDBString(p_DtsSO);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号色号缸号定单号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND DtsSO=" + SysString.ToDBString(p_DtsSO);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号色号缸号订单号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND DtsSO=" + SysString.ToDBString(p_DtsSO);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号色号色名缸号订单号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND DtsSO=" + SysString.ToDBString(p_DtsSO);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号客户批号本厂批号色号色名缸号订单号纱线形态:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND Batch=" + SysString.ToDBString(p_Batch);
// sql += " AND VendorBatch=" + SysString.ToDBString(p_VendorBatch);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// sql += " AND DtsSO=" + SysString.ToDBString(p_DtsSO);
// sql += " AND YarnStatus=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号色号色名缸号纱线形态:
// sql += " AND ISNULL(ItemCode,'')=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ISNULL(ColorNum,'')=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND ISNULL(DesignNO,'')=" + SysString.ToDBString(p_DesignNO);
// sql += " AND ISNULL(ColorName,'')=" + SysString.ToDBString(p_ColorName);
// sql += " AND ISNULL(JarNum,'')=" + SysString.ToDBString(p_JarNum);
// sql += " AND ISNULL(YarnStatus,'')=" + SysString.ToDBString(p_YarnStatus);
// break;
// case (int)EnumWHCalMethod.按编号色号色名缸号:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// sql += " AND JarNum=" + SysString.ToDBString(p_JarNum);
// break;
// case (int)EnumWHCalMethod.按编号针型色号色名:
// sql += " AND ItemCode=" + SysString.ToDBString(p_ItemCode);
// sql += " AND ColorNum=" + SysString.ToDBString(p_ColorNum);
// //sql += " AND DesignNO=" + SysString.ToDBString(p_DesignNO);
// sql += " AND ColorName=" + SysString.ToDBString(p_ColorName);
// sql += " AND Needle=" + SysString.ToDBString(p_Needle);
// break;
// }
// DataTable dtlog = sqlTrans.Fill(sql);
// if (dtlog.Rows.Count > 0)
// {
// return SysConvert.ToInt32(dtlog.Rows[0][0].ToString());
// }
// else
// {
// return 0;
// }
//}
#endregion
#region 更新库存数据
/// <summary>
/// 更新库存
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void UpdateStorge(int p_StorgeID, float P_LockQty, bool p_Flag)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.UpdateStorge(p_StorgeID, P_LockQty, p_Flag, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 保存资金明细
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RSaveBuyCap(ItemBuyForm p_BEMain)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RSaveBuyCap(p_BEMain, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增录入校验
/// </summary>
/// <param name="p_MainID">主表ID</param>
public bool RAddCheck(int p_MainID, out string o_ErrorMSG)
{
bool outb = true;
o_ErrorMSG = string.Empty;
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
outb = this.RAddCheck(p_MainID, out o_ErrorMSG, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
return(outb);
}
/// <summary>
/// 保存权限组
/// </summary>
/// <param name="p_Al">部门Arraylist</param>
public void RSaveAuthGrp(ArrayList p_Al, string p_OPID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
string sql = "DELETE FROM Data_OPAuthGrp WHERE OPID=" + SysString.ToDBString(p_OPID);//
sqlTrans.ExecuteNonQuery(sql);
for (int i = 0; i < p_Al.Count; i++)
{
sql = "INSERT INTO Data_OPAuthGrp(OPID,AuthGrpID) VALUES(" + SysString.ToDBString(p_OPID) + "," + SysString.ToDBString(p_Al[i].ToString()) + ")";//
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>
/// <param name="p_ClsA"></param>
/// <param name="p_ClsB"></param>
/// <param name="p_SubTypeID">子类型ID</param>
/// <returns></returns>
public string RGetFormNo(string p_ClsA, string p_ClsB, int p_SubTypeID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
string outstr = string.Empty;
sqlTrans.OpenTrans();
outstr = this.RGetFormNo(p_ClsA, p_ClsB, p_SubTypeID, sqlTrans);
sqlTrans.CommitTrans();
return(outstr);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 锁定库存
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RLock(BaseEntity p_BE, bool p_CheckLockNum)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RLock(p_BE, p_CheckLockNum, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_BE">要修改的实体</param>
public void RUpdate(BaseEntity p_BE, BaseEntity[] p_BE2, ArrayList list)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RUpdate(p_BE, p_BE2, list, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 解锁
/// </summary>
/// <param name="p_StorgeLockID">原锁定库存ID</param>
/// <param name="p_UnLockQty">解锁数量</param>
/// <param name="p_Remark">解锁备注</param>
/// <param name="p_AboveFlag">超过解锁数量是否提示 1/0：提示/不提示</param>
public void RUnLock(int p_StorgeLockID, decimal p_UnLockQty, string p_Remark, bool p_AboveFlag)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RUnLock(p_StorgeLockID, p_UnLockQty, p_Remark, p_AboveFlag, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 审核
/// </summary>
/// <param name="p_FormID">单据ID</param>
/// <param name="p_Type">0/1:弃审/审核</param>
public void RSubmit(int p_FormID, int p_Type)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RSubmit(p_FormID, p_Type, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 扫描数据 确认完成
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public int RScanOK(int p_ID)
{
int outi = 0;
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
outi = this.RScanOK(p_ID, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
return(outi);
}
/// <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>
/// <param name="p_condition"></param>
public DataTable RShow(string p_condition, string p_FieldName)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess(SystemConfiguration.ConnectStringSecond);
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM Pro_TecFile WHERE 1=1";
sql += p_condition;
return(sqlTrans.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
/// ±£´æ
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
string[] listm_GBCode = m_GBCode.Split(new char[1] {
','
});
for (int i = 0; i < listm_GBCode.Length; i++)
{
string sql = "UPDATE Data_ItemGB SET XY=" + SysConvert.ToInt32(drpXY.EditValue);
sql += ",XYDesc=" + SysString.ToDBString(txtXYDesc.Text.Trim());
sql += ",GBDesc=" + SysString.ToDBString(txtGBDesc.Text.Trim());
sql += ",Remark=" + SysString.ToDBString(txtDRemark.Text.Trim());
sql += " WHERE GBCode=" + SysString.ToDBString(listm_GBCode[i]);
sqlTrans.ExecuteNonQuery(sql);
}
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
this.Close();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 装箱
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPack_Click(object sender, EventArgs e)
{
string sql = "SELECT * FROM WO_ISNTemp WHERE Status=1 ORDER BY Sort ASC ";
DataTable dt = SysUtils.Fill(sql);//读取待装箱数据
DataTable dttemp = new DataTable();
if (CheckISNRule(dt, out dttemp))//条码校验合格后插入包装表中
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
InsertPackISN(dttemp, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
BindScanISN();
BindPack();
}
/// <summary>
/// 插入读出的条码
/// </summary>
/// <param name="ScanISN"></param>
private void InsertISN(List <string> ScanISN)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
ISNTempRule rule = new ISNTempRule();
int index = 1;
foreach (string ISN in ScanISN)
{
ISNTemp entity = new ISNTemp(sqlTrans);
entity.ISN = ISN;
entity.Status = 1;
entity.Sort = index;
entity.ImportTime = DateTime.Now;
rule.RAdd(entity, sqlTrans);
index++;
}
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
