public static string AddSubDeliveryTrans(SubDeliveryTrans model, List<SubDeliveryTransDetail> modellist, Hashtable htExtAttr) { //定义返回变量 string res = string.Empty; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.LogisticsDistributionManager.SubDeliveryTransDBHelper.AddSubDeliveryTrans(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.TransNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; ; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return res; }
/// <summary> /// 扩展属性保存操作 /// </summary> /// <returns></returns> private static void GetExtAttrCmd(SubDeliveryTrans model, Hashtable htExtAttr, SqlCommand cmd) { try { string strSql = string.Empty; strSql = "UPDATE officedba.SubDeliveryTrans 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 TransNo = @TransNo"; cmd.Parameters.AddWithValue("@CompanyCD", model.CompanyCD); cmd.Parameters.AddWithValue("@TransNo", model.TransNo); cmd.CommandText = strSql; } catch (Exception) { } }
public static bool RunSubDeliveryTransIn(SubDeliveryTrans model) { ArrayList SqlList = new ArrayList(); #region 更新调拨单 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliveryTrans set "); strSql.Append("BusiStatus=@BusiStatus,"); strSql.Append("InUserID=@InUserID,"); strSql.Append("InDate=@InDate"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@BusiStatus", SqlDbType.Char,1), new SqlParameter("@InUserID", SqlDbType.Int,4), new SqlParameter("@InDate", SqlDbType.DateTime)}; parameters[0].Value = model.ID; parameters[1].Value = model.BusiStatus; parameters[2].Value = model.InUserID; parameters[3].Value = model.InDate; #endregion SqlCommand sqlMainCmd = new SqlCommand() { CommandText = strSql.ToString() }; sqlMainCmd.Parameters.AddRange(parameters); SqlList.Add(sqlMainCmd); #region 实时读取明细信息 StringBuilder sbDetailSql = new StringBuilder(); sbDetailSql.Append(" SELECT ProductID,TransCount,BatchNo,TransPrice FROM officedba.SubDeliveryTransDetail "); sbDetailSql.Append(" WHERE CompanyCD=@CompanyCD AND TransNo=@TransNo"); SqlParameter[] DetailParas = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@TransNo",SqlDbType.VarChar)}; DetailParas[0].Value = model.CompanyCD; DetailParas[1].Value = model.TransNo; DataTable dtDetails = SqlHelper.ExecuteSql(sbDetailSql.ToString(), DetailParas); #endregion int id = 0; decimal count = 0m; if (dtDetails != null && dtDetails.Rows.Count > 0) { foreach (DataRow row in dtDetails.Rows) { #region 添加门店库存流水帐 SubStorageAccountModel aModel = new SubStorageAccountModel(); aModel.BatchNo = row["BatchNo"].ToString().Trim(); aModel.BillNo = model.TransNo; aModel.BillType = 6; aModel.CompanyCD = model.CompanyCD; aModel.Creator = model.Creator; aModel.DeptID = model.InDeptID; aModel.HappenDate = DateTime.Now; if (int.TryParse(row["ProductID"].ToString(), out id)) { aModel.ProductID = id; } if (decimal.TryParse(row["TransPrice"].ToString(), out count)) { aModel.Price = count; } if (decimal.TryParse(row["TransCount"].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.InDeptID.ToString(), row["BatchNo"].ToString(), count)); } return SqlHelper.ExecuteTransWithArrayList(SqlList); } else return false; }
/*打印使用*/ public static DataTable GetSubDeliveryTransInfoPrint(SubDeliveryTrans model) { StringBuilder sbSql = new StringBuilder(); sbSql.AppendLine(" "); sbSql.AppendLine(" SELECT ID, CompanyCD, TransNo, Title, ApplyUserID, OutDeptID, InDeptID, TransDeptID, Reason, BusiStatus, "); sbSql.AppendLine(" OutUserID, OutDate, InUserID, InDate, 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("ExtField1,ExtField2,ExtField3,ExtField4,ExtField5,ExtField6,ExtField7,ExtField8,ExtField9,ExtField10"); sbSql.AppendLine(" ,CONVERT(NUMERIC(12,2),ISNULL(sds.TransPrice,0)) TransPrice"); sbSql.AppendLine(" ,CONVERT(NUMERIC(12,2),ISNULL(sds.TransFeeSum,0)) TransFeeSum"); sbSql.AppendLine(" ,CONVERT(NUMERIC(12,2),ISNULL(sds.TransCount,0)) TransCount"); sbSql.AppendLine(" ,ModifiedUserID "); 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.InDeptID)) AS InDeptIDName, "); sbSql.AppendLine(" (SELECT DeptName "); sbSql.AppendLine(" FROM officedba.DeptInfo AS di3 "); sbSql.AppendLine(" WHERE (ID = sds.TransDeptID)) AS TransDeptIDName, "); 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.SubDeliveryTrans 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 GetSubDeliveryTransInfo(SubDeliveryTrans 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.InDeptID) as InDeptIDName,"); sbSql.Append("(select di3.DeptName from officedba.DeptInfo as di3 where di3.ID=sds.TransDeptID ) AS TransDeptIDName ,"); 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.SubDeliveryTrans 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 string AddSubDeliveryTrans(SubDeliveryTrans model, List<SubDeliveryTransDetail> modellist, Hashtable htExtAttr) { #region 构造调拨单 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into officedba.SubDeliveryTrans("); strSql.Append("CompanyCD,TransNo,Title,ApplyUserID,OutDeptID,InDeptID,TransDeptID,TransPrice,TransFeeSum,TransCount,Reason,BusiStatus,Remark,Creator,CreateDate,BillStatus,ModifiedDate,ModifiedUserID)"); strSql.Append(" values ("); strSql.Append("@CompanyCD,@TransNo,@Title,@ApplyUserID,@OutDeptID,@InDeptID,@TransDeptID,@TransPrice,@TransFeeSum,@TransCount,@Reason,@BusiStatus,@Remark,@Creator,@CreateDate,@BillStatus,@ModifiedDate,@ModifiedUserID)"); strSql.Append(";select @ID=@@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CompanyCD", SqlDbType.VarChar,8), new SqlParameter("@TransNo", SqlDbType.VarChar,50), new SqlParameter("@Title", SqlDbType.VarChar,100), new SqlParameter("@ApplyUserID", SqlDbType.Int,4), new SqlParameter("@OutDeptID", SqlDbType.Int,4), new SqlParameter("@InDeptID", SqlDbType.Int,4), new SqlParameter("@TransDeptID", SqlDbType.Int,4), new SqlParameter("@TransPrice", SqlDbType.Decimal,9), new SqlParameter("@TransFeeSum", SqlDbType.Decimal,9), new SqlParameter("@TransCount", SqlDbType.Decimal,9), new SqlParameter("@Reason", SqlDbType.VarChar,1024), new SqlParameter("@BusiStatus", SqlDbType.Char,1), new SqlParameter("@Remark", SqlDbType.VarChar,800), new SqlParameter("@Creator", SqlDbType.Int,4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@BillStatus", SqlDbType.Char,1), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50), new SqlParameter("@ID",SqlDbType.Int)}; parameters[0].Value = model.CompanyCD; parameters[1].Value = model.TransNo; parameters[2].Value = model.Title; parameters[3].Value = model.ApplyUserID; parameters[4].Value = model.OutDeptID; parameters[5].Value = model.InDeptID; if (model.TransDeptID.HasValue) { parameters[6].Value = model.TransDeptID; } else { parameters[6].Value = DBNull.Value; } parameters[7].Value = model.TransPrice; parameters[8].Value = model.TransFeeSum; parameters[9].Value = model.TransCount; parameters[10].Value = model.Reason; parameters[11].Value = model.BusiStatus; parameters[12].Value = model.Remark; parameters[13].Value = model.Creator; parameters[14].Value = model.CreateDate; parameters[15].Value = model.BillStatus; parameters[16].Value = model.ModifiedDate; parameters[17].Value = model.ModifiedUserID; parameters[18].Direction = ParameterDirection.Output; #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 构造调拨单明细 foreach (SubDeliveryTransDetail m in modellist) { SqlList.Add(SaveDetail(m)); } #endregion bool result = SqlHelper.ExecuteTransWithArrayList(SqlList); if (result) { return ((SqlCommand)SqlList[0]).Parameters["@ID"].Value.ToString(); } else return string.Empty; }
public static bool UpdateStatus(SubDeliveryTrans model, int stype) { if (stype == 1) { #region 确认单据 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliveryTrans 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.SubDeliveryTrans set "); strSql.Append("BillStatus=@BillStatus,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID,"); strSql.Append("BusiStatus=@BusiStatus "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@BillStatus", SqlDbType.Char,1), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50), new SqlParameter("@BusiStatus",SqlDbType.VarChar)}; parameters[0].Value = model.ID; parameters[1].Value = model.BillStatus; parameters[2].Value = model.ModifiedDate; parameters[3].Value = model.ModifiedUserID; parameters[4].Value = model.BusiStatus; SqlCommand SqlMainCmd = new SqlCommand() { 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_SubDeliveryTrans_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.SubDeliveryTrans 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 UpdateSubDeliveryTrans(SubDeliveryTrans model, List<SubDeliveryTransDetail> modelList, Hashtable htExtAttr) { #region 更新调拨单主表 StringBuilder strSql = new StringBuilder(); strSql.Append("update officedba.SubDeliveryTrans set "); strSql.Append("Title=@Title,"); strSql.Append("ApplyUserID=@ApplyUserID,"); strSql.Append("OutDeptID=@OutDeptID,"); strSql.Append("InDeptID=@InDeptID,"); strSql.Append("TransDeptID=@TransDeptID,"); strSql.Append("TransPrice=@TransPrice,"); strSql.Append("TransFeeSum=@TransFeeSum,"); strSql.Append("TransCount=@TransCount,"); strSql.Append("Reason=@Reason,"); strSql.Append("Remark=@Remark,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID"); 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("@OutDeptID", SqlDbType.Int,4), new SqlParameter("@InDeptID", SqlDbType.Int,4), new SqlParameter("@TransDeptID", SqlDbType.Int,4), new SqlParameter("@TransPrice", SqlDbType.Decimal,9), new SqlParameter("@TransFeeSum", SqlDbType.Decimal,9), new SqlParameter("@TransCount", SqlDbType.Decimal,9), new SqlParameter("@Reason", SqlDbType.VarChar,1024), new SqlParameter("@Remark", SqlDbType.VarChar,800), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50)}; parameters[0].Value = model.ID; parameters[1].Value = model.Title; parameters[2].Value = model.ApplyUserID; parameters[3].Value = model.OutDeptID; parameters[4].Value = model.InDeptID; if (model.TransDeptID.HasValue) { parameters[5].Value = model.TransDeptID; } else { parameters[5].Value = DBNull.Value; } parameters[6].Value = model.TransPrice; parameters[7].Value = model.TransFeeSum; parameters[8].Value = model.TransCount; parameters[9].Value = model.Reason; parameters[10].Value = model.Remark; parameters[11].Value = model.ModifiedDate; parameters[12].Value = model.ModifiedUserID; #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.SubDeliveryTransDetail WHERE CompanyCD=@CompanyCD AND TransNo=@TransNo"); SqlParameter[] delParas = { new SqlParameter("@CompanyCD",SqlDbType.VarChar), new SqlParameter("@TransNo",SqlDbType.VarChar) }; delParas[0].Value = model.CompanyCD; delParas[1].Value = model.TransNo; SqlCommand sqlDelCmd = new SqlCommand { CommandText = sbDel.ToString() }; sqlDelCmd.Parameters.AddRange(delParas); SqlList.Add(sqlDelCmd); foreach (SubDeliveryTransDetail m in modelList) { SqlList.Add(SaveDetail(m)); } #endregion bool result = SqlHelper.ExecuteTransWithArrayList(SqlList); return result; }
public static bool RunSubDeliveryTransIn(SubDeliveryTrans model) { //定义返回变量 bool res = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.LogisticsDistributionManager.SubDeliveryTransDBHelper.RunSubDeliveryTransIn(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.TransNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return res; }
/*打印使用*/ public static DataTable GetSubDeliveryTransInfoPrint(SubDeliveryTrans model) { return XBase.Data.Office.LogisticsDistributionManager.SubDeliveryTransDBHelper.GetSubDeliveryTransInfoPrint(model); }
public static bool UpdateStatus(SubDeliveryTrans model, int stype) { //定义返回变量 bool res = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.LogisticsDistributionManager.SubDeliveryTransDBHelper.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.TransNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 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; }