public static string AddSubDeliverySend(SubDeliverySend model, List<SubDeliverySendDetail> modellist, Hashtable htExtAttr) { //定义返回变量 string res = string.Empty; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.LogisticsDistributionManager.SubDeliverySendSaveDBHelper.AddSubDeliverySend(model, modellist, htExtAttr); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (res != string.Empty) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(model.SendNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; ; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return res; }
/// <summary> /// 扩展属性保存操作 /// </summary> /// <returns></returns> private static void GetExtAttrCmd(SubDeliverySend model, Hashtable htExtAttr, SqlCommand cmd) { try { string strSql = string.Empty; strSql = "UPDATE officedba.SubDeliverySend 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 SendNo = @SendNo"; cmd.Parameters.AddWithValue("@CompanyCD", model.CompanyCD); cmd.Parameters.AddWithValue("@SendNo", model.SendNo); cmd.CommandText = strSql; } catch (Exception) { } }
public static bool RunSubDeliverySendIn(SubDeliverySend model) { #region 读取配送单明细 StringBuilder sbSql = new StringBuilder(); sbSql.Append("SELECT sdsd.SendNo,sdsd.ProductID,sdsd.SendPrice,sdsd.SendCount,pi1.IsBatchNo FROM officedba.SubDeliverySendDetail sdsd "); sbSql.Append(" LEFT JOIN officedba.ProductInfo pi1 ON pi1.ID=sdsd.ProductID "); sbSql.Append(" where sdsd.CompanyCD=@CompanyCD AND sdsd.SendNo=@SendNo"); SqlParameter[] Paras = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@SendNo",SqlDbType.VarChar)}; Paras[0].Value = model.CompanyCD; Paras[1].Value = model.SendNo; DataTable dtDetail = SqlHelper.ExecuteSql(sbSql.ToString(), Paras); ArrayList SqlList = new ArrayList(); int id = 0; decimal count = 0m; /*实时判断明细是否存在*/ if (dtDetail != null && dtDetail.Rows.Count > 0) { #region 更新配送单信息 StringBuilder sbMainSql = new StringBuilder(); sbMainSql.Append("UPDATE officedba.SubDeliverySend SET InUserID=@InUserID , InDate=@InDate ,BusiStatus=@BusiStatus "); sbMainSql.Append(" where ID=@ID"); SqlParameter[] MainParas = { new SqlParameter("@InUserID",SqlDbType.Int), new SqlParameter("@InDate",SqlDbType.DateTime), new SqlParameter("@BusiStatus",SqlDbType.VarChar), new SqlParameter("@ID",SqlDbType.Int)}; MainParas[0].Value = model.InUserID; MainParas[1].Value = model.InDate; MainParas[2].Value = model.BusiStatus; MainParas[3].Value = model.ID; SqlCommand SqlMainCmd = new SqlCommand() { CommandText = sbMainSql.ToString() }; SqlMainCmd.Parameters.AddRange(MainParas); SqlList.Add(SqlMainCmd); #endregion foreach (DataRow row in dtDetail.Rows) { string BatchNo = ""; #region 添加门店库存流水帐 if (row["IsBatchNo"].ToString() == "1") { BatchNo = model.BatchNo; } SubStorageAccountModel aModel = new SubStorageAccountModel(); aModel.BatchNo = BatchNo; aModel.BillNo = row["SendNo"].ToString(); aModel.BillType = 2; aModel.CompanyCD = model.CompanyCD; aModel.Creator = model.Creator; aModel.DeptID = model.ApplyDeptID; aModel.HappenDate = DateTime.Now; if (int.TryParse(row["ProductID"].ToString(), out id)) { aModel.ProductID = id; } if (decimal.TryParse(row["SendPrice"].ToString(), out count)) { aModel.Price = count; } if (decimal.TryParse(row["SendCount"].ToString(), out count)) { aModel.HappenCount = count; } aModel.PageUrl = model.Remark; SqlList.Add(XBase.Data.Office.SubStoreManager.SubStorageAccountDBHelper.GetCountAndInsertCommand(aModel)); #endregion SqlList.Add(XBase.Data.Office.LogisticsDistributionManager.StorageProductQueryDBHelper.UpdateProductCount(model.CompanyCD , row["ProductID"].ToString(), model.ApplyDeptID.ToString(), BatchNo, count)); } return SqlHelper.ExecuteTransWithArrayList(SqlList); } else return false; #endregion }
public static bool RunSubDeliverySendOut(SubDeliverySend model, List<SubDeliverySendDetail> modelList) { ArrayList SqlList = new ArrayList(); #region 配送明细单 StringBuilder sbDel = new StringBuilder(); sbDel.Append("DELETE officedba.SubDeliverySendDetail WHERE CompanyCD=@CompanyCD AND SendNo=@SendNo"); SqlParameter[] delParas = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@SendNo",SqlDbType.VarChar) }; delParas[0].Value = model.CompanyCD; delParas[1].Value = model.SendNo; SqlCommand sqlDelCmd = new SqlCommand { CommandText = sbDel.ToString() }; sqlDelCmd.Parameters.AddRange(delParas); SqlList.Add(sqlDelCmd); foreach (Model.Office.LogisticsDistributionManager.SubDeliverySendDetail m in modelList) { SqlList.Add(SaveDetail(m)); #region 添加门店库存流水帐 XBase.Model.Office.StorageManager.StorageAccountModel sModel = new XBase.Model.Office.StorageManager.StorageAccountModel(); sModel.BatchNo = m.BatchNo; sModel.BillNo = m.SendNo; sModel.BillType = 19; sModel.CompanyCD = m.CompanyCD; sModel.StorageID = m.StorageID.Value; sModel.ProductID = m.ProductID.Value; sModel.Creator = model.Creator.Value; sModel.HappenDate = DateTime.Now; sModel.Price = m.SendPrice.Value; sModel.HappenCount = m.SendCount.Value; sModel.PageUrl = model.Remark; SqlList.Add(XBase.Data.Office.StorageManager.StorageAccountDBHelper.InsertStorageAccountCommand(sModel, "1")); #endregion // 更新库存 SqlList.Add(XBase.Data.Office.StorageManager.StorageSearchDBHelper.UpdateProductCount(m.CompanyCD, m.ProductID.ToString(), m.StorageID.ToString() , m.BatchNo, -m.SendCount.Value)); } #endregion #region 更新配送单 StringBuilder sbMainSql = new StringBuilder(); sbMainSql.Append("UPDATE officedba.SubDeliverySend SET OutUserID=@OutUserID,OutDate=@OutDate,BusiStatus=@BusiStatus ,"); sbMainSql.Append("SendPrice=@SendPrice,SendCount=@SendCount "); sbMainSql.Append(" WHERE ID=@ID "); SqlParameter[] MainParas = { new SqlParameter("@OutUserID",SqlDbType.Int), new SqlParameter("@OutDate",SqlDbType.DateTime), new SqlParameter("@BusiStatus",SqlDbType.VarChar), new SqlParameter("@ID",SqlDbType.Int), new SqlParameter("@SendPrice",SqlDbType.Decimal), new SqlParameter("@SendCount",SqlDbType.Decimal) }; MainParas[0].Value = model.OutUserID; MainParas[1].Value = model.OutDate; MainParas[2].Value = model.BusiStatus; MainParas[3].Value = model.ID; MainParas[4].Value = model.SendPrice; MainParas[5].Value = model.SendCount; SqlCommand SqlMainCmd = new SqlCommand() { CommandText = sbMainSql.ToString() }; SqlMainCmd.Parameters.AddRange(MainParas); SqlList.Add(SqlMainCmd); #endregion return SqlHelper.ExecuteTransWithArrayList(SqlList); }
/*打印使用*/ public static DataTable GetSubDeliverySendInfoPrint(SubDeliverySend model) { StringBuilder sbSql = new StringBuilder(); sbSql.AppendLine(" SELECT ID, CompanyCD, SendNo, Title, ApplyUserID, ApplyDeptID, OutDeptID, convert(varchar(10),RequireInDate,120)RequireInDate ,BusiStatus, OutUserID,BatchNo, "); sbSql.AppendLine(" OutDate, InUserID, InDate, BackCount, Remark, Creator,convert(varchar(10),CreateDate,120) CreateDate, BillStatus, Confirmor,convert(varchar(10),ConfirmDate,120) ConfirmDate, Closer, convert(varchar(10),CloseDate,120) CloseDate,convert(varchar(10),ModifiedDate,120) ModifiedDate"); sbSql.AppendLine(" ,CONVERT(NUMERIC(12,2),ISNULL(sds.SendPrice,0)) SendPrice"); sbSql.AppendLine(" ,CONVERT(NUMERIC(12,2),ISNULL(sds.SendCount,0)) SendCount"); sbSql.AppendLine(" ,CONVERT(NUMERIC(12,2),ISNULL(sds.SendFeeSum,0)) SendFeeSum"); sbSql.AppendLine(" ,ModifiedUserID, ExtField1,ExtField2,ExtField3,ExtField4,ExtField5,ExtField6,ExtField7,ExtField8,ExtField9,ExtField10,"); sbSql.AppendLine(" (CASE sds.BusiStatus WHEN '1' THEN '配送申请' WHEN '2' THEN '配送出库' WHEN '3' THEN '配送入库' WHEN '4' THEN '配送完成' END) "); sbSql.AppendLine(" AS BusiStatusText, (CASE sds.BillStatus WHEN '1' THEN '制单' WHEN '2' THEN '执行' WHEN '4' THEN '手工结单' WHEN '5' THEN '自动结单' END) "); sbSql.AppendLine(" AS BillStatusText, "); sbSql.AppendLine(" (SELECT EmployeeName "); sbSql.AppendLine(" FROM officedba.EmployeeInfo AS ei1 "); sbSql.AppendLine(" WHERE (ID = sds.ApplyUserID)) AS ApplyUserIDName, "); sbSql.AppendLine(" (SELECT DeptName "); sbSql.AppendLine(" FROM officedba.DeptInfo AS di1 "); sbSql.AppendLine(" WHERE (ID = sds.OutDeptID)) AS OutDeptIDName, "); sbSql.AppendLine(" (SELECT DeptName "); sbSql.AppendLine(" FROM officedba.DeptInfo AS di2 "); sbSql.AppendLine(" WHERE (ID = sds.ApplyDeptID)) AS ApplyDeptIDName, "); sbSql.AppendLine(" (SELECT EmployeeName "); sbSql.AppendLine(" FROM officedba.EmployeeInfo AS ei2 "); sbSql.AppendLine(" WHERE (ID = sds.OutUserID)) AS OutUserIDName, "); sbSql.AppendLine(" (SELECT EmployeeName "); sbSql.AppendLine(" FROM officedba.EmployeeInfo AS ei3 "); sbSql.AppendLine(" WHERE (ID = sds.InUserID)) AS InUserIDName, "); sbSql.AppendLine(" (SELECT EmployeeName "); sbSql.AppendLine(" FROM officedba.EmployeeInfo AS ei4 "); sbSql.AppendLine(" WHERE (ID = sds.Creator)) AS CreatorName, "); sbSql.AppendLine(" (SELECT EmployeeName "); sbSql.AppendLine(" FROM officedba.EmployeeInfo AS ei5 "); sbSql.AppendLine(" WHERE (ID = sds.Confirmor)) AS ConfirmorName, "); sbSql.AppendLine(" (SELECT EmployeeName "); sbSql.AppendLine(" FROM officedba.EmployeeInfo AS ei6 "); sbSql.AppendLine(" WHERE (ID = sds.Closer)) AS CloserName "); sbSql.AppendLine(" FROM officedba.SubDeliverySend AS sds "); sbSql.AppendLine(" where sds.CompanyCD=@CompanyCD AND sds.ID=@ID"); SqlParameter[] Paras = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@ID",SqlDbType.Int)}; Paras[0].Value = model.CompanyCD; Paras[1].Value = model.ID; return SqlHelper.ExecuteSql(sbSql.ToString(), Paras); }
public static DataTable GetSubDeliverySendInfo(SubDeliverySend model) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("SELECT sds.* ,"); sbSql.Append(" (select ei1.EmployeeName from officedba.EmployeeInfo as ei1 where ei1.ID=sds.ApplyUserID) as ApplyUserIDName,"); sbSql.Append("(select di1.DeptName from officedba.DeptInfo as di1 where di1.ID=sds.OutDeptID ) as OutDeptIDName,"); sbSql.Append("(select di2.DeptName from officedba.DeptInfo as di2 where di2.ID=sds.ApplyDeptID) as ApplyDeptIDName,"); sbSql.Append("(select ei2.EmployeeName from officedba.EmployeeInfo as ei2 where ei2.ID=sds.OutUserID) as OutUserIDName,"); sbSql.Append("(select ei3.EmployeeName from officedba.EmployeeInfo as ei3 where ei3.ID=sds.InUserID) as InUserIDName,"); sbSql.Append("(select ei4.EmployeeName from officedba.EmployeeInfo as ei4 where ei4.ID=sds.Creator) as CreatorName,"); sbSql.Append("(select ei5.EmployeeName from officedba.EmployeeInfo as ei5 where ei5.ID=sds.Confirmor) as ConfirmorName,"); sbSql.Append("(select ei6.EmployeeName from officedba.EmployeeInfo as ei6 where ei6.ID=sds.Closer) as CloserName "); sbSql.Append(" from officedba.SubDeliverySend as sds where sds.CompanyCD=@CompanyCD AND sds.ID=@ID"); SqlParameter[] Paras = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@ID",SqlDbType.Int)}; Paras[0].Value = model.CompanyCD; Paras[1].Value = model.ID; return SqlHelper.ExecuteSql(sbSql.ToString(), Paras); }
public static bool UpdateStatus(SubDeliverySend model, int stype) { if (stype == 1) { #region 确认单据 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliverySend set "); strSql.Append("BusiStatus=@BusiStatus,"); strSql.Append("BillStatus=@BillStatus,"); strSql.Append("Confirmor=@Confirmor,"); strSql.Append("ConfirmDate=@ConfirmDate,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@BusiStatus", SqlDbType.Char,1), new SqlParameter("@BillStatus", SqlDbType.Char,1), new SqlParameter("@Confirmor", SqlDbType.Int,4), new SqlParameter("@ConfirmDate", SqlDbType.DateTime), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50)}; parameters[0].Value = model.ID; parameters[1].Value = model.BusiStatus; parameters[2].Value = model.BillStatus; parameters[3].Value = model.Confirmor; parameters[4].Value = model.ConfirmDate; parameters[5].Value = model.ModifiedDate; parameters[6].Value = model.ModifiedUserID; if (SqlHelper.ExecuteTransSql(strSql.ToString(), parameters) > 0) return true; else return false; #endregion } else if (stype == 3 || stype == 4) { #region 取消结单 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliverySend set "); strSql.Append("BillStatus=@BillStatus,"); if (stype == 4) strSql.Append("BusiStatus=@BusiStatus, "); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID"); strSql.Append(" where ID=@ID "); int length = 4; int index = 0; if (stype == 4) length++; SqlParameter[] parameters = new SqlParameter[length]; parameters[index] = new SqlParameter("@ID", SqlDbType.Int); parameters[index++].Value = model.ID; parameters[index] = new SqlParameter("@BillStatus", SqlDbType.VarChar); parameters[index++].Value = model.BillStatus; parameters[index] = new SqlParameter("@ModifiedDate", SqlDbType.DateTime); parameters[index++].Value = model.ModifiedDate; parameters[index] = new SqlParameter("@ModifiedUserID", SqlDbType.VarChar); parameters[index++].Value = model.ModifiedUserID; if (stype == 4) { parameters[index] = new SqlParameter("@BusiStatus", SqlDbType.VarChar); parameters[index++].Value = model.BusiStatus; } SqlCommand SqlMainCmd = new SqlCommand(); SqlMainCmd.CommandText = strSql.ToString(); SqlMainCmd.Parameters.AddRange(parameters); List<SqlCommand> SqlCmdList = new List<SqlCommand>(); SqlCmdList.Add(SqlMainCmd); /*追加取消确认的SqlCommond*/ if (stype == 4) { IList<SqlCommand> tempList = Data.Common.FlowDBHelper.GetCancelConfirmSqlCommond(model.CompanyCD, Convert.ToInt32(ConstUtil.TYPEFLAG_LogisticsDistribution_NO), Convert.ToInt32(ConstUtil.TYPECODE_SubDeliverySend_NO), model.ID, model.ModifiedUserID); foreach (SqlCommand scmd in tempList) { SqlCmdList.Add(scmd); } } if (SqlHelper.ExecuteTransWithCollections(SqlCmdList)) return true; else return false; #endregion } else if (stype == 2) { #region 结单 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliverySend set "); strSql.Append("BillStatus=@BillStatus,"); strSql.Append("Closer=@Closer,"); strSql.Append("CloseDate=@CloseDate,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@BillStatus", SqlDbType.Char,1), new SqlParameter("@Closer", SqlDbType.Int,4), new SqlParameter("@CloseDate", SqlDbType.DateTime), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50)}; parameters[0].Value = model.ID; parameters[1].Value = model.BillStatus; parameters[2].Value = model.Closer; parameters[3].Value = model.CloseDate; parameters[4].Value = model.ModifiedDate; parameters[5].Value = model.ModifiedUserID; if (SqlHelper.ExecuteTransSql(strSql.ToString(), parameters) > 0) return true; else return false; #endregion } else { return false; } }
public static bool UpdateSubDeliverySend(SubDeliverySend model, List<SubDeliverySendDetail> modelList, Hashtable htExtAttr) { #region 配送单 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliverySend set "); strSql.Append("Title=@Title,"); strSql.Append("ApplyUserID=@ApplyUserID,"); strSql.Append("ApplyDeptID=@ApplyDeptID,"); strSql.Append("OutDeptID=@OutDeptID,"); strSql.Append("RequireInDate=@RequireInDate,"); strSql.Append("SendPrice=@SendPrice,"); strSql.Append("SendCount=@SendCount,"); strSql.Append("SendFeeSum=@SendFeeSum,"); strSql.Append("Remark=@Remark,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID,"); strSql.Append("BatchNo=@BatchNo"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@Title", SqlDbType.VarChar,100), new SqlParameter("@ApplyUserID", SqlDbType.Int,4), new SqlParameter("@ApplyDeptID", SqlDbType.Int,4), new SqlParameter("@OutDeptID", SqlDbType.Int,4), new SqlParameter("@RequireInDate", SqlDbType.DateTime), new SqlParameter("@SendPrice", SqlDbType.Decimal,9), new SqlParameter("@SendCount", SqlDbType.Decimal,9), new SqlParameter("@SendFeeSum", SqlDbType.Decimal,9), new SqlParameter("@Remark", SqlDbType.VarChar,800), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50), new SqlParameter("@BatchNo", SqlDbType.VarChar,50)}; parameters[0].Value = model.ID; parameters[1].Value = model.Title; parameters[2].Value = model.ApplyUserID; parameters[3].Value = model.ApplyDeptID; parameters[4].Value = model.OutDeptID; parameters[5].Value = model.RequireInDate; parameters[6].Value = model.SendPrice; parameters[7].Value = model.SendCount; parameters[8].Value = model.SendFeeSum; parameters[9].Value = model.Remark; parameters[10].Value = model.ModifiedDate; parameters[11].Value = model.ModifiedUserID; parameters[12].Value = model.BatchNo; #endregion ArrayList SqlList = new ArrayList(); SqlCommand SqlCmd = new SqlCommand { CommandText = strSql.ToString() }; SqlCmd.Parameters.AddRange(parameters); SqlList.Add(SqlCmd); #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(model, htExtAttr, cmd); if (htExtAttr.Count > 0) SqlList.Add(cmd); #endregion #region 配送明细单 StringBuilder sbDel = new StringBuilder(); sbDel.Append("DELETE officedba.SubDeliverySendDetail WHERE CompanyCD=@CompanyCD AND SendNo=@SendNo"); SqlParameter[] delParas = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@SendNo",SqlDbType.VarChar) }; delParas[0].Value = model.CompanyCD; delParas[1].Value = model.SendNo; SqlCommand sqlDelCmd = new SqlCommand { CommandText = sbDel.ToString() }; sqlDelCmd.Parameters.AddRange(delParas); SqlList.Add(sqlDelCmd); foreach (Model.Office.LogisticsDistributionManager.SubDeliverySendDetail m in modelList) { SqlList.Add(SaveDetail(m)); } #endregion bool result = SqlHelper.ExecuteTransWithArrayList(SqlList); return result; }
public static bool RunSubDeliverySendIn(SubDeliverySend model) { //定义返回变量 bool res = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.LogisticsDistributionManager.SubDeliverySendSaveDBHelper.RunSubDeliverySendIn(model); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (res) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(model.SendNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return res; }
/*打印使用*/ public static DataTable GetSubDeliverySendInfoPrint(SubDeliverySend model) { return XBase.Data.Office.LogisticsDistributionManager.SubDeliverySendSaveDBHelper.GetSubDeliverySendInfoPrint(model); }
public static bool UpdateStatus(SubDeliverySend model, int stype) { //定义返回变量 bool res = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.LogisticsDistributionManager.SubDeliverySendSaveDBHelper.UpdateStatus(model, stype); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (res) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(model.SendNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 string msg = string.Empty; switch (stype) { case 1: /*确认*/ msg = ConstUtil.LOG_PROCESS_CONFIRM; break; case 2: /*结单*/ msg = ConstUtil.LOG_PROCESS_COMPLETE; break; case 3: /*取消结单*/ msg = ConstUtil.LOG_PROCESS_CONCELCOMPLETE; break; case 4: /*取消确认*/ msg = ConstUtil.LOG_PROCESS_UNCONFIRM; break; } logModel.Element = msg; ; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return res; }