protected void btnImport_Click(object sender, ImageClickEventArgs e) { PurchaseAskPriceModel PurchaseAskPriceM = new PurchaseAskPriceModel(); PurchaseAskPriceM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; PurchaseAskPriceM.AskNo = txtAskNo.Value; PurchaseAskPriceM.AskTitle = txtAskTitle.Value; PurchaseAskPriceM.FromType = ddlFromType.Value; PurchaseAskPriceM.DeptID = hidDeptID.Value; PurchaseAskPriceM.AskUserID = hidUserID.Value; PurchaseAskPriceM.BillStatus = ddlBillStatus.Value; PurchaseAskPriceM.ProviderID = hidProviderID.Value; PurchaseAskPriceM.FlowStatus = ddlFlowStatus.Value; PurchaseAskPriceM.AskDate = StartAskDate.Value; PurchaseAskPriceM.EndAskDate = EndAskDate.Value; PurchaseAskPriceM.EFDesc = GetBillExAttrControl1.GetExtTxtValue; PurchaseAskPriceM.EFIndex = GetBillExAttrControl1.GetExtIndexValue; string OrderBy = hidOrderBy.Value; DataTable dt = PurchaseAskPriceBus.GetPurchaseAskPrice(PurchaseAskPriceM,OrderBy); OutputToExecl.ExportToTableFormat(this, dt, new string[] { "询价单编号", "询价单主题", "供应商", "询价日期", "询价员", "当前询价次数", "金额合计", "税额合计", "含税金额合计", "单据状态", "审批状态" }, new string[] { "AskNo", "AskTitle", "ProviderName", "AskDate", "AskUserName", "AskOrder", "TotalPrice", "TotalTax", "TotalFee", "BillStatusName", "FlowStatusName" }, "采购询价单列表"); }
/// <summary> /// 插入采购询价主表 /// </summary> /// <param name="PurchaseAskPriceM">采购询价主表model</param> /// <returns>sqlcommend</returns> /// public static SqlCommand InsertPurAskPricePri(PurchaseAskPriceModel PurchaseAskPriceM) { SqlCommand comm = new SqlCommand(); #region SQL文 StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.PurchaseAskPrice"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,AskNo "); sql.AppendLine(" ,AskOrder "); sql.AppendLine(" ,AskTitle "); sql.AppendLine(" ,FromType "); sql.AppendLine(" ,AskDate "); sql.AppendLine(" ,ProviderID "); sql.AppendLine(" ,DeptID "); sql.AppendLine(" ,AskUserID "); sql.AppendLine(" ,TypeID "); sql.AppendLine(" ,CurrencyType "); sql.AppendLine(" ,Rate "); sql.AppendLine(" ,TotalPrice "); sql.AppendLine(" ,TotalTax "); sql.AppendLine(" ,TotalFee "); sql.AppendLine(" ,Discount "); sql.AppendLine(" ,DiscountTotal "); sql.AppendLine(" ,RealTotal "); sql.AppendLine(" ,isAddTax "); sql.AppendLine(" ,CountTotal "); sql.AppendLine(" ,remark "); sql.AppendLine(" ,BillStatus "); sql.AppendLine(" ,Creator "); sql.AppendLine(" ,CreateDate "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID "); //sql.AppendLine(" ,Confirmor "); //sql.AppendLine(" ,ConfirmDate "); //sql.AppendLine(" ,Closer "); //sql.AppendLine(" ,CloseDate "); sql.AppendLine(")"); sql.AppendLine(" VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@AskNo "); sql.AppendLine(" ,@AskOrder "); sql.AppendLine(" ,@AskTitle "); sql.AppendLine(" ,@FromType "); sql.AppendLine(" ,@AskDate "); sql.AppendLine(" ,@ProviderID "); sql.AppendLine(" ,@DeptID "); sql.AppendLine(" ,@AskUserID "); sql.AppendLine(" ,@TypeID "); sql.AppendLine(" ,@CurrencyType "); sql.AppendLine(" ,@Rate "); sql.AppendLine(" ,@TotalPrice "); sql.AppendLine(" ,@TotalTax "); sql.AppendLine(" ,@TotalFee "); sql.AppendLine(" ,@Discount "); sql.AppendLine(" ,@DiscountTotal "); sql.AppendLine(" ,@RealTotal "); sql.AppendLine(" ,@isAddTax "); sql.AppendLine(" ,@CountTotal "); sql.AppendLine(" ,@remark "); sql.AppendLine(" ,@BillStatus "); sql.AppendLine(" ,@Creator "); sql.AppendLine(" ,@CreateDate "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID "); //sql.AppendLine(" ,@Confirmor "); //sql.AppendLine(" ,@ConfirmDate "); //sql.AppendLine(" ,@Closer "); //sql.AppendLine(" ,@CloseDate "); sql.AppendLine(")"); sql.AppendLine("set @IndexID = @@IDENTITY"); #endregion #region 传参 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD",((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskNo", PurchaseAskPriceM.AskNo)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskOrder", PurchaseAskPriceM.AskOrder)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskTitle", PurchaseAskPriceM.AskTitle)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@FromType", PurchaseAskPriceM.FromType)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskDate", PurchaseAskPriceM.AskDate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProviderID", PurchaseAskPriceM.ProviderID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", PurchaseAskPriceM.DeptID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskUserID", PurchaseAskPriceM.AskUserID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", PurchaseAskPriceM.TypeID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CurrencyType", PurchaseAskPriceM.CurrencyType)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Rate", PurchaseAskPriceM.Rate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalPrice", PurchaseAskPriceM.TotalPrice)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalTax", PurchaseAskPriceM.TotalTax)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalFee", PurchaseAskPriceM.TotalFee)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Discount", PurchaseAskPriceM.Discount)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@DiscountTotal", PurchaseAskPriceM.DiscountTotal)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@RealTotal", PurchaseAskPriceM.RealTotal)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@isAddTax", PurchaseAskPriceM.isAddTax)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CountTotal", PurchaseAskPriceM.CountTotal)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@remark", PurchaseAskPriceM.remark)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@BillStatus", PurchaseAskPriceM.BillStatus)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Creator", PurchaseAskPriceM.Creator)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CreateDate", PurchaseAskPriceM.CreateDate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedDate", PurchaseAskPriceM.ModifiedDate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", PurchaseAskPriceM.ModifiedUserID)); //comm.Parameters.Add(SqlHelper.GetParameterFromString("@Confirmor", PurchaseAskPriceM.Confirmor)); //comm.Parameters.Add(SqlHelper.GetParameterFromString("@ConfirmDate", PurchaseAskPriceM.ConfirmDate)); //comm.Parameters.Add(SqlHelper.GetParameterFromString("@Closer", PurchaseAskPriceM.Closer)); //comm.Parameters.Add(SqlHelper.GetParameterFromString("@CloseDate", PurchaseAskPriceM.CloseDate)); SqlParameter IndexID = new SqlParameter("@IndexID", SqlDbType.Int); IndexID.Direction = ParameterDirection.Output; comm.Parameters.Add(IndexID); #endregion comm.CommandText = sql.ToString(); return comm; }
public static DataTable SelectPurAskPricePri(PurchaseAskPriceModel PurchaseAskPriceM, string OrderBy) { SqlCommand comm = new SqlCommand(); #region SQL文 StringBuilder sql = new StringBuilder(); sql.AppendLine("Select ID,CompanyCD,AskNo,AskOrder,AskTitle,FromType,FromTypeName,AskDate,AskUserID,DeptID,AskUserName,ProviderID,ProviderName,TotalPrice,TotalTax "); sql.AppendLine(",TotalFee,BillStatus,BillStatusName,isnull(FlowStatus,'') AS FlowStatus "); sql.AppendLine(",case FlowStatus WHEN '1' then '待审批' when '2' then '审批中' when '3' then '审批通过' "); sql.AppendLine("when '4' then '审批不通过' when '5' then '撤销审批' else '' end as FlowStatusName,ExtField1,ExtField2,ExtField3,ExtField4,ExtField5,ExtField6,ExtField7,ExtField8,ExtField9,ExtField10 "); sql.AppendLine(" from (SELECT A.ID "); sql.AppendLine(" , isnull(A.CompanyCD ,'') AS CompanyCD "); sql.AppendLine(" , isnull(A.AskNo ,'') AS AskNo "); sql.AppendLine(" , isnull(A.AskOrder ,0) AS AskOrder "); sql.AppendLine(" , isnull(A.AskTitle ,'') AS AskTitle "); sql.AppendLine(" , isnull(A.FromType ,'') AS FromType "); sql.AppendLine(" ,case A.FromType when '1' then '采购申请单' when '2' then '采购计划单' else '无来源' end as FromTypeName "); sql.AppendLine(" , isnull(CONVERT(varchar(23),A.AskDate,23),'') AS AskDate "); sql.AppendLine(" ,isnull(A.AskUserID,0) AS AskUserID ,A.DeptID"); sql.AppendLine(" ,isnull(D.EmployeeName,'') AS AskUserName "); sql.AppendLine(" , isnull(A.ProviderID ,0) AS ProviderID "); sql.AppendLine(" , isnull(B.CustName ,'') AS ProviderName "); sql.AppendLine(" , isnull(A.TotalPrice ,0) AS TotalPrice "); sql.AppendLine(" , isnull(A.TotalTax ,0) AS TotalTax "); sql.AppendLine(" , isnull(A.TotalFee ,0) AS TotalFee "); sql.AppendLine(" , isnull(A.BillStatus ,'') AS BillStatus "); sql.AppendLine(" , isnull(A.ExtField1 ,'') AS ExtField1 "); sql.AppendLine(" , isnull(A.ExtField2 ,'') AS ExtField2 "); sql.AppendLine(" , isnull(A.ExtField3 ,'') AS ExtField3 "); sql.AppendLine(" , isnull(A.ExtField4 ,'') AS ExtField4 "); sql.AppendLine(" , isnull(A.ExtField5 ,'') AS ExtField5 "); sql.AppendLine(" , isnull(A.ExtField6 ,'') AS ExtField6 "); sql.AppendLine(" , isnull(A.ExtField7 ,'') AS ExtField7 "); sql.AppendLine(" , isnull(A.ExtField8 ,'') AS ExtField8 "); sql.AppendLine(" , isnull(A.ExtField9 ,'') AS ExtField9 "); sql.AppendLine(" , isnull(A.ExtField10 ,'') AS ExtField10 "); sql.AppendLine(" ,case A.BillStatus when '1' then '制单' when '2' then '执行' when '3' then '变更' "); sql.AppendLine("when '4' then '手工结单' when '5' then '自动结单' end AS BillStatusName "); sql.AppendLine(",(SELECT top 1 FlowStatus FROM officedba.FlowInstance WHERE BillTypeFlag=6 AND BillTypeCode=3 AND BillID= A.ID ORDER BY ID DESC ) AS FlowStatus"); sql.AppendLine(" FROM officedba.PurchaseAskPrice AS A "); sql.AppendLine(" LEFT JOIN officedba.ProviderInfo AS B ON A.ProviderID = B.ID "); sql.AppendLine(" LEFT JOIN officedba.EmployeeInfo AS D ON A.AskUserID = D.ID )AS E "); sql.AppendLine(" WHERE CompanyCD=@CompanyCD"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD)); if (PurchaseAskPriceM.AskNo != "") { sql.AppendLine(" AND AskNo like @AskNo"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskNo", "%" + PurchaseAskPriceM.AskNo + "%")); } if (PurchaseAskPriceM.AskTitle != "") { sql.AppendLine(" AND AskTitle like @AskTitle"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskTitle", "%" + PurchaseAskPriceM.AskTitle + "%")); } if (PurchaseAskPriceM.FromType != "a") { sql.AppendLine(" AND FromType=@FromType"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@FromType", PurchaseAskPriceM.FromType)); } if (PurchaseAskPriceM.DeptID != "") { sql.AppendLine(" AND DeptID=@DeptID"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", PurchaseAskPriceM.DeptID)); } if (PurchaseAskPriceM.AskUserID != "") { sql.AppendLine(" AND AskUserID=@AskUserID"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskUserID", PurchaseAskPriceM.AskUserID)); } if (PurchaseAskPriceM.ProviderID != "") { sql.AppendLine(" AND ProviderID=@ProviderID"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProviderID", PurchaseAskPriceM.ProviderID)); } if (PurchaseAskPriceM.BillStatus != "0") { sql.AppendLine(" AND BillStatus=@BillStatus"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@BillStatus", PurchaseAskPriceM.BillStatus)); } if (PurchaseAskPriceM.FlowStatus != "") { if (PurchaseAskPriceM.FlowStatus == "0") { sql.AppendLine(" AND FlowStatus is NULL "); } else { sql.AppendLine(" AND FlowStatus=@FlowStatus"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@FlowStatus", PurchaseAskPriceM.FlowStatus)); } } if (PurchaseAskPriceM.AskDate != "") { sql.AppendLine(" AND AskDate >= @StartAskDate"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartAskDate", PurchaseAskPriceM.AskDate)); } if (PurchaseAskPriceM.EndAskDate != "") { sql.AppendLine(" AND AskDate <= @EndAskDate"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndAskDate", PurchaseAskPriceM.EndAskDate)); } if (!string.IsNullOrEmpty(PurchaseAskPriceM.EFIndex) && !string.IsNullOrEmpty(PurchaseAskPriceM.EFDesc)) { sql.AppendLine(" and ExtField" + PurchaseAskPriceM.EFIndex + " LIKE @EFDesc"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@EFDesc", "%" + PurchaseAskPriceM.EFDesc + "%")); } sql.AppendLine(" ORDER BY "+OrderBy+""); #endregion comm.CommandText = sql.ToString(); return SqlHelper.ExecuteSearch(comm); }
/// <summary> ///更新采购询价主表 /// </summary> /// <param name="PurchaseAskPriceM">采购询价主表model</param> /// <returns>sqlcommend</returns> /// public static SqlCommand UpdatePurAskPricePri(PurchaseAskPriceModel PurchaseAskPriceM) { SqlCommand comm = new SqlCommand(); #region SQL文 StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.PurchaseAskPrice "); sql.AppendLine(" SET CompanyCD =@CompanyCD "); sql.AppendLine(" ,AskNo =@AskNo "); sql.AppendLine(" ,AskOrder =@AskOrder "); sql.AppendLine(" ,AskTitle =@AskTitle "); sql.AppendLine(" ,FromType =@FromType "); sql.AppendLine(" ,AskDate =@AskDate "); sql.AppendLine(" ,ProviderID =@ProviderID "); sql.AppendLine(" ,DeptID =@DeptID "); sql.AppendLine(" ,AskUserID =@AskUserID "); sql.AppendLine(" ,TypeID =@TypeID "); sql.AppendLine(" ,CurrencyType =@CurrencyType "); sql.AppendLine(" ,Rate =@Rate "); sql.AppendLine(" ,TotalPrice =@TotalPrice "); sql.AppendLine(" ,TotalTax =@TotalTax "); sql.AppendLine(" ,TotalFee =@TotalFee "); sql.AppendLine(" ,Discount =@Discount "); sql.AppendLine(" ,DiscountTotal =@DiscountTotal "); sql.AppendLine(" ,RealTotal =@RealTotal "); sql.AppendLine(" ,isAddTax =@isAddTax "); sql.AppendLine(" ,CountTotal =@CountTotal "); sql.AppendLine(" ,BillStatus =@BillStatus "); sql.AppendLine(" ,Confirmor =@Confirmor "); sql.AppendLine(" ,ConfirmDate =@ConfirmDate "); sql.AppendLine(" ,remark =@remark "); sql.AppendLine(" ,ModifiedDate =getDate() "); sql.AppendLine(" ,ModifiedUserID =@ModifiedUserID "); sql.AppendLine("WHERE ID=@ID "); #endregion #region 传参 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskNo", PurchaseAskPriceM.AskNo)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskOrder", PurchaseAskPriceM.AskOrder)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskTitle", PurchaseAskPriceM.AskTitle)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@FromType", PurchaseAskPriceM.FromType)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskDate", PurchaseAskPriceM.AskDate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProviderID", PurchaseAskPriceM.ProviderID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", PurchaseAskPriceM.DeptID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@AskUserID", PurchaseAskPriceM.AskUserID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", PurchaseAskPriceM.TypeID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CurrencyType", PurchaseAskPriceM.CurrencyType)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Rate", PurchaseAskPriceM.Rate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalPrice", PurchaseAskPriceM.TotalPrice)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalTax", PurchaseAskPriceM.TotalTax)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalFee", PurchaseAskPriceM.TotalFee)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Discount", PurchaseAskPriceM.Discount)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@DiscountTotal", PurchaseAskPriceM.DiscountTotal)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@RealTotal", PurchaseAskPriceM.RealTotal)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@isAddTax", PurchaseAskPriceM.isAddTax)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@CountTotal", PurchaseAskPriceM.CountTotal)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@BillStatus", PurchaseAskPriceM.BillStatus)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Confirmor", PurchaseAskPriceM.Confirmor)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ConfirmDate", PurchaseAskPriceM.ConfirmDate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@remark", PurchaseAskPriceM.remark)); //comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedDate", PurchaseAskPriceM.ModifiedDate)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", PurchaseAskPriceM.ModifiedUserID)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID", PurchaseAskPriceM.ID)); #endregion comm.CommandText = sql.ToString(); return comm; }
/// <summary> /// 插入采购询价单 /// </summary> /// <param name="PurchaseAskPriceM">采购询价单主表model</param> /// <param name="PurchaseAskPriceDetailMList">采购询价单明细表model列表</param> /// <returns>bool</returns> public static bool InsertPurchaseAskPrice(PurchaseAskPriceModel PurchaseAskPriceM , List<PurchaseAskPriceDetailModel> PurchaseAskPriceDetailMList, out int IndexIDentity, Hashtable htExtAttr) { try { ArrayList lstAdd = new ArrayList(); SqlCommand AddPri = PurchaseAskPriceDBHelper.InsertPurAskPricePri(PurchaseAskPriceM); lstAdd.Add(AddPri); foreach (PurchaseAskPriceDetailModel PurchaseAskPriceDetailM in PurchaseAskPriceDetailMList) { SqlCommand AddDtl = PurchaseAskPriceDBHelper.InsertPurAskPriceDetail(PurchaseAskPriceDetailM); lstAdd.Add(AddDtl); } #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(PurchaseAskPriceM, htExtAttr, cmd); if (htExtAttr.Count > 0) lstAdd.Add(cmd); #endregion //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstAdd); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; IndexIDentity = int.Parse(((SqlCommand)AddPri).Parameters["@IndexID"].Value.ToString()); } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; IndexIDentity = 0; } LogInfoModel logModel = InitLogInfo(PurchaseAskPriceM.AskNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
public static DataTable GetPurchaseAskPrice(PurchaseAskPriceModel PurchaseAskPriceM, string OrderBy) { try { DataTable dt = PurchaseAskPriceDBHelper.SelectPurAskPricePri(PurchaseAskPriceM,OrderBy); //DataColumn JoinName = new DataColumn(); //dt.Columns.Add("IsCite"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // string ID = dt.Rows[i]["ID"].ToString(); // bool IsCite = PurchaseAskPriceDBHelper.IsCite(ID); // dt.Rows[i]["IsCite"] = IsCite; //} return dt; } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新采购询价单 /// </summary> /// <param name="PurchaseAskPriceM">采购询价单主表model</param> /// <param name="PurchaseAskPriceDetailMList">采购询价单明细表model列表</param> /// <returns>bool</returns> /// public static bool UpdatePurchaseAskPrice(PurchaseAskPriceModel PurchaseAskPriceM , List<PurchaseAskPriceDetailModel> PurchaseAskPriceDetailMList, Hashtable htExtAttr) { try { ArrayList lstUpdate = new ArrayList(); if (PurchaseAskPriceM.AskAgain == "1") {//再次询价,需将此次询价之前的那次询价记录记入询价历史表 SqlCommand AskAgain = PurchaseAskPriceDBHelper.InsertPurchaseAskHistory(PurchaseAskPriceM.ID); lstUpdate.Add(AskAgain); } SqlCommand UpdatePri = PurchaseAskPriceDBHelper.UpdatePurAskPricePri(PurchaseAskPriceM); lstUpdate.Add(UpdatePri); #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(PurchaseAskPriceM, htExtAttr, cmd); if (htExtAttr.Count > 0) lstUpdate.Add(cmd); #endregion SqlCommand DelDtl = PurchaseAskPriceDBHelper.DeletePurAskPriceDetail(PurchaseAskPriceM.AskNo); lstUpdate.Add(DelDtl); foreach (PurchaseAskPriceDetailModel PurchaseAskPriceDetailM in PurchaseAskPriceDetailMList) { SqlCommand AddDtl = PurchaseAskPriceDBHelper.InsertPurAskPriceDetail(PurchaseAskPriceDetailM); lstUpdate.Add(AddDtl); } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstUpdate); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(PurchaseAskPriceM.AskNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
/// <summary> /// 扩展属性保存操作 /// </summary> /// <returns></returns> private static void GetExtAttrCmd(PurchaseAskPriceModel model, Hashtable htExtAttr, SqlCommand cmd) { try { string strSql = string.Empty; strSql = "UPDATE officedba.PurchaseAskPrice 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 AskNo = @AskNo"; cmd.Parameters.AddWithValue("@CompanyCD",((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD); cmd.Parameters.AddWithValue("@AskNo", model.AskNo ); cmd.CommandText = strSql; } catch (Exception) { } }