public static bool AddAdjust(StorageAdjustModel model, List<StorageAdjustDetail> detail, Hashtable ht)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.AdjustNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
succ = StorageAdjustDBHelper.AddAdjust(model,detail,ht);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
model.ID = IDIdentityUtil.GetIDIdentity("officedba.StorageAdjust");
}
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return false;
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
StorageAdjustModel model = new StorageAdjustModel();
model.CompanyCD = companyCD;
model.Title = this.txtSubject.Text.Trim();
model.AdjustNo = this.txtReportNo.Text.Trim();
model.StorageID = int.Parse(this.hiddenStorageID.SelectedValue);
model.BillStatus = BillStatus.Value;
string theBeginTime = this.BeginTime.Value;
string theEndTime = this.EndTime.Value;
model.Executor = int.Parse(hiddenExecutor.Value);
model.DeptID = int.Parse(hiddenDeptID.Value);
model.ReasonType = int.Parse(ddlReason.SelectedValue);
string theFlowStatus = FlowStatus.Value;
int TotalCount = 0;
string EFIndex = Request.QueryString["EFIndex"];
string EFDesc = Request.QueryString["EFDesc"];
GetBillExAttrControl2.ExtIndex = EFIndex;
GetBillExAttrControl2.ExtValue = EFDesc;
GetBillExAttrControl2.SetExtControlValue();
model.Attachment = " ID Desc";
if (this.hiddenOrder.Value != "0")
{
string[] myOrder = this.hiddenOrder.Value.Split('_');
if (myOrder[1] == "a")
{
model.Attachment = myOrder[0] + " asc ";
}
else
{
model.Attachment = myOrder[0] + " desc ";
}
}
model.Creator = -100;
model.Confirmor = -100;
string BatchNo = this.txtBatchNo.Value.ToString();
model.BatchNo = BatchNo;
DataTable dt = StorageAdjustBus.GetAllAdjust(model,EFIndex,EFDesc, theBeginTime, theEndTime, theFlowStatus, ref TotalCount);
//导出标题
string headerTitle = "单据编号|单据主题|仓库|经办人|部门|调整时间|调整原因|单据状态|审批状态";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "AdjustNo|Title|StorageName|EmployeeName|DeptName|AdjustDate|CodeName|BillStatus|FlowStatus";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "日常调整单列表");
}
catch
{ }
}
public static bool UpdateAdjust(StorageAdjustModel model, List<StorageAdjustDetail> detail, string[] SortID, Hashtable ht)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.AdjustNo);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = StorageAdjustDBHelper.UpdateAdjust(model, detail, SortID,ht);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return false;
}
}
public static DataTable GetAdjustDetail(StorageAdjustModel model)
{
return StorageAdjustDBHelper.GetAdjustDetail(model);
}
/// <summary>
/// 取消确认
/// </summary>
/// <param name="model"></param>
/// <param name="detail"></param>
/// <returns></returns>
public static bool UnConfirmBill(StorageAdjustModel model,List<StorageAdjustDetail> detail)
{
return StorageAdjustDBHelper.UnConfirmBill(model, detail);
}
public static DataTable GetAllAdjust(StorageAdjustModel model,string EFIndex,string EFDesc, string BetinTime, string EndTime, string FlowStatus,ref int TotalCount)
{
return StorageAdjustDBHelper.GetAllAdjust(model, EFIndex, EFDesc,BetinTime,EndTime,FlowStatus,ref TotalCount);
}
public static bool CloseBill(StorageAdjustModel model, string method)
{
return StorageAdjustDBHelper.CloseBill(model, method);
}
public static DataTable GetAdjustDetail(StorageAdjustModel model)
{
string sql = "";
sql += " SELECT s.[ID] ";
sql += " ,isnull(s.[AdjustNo],'') as AdjustNo,s.BatchNo,s.UsedUnitID,s.UsedUnitCount,s.UsedPrice,s.ExRate,p.IsBatchNo ";
sql += " ,isnull(s.[SortNo],0) as SortNo ";
sql += " ,isnull(s.[ProductID],0) as ProductID ";
sql += " ,isnull(s.[UnitID],0) as UnitID ";
sql += " ,isnull(s.[AdjustType],'') as AdjustType ";
sql += " ,isnull(s.[AdjustCount],0) as AdjustCount ";
sql += " ,isnull(s.[CostPrice],0) as CostPrice ";
sql += " ,isnull(s.[CostPriceTotal],0) as CostPriceTotal ";
sql += " ,isnull(s.[Remark],'') as Remark ";
sql += " ,isnull(p.ProductName,'') as ProductName ";
sql += " ,isnull(p.ProdNo,'') as ProNo ";
sql += " ,isnull(c.CodeName,'') as CodeName ";
sql += " FROM [officedba].[StorageAdjustDetail] as s left join officedba.ProductInfo as p on s.ProductID=p.ID ";
sql += " left join officedba.CodeUnitType as c on s.UnitID=c.ID ";
sql += " where s.CompanyCD=@CompanyCD and s.AdjustNo=(select top 1 AdjustNo from [officedba].[StorageAdjust] where ID=@ID) ";
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID", model.ID.ToString()));
//指定命令的SQL文
comm.CommandText = sql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
public static DataTable GetAdjustInfo(StorageAdjustModel model)
{
string sql = "";
sql += " SELECT [ID] ";
sql += " ,[AdjustNo] ";
sql += " ,isnull([StorageID],0) as StorageID ";
sql += " ,[ReasonType] ";
sql += " ,[Executor] ";
sql += " ,isnull([DeptID],0) as DeptID ";
sql += " ,isnull(CONVERT(varchar,[AdjustDate],120),'')as AdjustDate ";
sql += " ,isnull(TotalPrice,0) TotalPrice ";
sql += " ,isnull(CountTotal,0) CountTotal ";
sql += " ,isnull([Summary],'') as Summary ";
sql += " ,isnull([ExtField1],'') as ExtField1 ";
sql += " ,isnull([ExtField2],'') as ExtField2 ";
sql += " ,isnull([ExtField3],'') as ExtField3 ";
sql += " ,isnull([ExtField4],'') as ExtField4 ";
sql += " ,isnull([ExtField5],'') as ExtField5 ";
sql += " ,isnull([ExtField6],'') as ExtField6 ";
sql += " ,isnull([ExtField7],'') as ExtField7 ";
sql += " ,isnull([ExtField8],'') as ExtField8 ";
sql += " ,isnull([ExtField9],'') as ExtField9 ";
sql += " ,isnull([ExtField10],'') as ExtField10 ";
sql += " ,isnull([Remark],'') as Remark ";
sql += " ,Replace([Attachment],'\\',',') as Attachment ";
sql += " ,isnull(CONVERT(varchar,[CreateDate],120),'') as CreateDate ";
sql += " ,[BillStatus] ";
sql += " ,isnull(CONVERT(varchar,[ConfirmDate],120),'') as ConfirmDate ";
sql += " ,isnull(CONVERT(varchar,[CloseDate],120),'') as CloseDate ";
sql += " ,CONVERT(varchar,[ModifiedDate],120) as ModifiedDate ";
sql += " ,[ModifiedUserID] ";
sql += " ,isnull([Title],'') as Title ";
sql += " ,(select UserID from officedba.UserInfo where officedba.UserInfo.UserID=s.ModifiedUserID) as ModifiedUserIDName";
sql += " ,isnull((select DeptName from officedba.DeptInfo where officedba.DeptInfo.ID=s.DeptID),'') as DeptName ";
sql += " ,isnull((select EmployeeName from officedba.EmployeeInfo as e where e.ID=s.Closer),'') as CloserName ";
sql += " ,isnull((select EmployeeName from officedba.EmployeeInfo as e where e.ID=s.Executor),'') as ExecutorName ";
sql += " ,isnull((select EmployeeName from officedba.EmployeeInfo as e where e.ID=s.Confirmor),'') as ConfirmorName ";
sql += " ,isnull((select EmployeeName from officedba.EmployeeInfo as e where e.ID=s.Creator),'') as CreatorName ";
sql += " FROM [officedba].[StorageAdjust] as s ";
sql += " where s.CompanyCD=@CompanyCD and ID=@ID ";
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID", model.ID.ToString()));
//指定命令的SQL文
comm.CommandText = sql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
public static DataTable GetAllAdjust(StorageAdjustModel model,string EFIndex,string EFDesc, string BetinTime, string EndTime, string FlowStatus, ref int TotalCount)
{
string sql = "";
int BillTypeFlag = int.Parse(ConstUtil.CODING_RULE_Storage_NO);
int BillTypeCode = int.Parse(ConstUtil.CODING_RULE_StoAdjust_NO);
sql += " select * from (";
sql += " SELECT DISTINCT s.[ID],s.ModifiedDate ";
sql += " ,s.[AdjustNo] ";
sql += " ,isnull(s.[StorageID],0) as StorageID ";
sql += " ,s.[ReasonType] ";
sql += " ,isnull(s.[Executor],0) as Executor ";
sql += " ,isnull(s.[DeptID],0) as DeptID ";
sql += " ,isnull(substring(CONVERT(varchar,s.[AdjustDate],120),0,11),'') AdjustDate";
sql += " ,isnull(s.Title,'') as Title ";
sql += " ,s.[BillStatus] ";
sql += " ,isnull(e.EmployeeName,'') as EmployeeName ";
sql += " ,isnull(st.StorageName,'') as StorageName ";
sql += " ,isnull(d.DeptName,'') as DeptName ";
sql += " ,isnull(c.CodeName,'') as CodeName ";
sql += " ,isnull(f.FlowStatus,'0') as FlowStatusID";
sql += " ,CASE f.FlowStatus WHEN '1' THEN '待审批' WHEN '2' THEN '审批中' WHEN '3' THEN '审批通过' WHEN '4' THEN '审批不通过' when '5' then '撤消审批' ELSE '' END AS FlowStatus";
sql += " ,CASE s.BillStatus WHEN '1' THEN '制单' WHEN '2' THEN '执行' WHEN '3' THEN '变更' WHEN '4' THEN '手工结单' WHEN '5' THEN '自动结单' ELSE '' END AS BillStatusName ";
sql += " FROM [officedba].[StorageAdjust] as s left join officedba.StorageInfo as st on s.StorageID=st.ID ";
sql += " left join officedba.EmployeeInfo as e on s.Executor=e.ID left join officedba.DeptInfo as d on s.DeptID=d.ID ";
sql += " left join officedba.CodeReasonType as c on s.ReasonType=c.ID ";
sql += " left join officedba.StorageAdjustDetail as x on x.AdjustNo=s.AdjustNo and x.CompanyCD=s.CompanyCD ";
sql += " left join officedba.FlowInstance AS f ON s.CompanyCD = f.CompanyCD AND f.BillTypeFlag = " + BillTypeFlag + " AND f.BillTypeCode = " + BillTypeCode + " AND s.ID = f.BillID ";
sql += " and f.ID=(select max(ID) from officedba.FlowInstance where s.CompanyCD = officedba.FlowInstance.CompanyCD AND officedba.FlowInstance.BillTypeFlag = " + BillTypeFlag + " AND officedba.FlowInstance.BillTypeCode = " + BillTypeCode + " AND s.ID = officedba.FlowInstance.BillID) ";
sql += " where 1=1 ";
SqlCommand comm = new SqlCommand();
if (!string.IsNullOrEmpty(EFIndex) && !string.IsNullOrEmpty(EFDesc))
{
sql += " and s.ExtField" + EFIndex + " like @EFDesc ";
comm.Parameters.Add(SqlHelper.GetParameter("@EFDesc", "%" + EFDesc + "%"));
}
if (!string.IsNullOrEmpty(model.BatchNo))
{
sql += " and x.BatchNo = @BatchNo ";
comm.Parameters.Add(SqlHelper.GetParameterFromString("@BatchNo", model.BatchNo));
}
if (!string.IsNullOrEmpty(model.Title))
{
sql += " and s.Title like @Title ";
comm.Parameters.Add(SqlHelper.GetParameter("@Title", "%" + model.Title + "%"));
}
if (!string.IsNullOrEmpty(model.AdjustNo))
{
sql += " and s.AdjustNo like @AdjustNo ";
comm.Parameters.Add(SqlHelper.GetParameter("@AdjustNo", "%" + model.AdjustNo + "%"));
}
if (model.StorageID != 0)
{
sql += " and s.StorageID=@StorageID";
comm.Parameters.Add(SqlHelper.GetParameter("@StorageID", model.StorageID));
}
if (model.BillStatus != "00")
{
sql += " and s.BillStatus=@BillStatus";
comm.Parameters.Add(SqlHelper.GetParameter("@BillStatus", model.BillStatus));
}
if (!string.IsNullOrEmpty(BetinTime))
{
sql += " and s.AdjustDate>=@BeginTime";
comm.Parameters.Add(SqlHelper.GetParameter("@BeginTime", BetinTime));
}
if (!string.IsNullOrEmpty(EndTime))
{
sql += " and s.AdjustDate<=@EndTime";
comm.Parameters.Add(SqlHelper.GetParameter("@EndTime", EndTime));
}
if (FlowStatus != "00" && FlowStatus != "6")
{
sql += " and f.FlowStatus=@FlowStatus";
comm.Parameters.Add(SqlHelper.GetParameter("@FlowStatus", FlowStatus));
}
if (model.Executor != 0)
{
sql += " and s.Executor=@Executor";
comm.Parameters.Add(SqlHelper.GetParameter("@Executor", model.Executor));
}
if (model.DeptID != 0)
{
sql += " and s.DeptID=@DeptID";
comm.Parameters.Add(SqlHelper.GetParameter("@DeptID", model.DeptID));
}
if (model.ReasonType != 0)
{
sql += " and s.ReasonType=@ReasonType";
comm.Parameters.Add(SqlHelper.GetParameter("@ReasonType", model.ReasonType));
}
sql += " and c.CompanyCD=@CompanyCD ";
comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
sql += " ";
sql += " ) as Info";
if (FlowStatus == "6")
{
sql += " where FlowStatusID='0'";
}
if (model.Creator == -100)
{
sql += " order by " + model.Attachment;
}
comm.CommandText = sql;
DataTable dt = new DataTable();
if (model.Creator == -100)
{
dt = SqlHelper.ExecuteSearch(comm);
}
else
{
dt = SqlHelper.PagerWithCommand(comm, model.Creator, model.Confirmor, model.Attachment, ref TotalCount);
}
return dt;
}
public static bool CloseBill(StorageAdjustModel model, string method)
{
ArrayList listsql = new ArrayList();
SqlCommand comm = new SqlCommand();
StringBuilder sql = new StringBuilder();
sql.AppendLine(" UPDATE officedba.StorageAdjust SET");
sql.AppendLine(" BillStatus = 4,");
sql.AppendLine(" ModifiedUserID = @ModifiedUserID,");
if (method == "0")
{
sql.AppendLine(" Closer = @Closer,");
sql.AppendLine(" CloseDate = @CloseDate, ");
}
sql.AppendLine(" ModifiedDate = @ModifiedDate ");
sql.AppendLine(" Where CompanyCD=@CompanyCD and ID=@ID");
comm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
string BillStatus = "2";
if (method == "0")
{
comm.Parameters.Add(SqlHelper.GetParameter("@Closer", model.Closer));
comm.Parameters.Add(SqlHelper.GetParameter("@CloseDate", model.CloseDate));
BillStatus = "4";
}
comm.Parameters.Add(SqlHelper.GetParameter("@BillStatus", BillStatus));
comm.CommandText = sql.ToString();
listsql.Add(comm);
if (SqlHelper.ExecuteTransWithArrayList(listsql))
{ return true; }
else
{ return false; }
}
/// <summary>
/// 取消确认
/// </summary>
/// <param name="model"></param>
/// <param name="detail"></param>
/// <returns></returns>
public static bool UnConfirmBill(StorageAdjustModel model, List<StorageAdjustDetail> detail)
{
ArrayList sqllist = new ArrayList();
SqlCommand comm = new SqlCommand();
int BillTypeFlag = int.Parse(ConstUtil.CODING_RULE_Storage_NO);
int BillTypeCode = int.Parse(ConstUtil.CODING_RULE_StoAdjust_NO);
string theSql = "select BillStatus from officedba.StorageAdjust where ID=@ID";
comm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID));
comm.CommandText = theSql;
DataTable theDt = SqlHelper.ExecuteSearch(comm);
string BillStatus = "0";
if (theDt.Rows.Count > 0)
{
BillStatus = theDt.Rows[0]["BillStatus"].ToString();
}
if (BillStatus == "2")
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(" UPDATE officedba.StorageAdjust SET");
sql.AppendLine(" Confirmor = @Confirmor,");
sql.AppendLine(" ConfirmDate = @ConfirmDate,");
sql.AppendLine(" BillStatus = 2,");
sql.AppendLine(" ModifiedUserID = @ModifiedUserID,");
sql.AppendLine(" ModifiedDate = @ModifiedDate ");
sql.AppendLine(" Where CompanyCD=@CompanyCD and ID=@ID");
SqlCommand sqlcomm = new SqlCommand();
sqlcomm.CommandText = sql.ToString(); ;
SqlParameter[] param = new SqlParameter[6];
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@Confirmor", model.Confirmor));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ConfirmDate", model.ConfirmDate));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
sqllist.Add(sqlcomm);
for (int i = 0; i < detail.Count; i++)
{
string upsql = "";
if (detail[i].AdjustType == "1")//增加
{
upsql += " update officedba.StorageProduct set ProductCount=isnull(ProductCount,0)-@ProductCount where CompanyCD=@CompanyCD and ProductID=@ProductID and StorageID=@StorageID";
}
else
{
upsql += " update officedba.StorageProduct set ProductCount=isnull(ProductCount,0)+@ProductCount where CompanyCD=@CompanyCD and ProductID=@ProductID and StorageID=@StorageID";
}
if (detail[i].BatchNo != "")
upsql += " and BatchNo='" + detail[i].BatchNo.Trim() + "' ";
else
upsql += " and BatchNo is null ";
SqlCommand upcomm = new SqlCommand();
upcomm.CommandText = upsql;
upcomm.Parameters.Add(SqlHelper.GetParameter("@ProductCount", detail[i].AdjustCount));
upcomm.Parameters.Add(SqlHelper.GetParameter("@ProductID", detail[i].ProductID.ToString()));
upcomm.Parameters.Add(SqlHelper.GetParameter("@StorageID", model.StorageID));
upcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
sqllist.Add(upcomm);
}
#region 撤消审批流程
DataTable dtFlowInstance = Common.FlowDBHelper.GetFlowInstanceInfo(model.CompanyCD, BillTypeFlag, BillTypeCode, model.ID);
if (dtFlowInstance.Rows.Count > 0)
{
//提交审批了的单据
string FlowInstanceID = dtFlowInstance.Rows[0]["FlowInstanceID"].ToString();
string FlowStatus = dtFlowInstance.Rows[0]["FlowStatus"].ToString();
string FlowNo = dtFlowInstance.Rows[0]["FlowNo"].ToString();
#region 往流程任务历史记录表
StringBuilder sqlHis = new StringBuilder();
sqlHis.AppendLine("Insert into officedba.FlowTaskHistory(CompanyCD,FlowInstanceID,FlowNo,BillTypeID,BillID,StepNo,State,operateUserId,operateDate)");
sqlHis.AppendLine("Values(@CompanyCD,@tempFlowInstanceID,@tempFlowNo,@BillTypeFlag,@BillID,0,2,@ModifiedUserID,getdate())");
SqlCommand commHis = new SqlCommand();
commHis.CommandText = sqlHis.ToString();
commHis.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
commHis.Parameters.Add(SqlHelper.GetParameter("@tempFlowInstanceID", FlowInstanceID));
commHis.Parameters.Add(SqlHelper.GetParameter("@tempFlowNo", FlowNo));
commHis.Parameters.Add(SqlHelper.GetParameter("@BillTypeFlag", BillTypeFlag));
commHis.Parameters.Add(SqlHelper.GetParameter("@BillID", model.ID));
commHis.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
sqllist.Add(commHis);
#endregion
#region 更新流程任务处理表
StringBuilder sqlTask = new StringBuilder();
sqlTask.AppendLine("Update officedba.FlowTaskList Set StepNo=0,ModifiedDate=getdate(),ModifiedUserID=@ModifiedUserID");
sqlTask.AppendLine("Where CompanyCD=@CompanyCD and FlowInstanceID=@tempFlowInstanceID");
SqlCommand commTask = new SqlCommand();
commTask.CommandText = sqlTask.ToString();
commTask.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
commTask.Parameters.Add(SqlHelper.GetParameter("@tempFlowInstanceID", FlowInstanceID));
commTask.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
sqllist.Add(commTask);
#endregion
#region 更新流程实例表
StringBuilder sqlIns = new StringBuilder();
sqlIns.AppendLine("Update officedba.FlowInstance Set FlowStatus=5,ModifiedDate=getdate(),ModifiedUserID=@ModifiedUserID ");
sqlIns.AppendLine("Where CompanyCD=@CompanyCD ");
sqlIns.AppendLine("and FlowNo=@tempFlowNo ");
sqlIns.AppendLine("and BillTypeFlag=@BillTypeFlag ");
sqlIns.AppendLine("and BillTypeCode=@BillTypeCode ");
sqlIns.AppendLine("and BillID=@BillID");
SqlCommand commIns = new SqlCommand();
commIns.CommandText = sqlIns.ToString();
commIns.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
commIns.Parameters.Add(SqlHelper.GetParameter("@tempFlowNo", FlowNo));
commIns.Parameters.Add(SqlHelper.GetParameter("@BillTypeFlag", BillTypeFlag));
commIns.Parameters.Add(SqlHelper.GetParameter("@BillTypeCode", BillTypeCode));
commIns.Parameters.Add(SqlHelper.GetParameter("@BillID", model.ID));
commIns.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
sqllist.Add(commIns);
#endregion
}
#endregion
}
else
{
return false;
}
if (SqlHelper.ExecuteTransWithArrayList(sqllist))
{
return true;
}
else
{
return false;
}
}
public static bool ConfirmBill(StorageAdjustModel model, List<StorageAdjustDetail> detail)
{
ArrayList sqllist = new ArrayList();
StringBuilder sql = new StringBuilder();
sql.AppendLine(" UPDATE officedba.StorageAdjust SET");
sql.AppendLine(" Confirmor = @Confirmor,");
sql.AppendLine(" ConfirmDate = @ConfirmDate,");
sql.AppendLine(" BillStatus = 2,");
sql.AppendLine(" ModifiedUserID = @ModifiedUserID,");
sql.AppendLine(" ModifiedDate = @ModifiedDate ");
sql.AppendLine(" Where CompanyCD=@CompanyCD and ID=@ID");
SqlCommand sqlcomm = new SqlCommand();
sqlcomm.CommandText = sql.ToString(); ;
SqlParameter[] param = new SqlParameter[6];
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@Confirmor", model.Confirmor));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ConfirmDate", model.ConfirmDate));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
sqlcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
sqllist.Add(sqlcomm);
for (int i = 0; i < detail.Count; i++)
{
string upsql = "";
if (detail[i].AdjustType == "1")//增加
{
upsql += " update officedba.StorageProduct set ProductCount=isnull(ProductCount,0)+@ProductCount where CompanyCD=@CompanyCD and ProductID=@ProductID and StorageID=@StorageID";
}
else
{
upsql += " update officedba.StorageProduct set ProductCount=isnull(ProductCount,0)-@ProductCount where CompanyCD=@CompanyCD and ProductID=@ProductID and StorageID=@StorageID";
}
if (detail[i].BatchNo != "")
upsql += " and BatchNo='" + detail[i].BatchNo.Trim() + "' ";
else
upsql += " and BatchNo is null ";
SqlCommand upcomm = new SqlCommand();
upcomm.CommandText = upsql;
upcomm.Parameters.Add(SqlHelper.GetParameter("@ProductCount", detail[i].AdjustCount));
upcomm.Parameters.Add(SqlHelper.GetParameter("@ProductID", detail[i].ProductID.ToString()));
upcomm.Parameters.Add(SqlHelper.GetParameter("@StorageID", model.StorageID));
upcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
sqllist.Add(upcomm);
#region 操作库存流水账
StorageAccountModel AccountM_ = new StorageAccountModel();
AccountM_.BatchNo = detail[i].BatchNo;
AccountM_.BillNo = model.AdjustNo;
AccountM_.BillType = 14;
AccountM_.CompanyCD = model.CompanyCD;
AccountM_.Creator = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID;
AccountM_.HappenCount = Convert.ToDecimal(detail[i].AdjustCount.ToString());
AccountM_.ProductCount = Convert.ToDecimal(detail[i].AdjustCount);
AccountM_.HappenDate = System.DateTime.Now;
AccountM_.PageUrl = "../Office/StorageManager/StorageAdjustAdd.aspx";
AccountM_.Price = Convert.ToDecimal(detail[i].CostPrice.ToString());
AccountM_.ProductID = Convert.ToInt32(detail[i].ProductID.ToString());
AccountM_.StorageID = Convert.ToInt32(model.StorageID);
SqlCommand AccountCom_=new SqlCommand();
if (detail[i].AdjustType.ToString() == "1")
AccountCom_ = StorageAccountDBHelper.InsertStorageAccountCommand(AccountM_,"0");
else
AccountCom_ = StorageAccountDBHelper.InsertStorageAccountCommand(AccountM_,"1");
sqllist.Add(AccountCom_);
#endregion
}
if (SqlHelper.ExecuteTransWithArrayList(sqllist))
{
return true;
}
else
{
return false;
}
}
public static bool UpdateAdjust(StorageAdjustModel model, List<StorageAdjustDetail> detail, string[] SortID, Hashtable ht)
{
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;//[待修改]
ArrayList sqllist = new ArrayList();
//string loginUserID = "admin123";
if (string.IsNullOrEmpty(model.AdjustNo))
{
return false;
}
#region 基本信息
string sql = "";
sql += " UPDATE [officedba].[StorageAdjust] ";
sql += " SET [StorageID] = @StorageID ";
sql += " ,[ReasonType] = @ReasonType ";
sql += " ,[Executor] = @Executor ";
sql += " ,[DeptID] = @DeptID ";
sql += " ,[AdjustDate] = @AdjustDate ";
sql += " ,[TotalPrice] = @TotalPrice ";
sql += " ,[CountTotal] = @CountTotal ";
sql += " ,[Summary] = @Summary ";
sql += " ,[Remark] = @Remark ";
sql += " ,[Attachment] = @Attachment ";
sql += " ,[ModifiedDate] = @ModifiedDate ";
sql += " ,[ModifiedUserID] = @ModifiedUserID ";
sql += " ,[Title] = @Title ";
sql += " WHERE ID=@ID ";
SqlCommand comm = new SqlCommand();
comm.Parameters.Add(SqlHelper.GetParameter("@StorageID", model.StorageID));
comm.Parameters.Add(SqlHelper.GetParameter("@ReasonType", model.ReasonType));
comm.Parameters.Add(SqlHelper.GetParameter("@Executor", model.Executor));
comm.Parameters.Add(SqlHelper.GetParameter("@DeptID", model.DeptID));
if (model.AdjustDate != Convert.ToDateTime("9999-9-9"))
{
comm.Parameters.Add(SqlHelper.GetParameter("@AdjustDate", model.AdjustDate));
}
else
{
comm.Parameters.Add(SqlHelper.GetParameter("@AdjustDate",System.Data.SqlTypes.SqlDateTime.Null));
}
comm.Parameters.Add(SqlHelper.GetParameter("@TotalPrice", model.TotalPrice));
comm.Parameters.Add(SqlHelper.GetParameter("@CountTotal", model.CountTotal));
comm.Parameters.Add(SqlHelper.GetParameter("@Summary", model.Summary));
comm.Parameters.Add(SqlHelper.GetParameter("@Attachment", model.Attachment));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", DateTime.Now));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
comm.Parameters.Add(SqlHelper.GetParameter("@Title", model.Title));
comm.Parameters.Add(SqlHelper.GetParameter("@Remark", model.Remark));
comm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID));
comm.CommandText = sql;
sqllist.Add(comm);
#endregion
#region 拓展属性
SqlCommand cmd = new SqlCommand();
GetExtAttrCmd(model, ht, cmd);
if (ht.Count > 0)
sqllist.Add(cmd);
#endregion
#region 明细
if (SortID.Length > 0)
{
string delsql = "DELETE FROM [officedba].[StorageAdjustDetail] where CompanyCD=@CompanyCD and AdjustNo=@AdjustNo ";
SqlCommand delcomm = new SqlCommand();
delcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
delcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustNo", model.AdjustNo));
delcomm.CommandText = delsql;
sqllist.Add(delcomm);
if (SortID[0] != null && SortID[0] != "")
{
for (int i = 0; i < detail.Count; i++)
{
string detailsql = "";
detailsql += "";
detailsql += " INSERT INTO [officedba].[StorageAdjustDetail] ";
detailsql += " ([CompanyCD] ";
detailsql += " ,[AdjustNo] ";
detailsql += " ,[SortNo] ";
detailsql += " ,[ProductID] ";
detailsql += " ,[UnitID] ";
detailsql += " ,[AdjustType] ";
detailsql += " ,[AdjustCount] ";
detailsql += " ,[CostPrice] ";
detailsql += " ,[CostPriceTotal] ";
if (!string.IsNullOrEmpty(detail[i].Remark))
{
detailsql += " ,[Remark] ";
}
if (!string.IsNullOrEmpty(detail[i].BatchNo))
{
detailsql += " ,[BatchNo] ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitID))
{
detailsql += " ,[UsedUnitID] ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitCount))
{
detailsql += " ,[UsedUnitCount] ";
}
if (!string.IsNullOrEmpty(detail[i].UsedPrice))
{
detailsql += " ,[UsedPrice] ";
}
if (!string.IsNullOrEmpty(detail[i].ExRate))
{
detailsql += " ,[ExRate] ";
}
detailsql += " ,[ModifiedDate] ";
detailsql += " ,[ModifiedUserID]) ";
detailsql += " VALUES ";
detailsql += " (@CompanyCD ";
detailsql += " ,@AdjustNo ";
detailsql += " ,@SortNo ";
detailsql += " ,@ProductID ";
detailsql += " ,@UnitID ";
detailsql += " ,@AdjustType ";
detailsql += " ,@AdjustCount ";
detailsql += " ,@CostPrice ";
detailsql += " ,@CostPriceTotal ";
if (!string.IsNullOrEmpty(detail[i].Remark))
{
detailsql += " ,@Remark ";
}
if (!string.IsNullOrEmpty(detail[i].BatchNo))
{
detailsql += " ,@BatchNo ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitID))
{
detailsql += " ,@UsedUnitID ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitCount))
{
detailsql += " ,@UsedUnitCount ";
}
if (!string.IsNullOrEmpty(detail[i].UsedPrice))
{
detailsql += " ,@UsedPrice ";
}
if (!string.IsNullOrEmpty(detail[i].ExRate))
{
detailsql += " ,@ExRate ";
}
detailsql += " ,@ModifiedDate ";
detailsql += " ,@ModifiedUserID) ";
SqlCommand detailcomm = new SqlCommand();
detailcomm.CommandText = detailsql;
detailcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustNo", model.AdjustNo));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@SortNo", detail[i].SortNo));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ProductID", detail[i].ProductID));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UnitID", detail[i].UnitID));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustType", detail[i].AdjustType));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustCount", detail[i].AdjustCount));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@CostPrice", detail[i].CostPrice));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@CostPriceTotal", detail[i].CostPriceTotal));
if (!string.IsNullOrEmpty(detail[i].Remark))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@Remark", detail[i].Remark));
}
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
if (!string.IsNullOrEmpty(detail[i].BatchNo))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@BatchNo", detail[i].BatchNo));
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitID))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UsedUnitID", detail[i].UsedUnitID));
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitCount))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UsedUnitCount", detail[i].UsedUnitCount));
}
if (!string.IsNullOrEmpty(detail[i].UsedPrice))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UsedPrice", detail[i].UsedPrice));
}
if (!string.IsNullOrEmpty(detail[i].ExRate))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ExRate", detail[i].ExRate));
}
sqllist.Add(detailcomm);
}
}
}
#endregion
if (SqlHelper.ExecuteTransWithArrayList(sqllist))
{
return true;
}
else
{
return false;
}
}
public static bool AddAdjust(StorageAdjustModel model, List<StorageAdjustDetail> detail, Hashtable ht)
{
ArrayList sqllist = new ArrayList();
string sql = "";
#region 主表---Start
sql += " INSERT INTO [officedba].[StorageAdjust]";
sql += " ([CompanyCD] ";
sql += " ,[AdjustNo] ";
sql += " ,[StorageID] ";
sql += " ,[ReasonType] ";
sql += " ,[Executor] ";
sql += " ,[DeptID] ";
if (model.AdjustDate != Convert.ToDateTime("9999-9-9"))
{
sql += " ,[AdjustDate] ";
}
if (model.TotalPrice != 0)
{
sql += " ,[TotalPrice] ";
}
if (model.CountTotal != 0)
{
sql += " ,[CountTotal] ";
}
if (!string.IsNullOrEmpty(model.Summary))
{
sql += " ,[Summary] ";
}
if (!string.IsNullOrEmpty(model.Remark))
{
sql += " ,[Remark] ";
}
if (!string.IsNullOrEmpty(model.Attachment))
{
sql += " ,[Attachment] ";
}
sql += " ,[Creator] ";
sql += " ,[CreateDate] ";
sql += " ,[BillStatus] ";
sql += " ,[ModifiedDate] ";
sql += " ,[Title]";
sql += " ,[ModifiedUserID]) ";
sql += " VALUES ";
sql += " (@CompanyCD ";
sql += " ,@AdjustNo ";
sql += " ,@StorageID ";
sql += " ,@ReasonType ";
sql += " ,@Executor ";
sql += " ,@DeptID ";
if (model.AdjustDate != Convert.ToDateTime("9999-9-9"))
{
sql += " ,@AdjustDate ";
}
if (model.TotalPrice != 0)
{
sql += " ,@TotalPrice ";
}
if (model.CountTotal != 0)
{
sql += " ,@CountTotal ";
}
if (!string.IsNullOrEmpty(model.Summary))
{
sql += " ,@Summary ";
}
if (!string.IsNullOrEmpty(model.Remark))
{
sql += " ,@Remark ";
}
if (!string.IsNullOrEmpty(model.Attachment))
{
sql += " ,@Attachment ";
}
sql += " ,@Creator ";
sql += " ,@CreateDate ";
sql += " ,@BillStatus ";
sql += " ,@ModifiedDate ";
sql += " ,@Title ";
sql += " ,@ModifiedUserID) ";
SqlCommand comm = new SqlCommand();
comm.CommandText = sql;
comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
comm.Parameters.Add(SqlHelper.GetParameter("@AdjustNo", model.AdjustNo));
comm.Parameters.Add(SqlHelper.GetParameter("@StorageID", model.StorageID));
comm.Parameters.Add(SqlHelper.GetParameter("@ReasonType", model.ReasonType));
comm.Parameters.Add(SqlHelper.GetParameter("@Executor", model.Executor));
comm.Parameters.Add(SqlHelper.GetParameter("@DeptID", model.DeptID));
if (model.AdjustDate != Convert.ToDateTime("9999-9-9"))
{
comm.Parameters.Add(SqlHelper.GetParameter("@AdjustDate", model.AdjustDate));
}
comm.Parameters.Add(SqlHelper.GetParameter("@Title", model.Title));
if (model.TotalPrice != 0)
{
comm.Parameters.Add(SqlHelper.GetParameter("@TotalPrice", model.TotalPrice));
}
if (model.CountTotal != 0)
{
comm.Parameters.Add(SqlHelper.GetParameter("@CountTotal", model.CountTotal));
}
if (!string.IsNullOrEmpty(model.Summary))
{
comm.Parameters.Add(SqlHelper.GetParameter("@Summary", model.Summary));
}
if (!string.IsNullOrEmpty(model.Remark))
{
comm.Parameters.Add(SqlHelper.GetParameter("@Remark", model.Remark));
}
if (!string.IsNullOrEmpty(model.Attachment))
{
comm.Parameters.Add(SqlHelper.GetParameter("@Attachment", model.Attachment));
}
comm.Parameters.Add(SqlHelper.GetParameter("@Creator", model.Creator));
comm.Parameters.Add(SqlHelper.GetParameter("@CreateDate", model.CreateDate));
comm.Parameters.Add(SqlHelper.GetParameter("@BillStatus", model.BillStatus));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
sqllist.Add(comm);
#endregion
#region 拓展属性
SqlCommand cmd = new SqlCommand();
GetExtAttrCmd(model, ht, cmd);
if (ht.Count > 0)
sqllist.Add(cmd);
#endregion
#region 明细---Start
StorageAdjustDetail detailmodel = new StorageAdjustDetail();
if (!string.IsNullOrEmpty(model.AdjustNo))
{
for (int i = 0; i < detail.Count; i++)
{
string detailsql = "";
detailsql += "";
detailsql += " INSERT INTO [officedba].[StorageAdjustDetail] ";
detailsql += " ([CompanyCD] ";
detailsql += " ,[AdjustNo] ";
detailsql += " ,[SortNo] ";
detailsql += " ,[ProductID] ";
detailsql += " ,[UnitID] ";
detailsql += " ,[AdjustType] ";
detailsql += " ,[AdjustCount] ";
detailsql += " ,[CostPrice] ";
detailsql += " ,[CostPriceTotal] ";
if (!string.IsNullOrEmpty(detail[i].Remark))
{
detailsql += " ,[Remark] ";
}
if (!string.IsNullOrEmpty(detail[i].BatchNo))
{
detailsql += " ,[BatchNo] ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitID))
{
detailsql += " ,[UsedUnitID] ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitCount))
{
detailsql += " ,[UsedUnitCount] ";
}
if (!string.IsNullOrEmpty(detail[i].UsedPrice))
{
detailsql += " ,[UsedPrice] ";
}
if (!string.IsNullOrEmpty(detail[i].ExRate))
{
detailsql += " ,[ExRate] ";
}
detailsql += " ,[ModifiedDate] ";
detailsql += " ,[ModifiedUserID]) ";
detailsql += " VALUES ";
detailsql += " (@CompanyCD ";
detailsql += " ,@AdjustNo ";
detailsql += " ,@SortNo ";
detailsql += " ,@ProductID ";
detailsql += " ,@UnitID ";
detailsql += " ,@AdjustType ";
detailsql += " ,@AdjustCount ";
detailsql += " ,@CostPrice ";
detailsql += " ,@CostPriceTotal ";
if (!string.IsNullOrEmpty(detail[i].Remark))
{
detailsql += " ,@Remark ";
}
if (!string.IsNullOrEmpty(detail[i].BatchNo))
{
detailsql += " ,@BatchNo ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitID))
{
detailsql += " ,@UsedUnitID ";
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitCount))
{
detailsql += " ,@UsedUnitCount ";
}
if (!string.IsNullOrEmpty(detail[i].UsedPrice))
{
detailsql += " ,@UsedPrice ";
}
if (!string.IsNullOrEmpty(detail[i].ExRate))
{
detailsql += " ,@ExRate ";
}
detailsql += " ,@ModifiedDate ";
detailsql += " ,@ModifiedUserID) ";
SqlCommand detailcomm = new SqlCommand();
detailcomm.CommandText = detailsql;
detailcomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustNo", model.AdjustNo));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@SortNo", detail[i].SortNo));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ProductID", detail[i].ProductID));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UnitID", detail[i].UnitID));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustType", detail[i].AdjustType));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@AdjustCount", detail[i].AdjustCount));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@CostPrice", detail[i].CostPrice));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@CostPriceTotal", detail[i].CostPriceTotal));
if (!string.IsNullOrEmpty(detail[i].Remark))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@Remark", detail[i].Remark));
}
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
if (!string.IsNullOrEmpty(detail[i].BatchNo))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@BatchNo", detail[i].BatchNo));
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitID))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UsedUnitID", detail[i].UsedUnitID));
}
if (!string.IsNullOrEmpty(detail[i].UsedUnitCount))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UsedUnitCount", detail[i].UsedUnitCount));
}
if (!string.IsNullOrEmpty(detail[i].UsedPrice))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@UsedPrice", detail[i].UsedPrice));
}
if (!string.IsNullOrEmpty(detail[i].ExRate))
{
detailcomm.Parameters.Add(SqlHelper.GetParameter("@ExRate", detail[i].ExRate));
}
sqllist.Add(detailcomm);
}
}
#endregion
if (SqlHelper.ExecuteTransWithArrayList(sqllist))
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 扩展属性保存操作
/// </summary>
/// <returns></returns>
private static void GetExtAttrCmd(StorageAdjustModel model, Hashtable htExtAttr, SqlCommand cmd)
{
try
{
string strSql = string.Empty;
strSql = "UPDATE officedba.StorageAdjust set ";
foreach (DictionaryEntry de in htExtAttr)// fileht为一个Hashtable实例
{
strSql += de.Key.ToString().Trim() + "=@" + de.Key.ToString().Trim() + ",";
cmd.Parameters.AddWithValue("@" + de.Key.ToString().Trim(), de.Value.ToString().Trim());
}
int iLength = strSql.Length - 1;
strSql = strSql.Substring(0, iLength);
strSql += " where CompanyCD = @CompanyCD AND AdjustNo = @AdjustNo";
cmd.Parameters.AddWithValue("@CompanyCD", model.CompanyCD);
cmd.Parameters.AddWithValue("@AdjustNo", model.AdjustNo);
cmd.CommandText = strSql;
}
catch (Exception)
{ }
}
