public static int Add(XBase.Model.Office.SellReport.UserProductInfo model) { int num = 0; string sqlstr = "insert into officedba.UserProductInfo(CompanyCD,productNum,productName,price,bref,memo) values(@CompanyCD,@productNum,@productName,@price,@bref,@memo)"; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); SqlParameter[] param = { new SqlParameter("@CompanyCD",SqlDbType.VarChar,50), new SqlParameter("@productNum",SqlDbType.VarChar,50), new SqlParameter("@productName",SqlDbType.VarChar,200), new SqlParameter("@price",SqlDbType.Decimal), new SqlParameter("@bref",SqlDbType.VarChar,500), new SqlParameter("@memo",SqlDbType.VarChar,1000) }; param[0].Value = model.CompanyCD; param[1].Value = model.productNum; param[2].Value = model.productName; param[3].Value = model.price; param[4].Value = model.bref; param[5].Value = model.memo; try { num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr, param); tran.Commit(); } catch { tran.Rollback(); } return num; }
/// <summary> /// 更新销售委托代销单 /// </summary> /// <returns></returns> public static bool UpdateOrder(Hashtable ht, SellChannelSttlModel sellChannelSttlModel, List<SellChannelSttlDetailModel> sellChannelSttlDetailModellist, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; if (IsUpdate(sellChannelSttlModel.SttlNo)) { string strSql = "delete from officedba.SellChannelSttlDetail where SttlNo=@SttlNo and CompanyCD=@CompanyCD"; SqlParameter[] paras = { new SqlParameter("@SttlNo", sellChannelSttlModel.SttlNo), new SqlParameter("@CompanyCD", sellChannelSttlModel.CompanyCD) }; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { UpdateOrderInfo(ht,sellChannelSttlModel, tran); SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), paras); InsertOrderDetail(sellChannelSttlDetailModellist, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "非制单状态的未提交审批、审批未通过或撤销审批单据不可修改!"; } return isSucc; }
/// <summary> /// 添加费用申请单 /// </summary> /// <param name="expApplyModel"></param> /// <param name="expDetailModelList"></param> /// <param name="strMsg"></param> /// <returns></returns> public static bool SaveExpensesApply(ExpensesApplyModel expApplyModel, List<ExpDetailsModel> expDetailModelList,out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; //判断单据编号是否存在 if (NoIsExist(expApplyModel.ExpCode,expApplyModel.CompanyCD)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { int expID; expID = InsertExpensesApply(expApplyModel, tran); InsertExpensesDetails(expDetailModelList, expID,tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未使用的编号!"; } return isSucc; }
/// <summary> /// 保存费用报销单 /// </summary> /// <param name="reimbModel"></param> /// <param name="reimbDetailList"></param> /// <param name="strMsg"></param> public static bool SaveReimbursement(ReimbursementModel reimbModel, List<ReimbDetailsModel> reimbDetailList, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; //判断单据编号是否存在 if (NoIsExist(reimbModel.ReimbNo, reimbModel.CompanyCD)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { int reimbID; reimbID = InsertReimbursement(reimbModel, tran); InsertReimbDetails(reimbDetailList, reimbID, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未使用的编号!"; } return isSucc; }
/// <summary> /// 保存销售委托代销单 /// </summary> /// <returns></returns> public static bool SaveOrder(Hashtable ht, SellChannelSttlModel sellChannelSttlModel, List<SellChannelSttlDetailModel> sellChannelSttlDetailModellist, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; //判断单据编号是否存在 if (NoIsExist(sellChannelSttlModel.SttlNo)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { InsertOrderInfo(ht,sellChannelSttlModel, tran); InsertOrderDetail(sellChannelSttlDetailModellist, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未使用的编号!"; } return isSucc; }
public static int AddSubBudgetInfo(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo) { StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("insert into officedba.SubBudget(CompanyCD,projectid,BudgetName) values(@CompanyCD,@projectid,@BudgetName)"); SqlParameter[] param = { new SqlParameter("@CompanyCD",SqlDbType.VarChar,50), new SqlParameter("@projectid",SqlDbType.Int), new SqlParameter("@BudgetName",SqlDbType.VarChar,200) }; param[0].Value = userinfo.CompanyCD; param[1].Value = subBudgetModel.Projectid; param[2].Value = subBudgetModel.BudgetName; TransactionManager tran = new TransactionManager(); int num = 0; tran.BeginTransaction(); try { num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr.ToString(), param); tran.Commit(); } catch { tran.Rollback(); } return num; }
/// <summary> /// 修改自定义表单 /// </summary> /// <param name="model"></param> /// <param name="sonModel"></param> /// <param name="strMsg"></param> /// <returns></returns> public static bool EditTable(CustomTableModel model, List<StructTable> sonModel, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; string strSql = "delete from defdba.StructTable where TableID=@TableID "; SqlParameter[] paras = { new SqlParameter("@TableID", model.ID) }; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { EidtCustomTable(model, tran); SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), paras); AddStructTable(sonModel, Convert.ToInt32(model.ID), tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } return isSucc; }
public static int EditSubBudget(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo) { StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("update officedba.SubBudget set BudgetName=@BudgetName,projectid=@projectid where ID=@ID"); SqlParameter[] param = { new SqlParameter("@BudgetName",SqlDbType.VarChar,200), new SqlParameter("@projectid",SqlDbType.Int,4), new SqlParameter("@ID",SqlDbType.Int) }; param[0].Value = subBudgetModel.BudgetName; param[1].Value = subBudgetModel.Projectid; param[2].Value = subBudgetModel.ID; TransactionManager tran = new TransactionManager(); int num = 0; tran.BeginTransaction(); try { num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr.ToString(), param); tran.Commit(); } catch { tran.Rollback(); } return num; }
public static int Update(XBase.Model.Office.SellReport.UserProductInfo model) { int num = 0; string sqlstr = "update officedba.UserProductInfo set productNum=@productNum,productName=@productName,price=@price,bref=@bref,memo=@memo where id=@id"; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); SqlParameter[] param = { new SqlParameter("@CompanyCD",SqlDbType.VarChar,50), new SqlParameter("@productNum",SqlDbType.VarChar,50), new SqlParameter("@productName",SqlDbType.VarChar,200), new SqlParameter("@price",SqlDbType.Decimal), new SqlParameter("@bref",SqlDbType.VarChar,500), new SqlParameter("@memo",SqlDbType.VarChar,1000), new SqlParameter("@id",SqlDbType.Int,4) }; param[0].Value = model.CompanyCD; param[1].Value = model.productNum; param[2].Value = model.productName; param[3].Value = model.price; param[4].Value = model.bref; param[5].Value = model.memo; param[6].Value = model.id; try { num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr, param); tran.Commit(); } catch { tran.Rollback(); } return num; }
/// <summary> /// 添加自定义表单 /// </summary> /// <returns></returns> public static int AddTable(CustomTableModel model, List<StructTable> sonModel, out string strMsg) { int TableID = 0; strMsg = ""; //判断单据编号是否存在 if (!Exists(model.CompanyCD, model.CustomTableName)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { TableID = AddCustomTable(model, tran); AddStructTable(sonModel, TableID, tran); tran.Commit(); strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { strMsg = "该表名已被使用,请输入未使用的表名!"; } return TableID; }
/// <summary> /// 保存批次规则设置 /// </summary> /// <param name="model">BachNoRuleSet实体</param> /// <param name="strMsg">返回信息</param> /// <returns>规则ID</returns> public static int SaveBatchRule(BatchNoRuleSet model, out string strMsg) { int ruleID = 0; strMsg = ""; StringBuilder strSql = new StringBuilder(); if (!IsExisted(model.CompanyCD)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { strSql.AppendLine(" insert into officedba.BatchRule "); strSql.AppendLine(" (CompanyCD,RuleName,RulePrefix,RuleDateType,RuleNoLen,LastNo,RuleExample,"); strSql.AppendLine(" Remark,IsDefault,UsedStatus,ModifiedDate,ModifiedUserID) values"); strSql.AppendLine(" (@CompanyCD,@RuleName,@RulePrefix,@RuleDateType,@RuleNoLen,@LastNo,@RuleExample,"); strSql.AppendLine(" @Remark,@IsDefault,@UsedStatus,getdate(),@ModifiedUserID)"); strSql.AppendLine(" ;select @@IDENTITY "); SqlParameter[] param = { new SqlParameter("@CompanyCD",model.CompanyCD), new SqlParameter("@RuleName",model.RuleName), new SqlParameter("@RulePrefix",model.RulePrefix), new SqlParameter("@RuleDateType",model.RuleDateType), new SqlParameter("@RuleNoLen",model.RuleNoLen), new SqlParameter("@LastNo",model.LastNo), new SqlParameter("@RuleExample",model.RuleExample), new SqlParameter("@Remark",model.Remark), new SqlParameter("@IsDefault",model.IsDefault), new SqlParameter("@UsedStatus",model.UsedStatus), new SqlParameter("@ModifiedUserID",model.ModifiedUserID) }; foreach (SqlParameter para in param) { if (para.Value == null) { para.Value = DBNull.Value; } } ruleID = Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), param)); tran.Commit(); strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { strMsg = "保存失败,已存在批次规则!"; } return ruleID; }
/// <summary> /// 更新销售计划 /// </summary> /// <returns></returns> public static bool Update(Hashtable ht,SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetailModel, string strDetailAction, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; if (IsUpdate(sellPlanModel.PlanNo)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { UpdateOrder(sellPlanModel, tran); #region 拓展属性 GetExtAttrCmd(sellPlanModel, ht, tran); #endregion //明细操作的类型 switch (strDetailAction) { case "1"://无操作 break; case "2"://添加新明细 InsertOrderDetail(sellPlanDetailModel, tran); break; case "3"://更新明细 UpdateOrderDetail(sellPlanDetailModel, tran); break; case "4"://删除明细 DelOrderDetail(sellPlanDetailModel, tran); break; default: break; } tran.Commit(); strMsg = "保存成功!"; isSucc = true; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "非制单状态的未提交审批、审批未通过或撤销审批计划不可修改!"; } return isSucc; }
/// <summary> /// 保存模板 /// </summary> /// <param name="tbModel">ModuleTableModel模板实体</param> /// <param name="strMsg"></param> public static int SaveTableModel(ModuleTableModel tbModel, out string strMsg) { StringBuilder strSql = new StringBuilder(); strMsg = ""; int tbID = 0; if (!IsRepeatedModule(tbModel.TableID, "0")) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { strSql.AppendLine(" insert into defdba.ModuleTable (CompanyCD,ModuleContent,TableID,ModuleType,UseStatus)"); strSql.AppendLine(" values(@CompanyCD,@ModuleContent,@TableID,@ModuleType,@UseStatus)"); strSql.AppendLine(" ;select @@IDENTITY "); SqlParameter[] param = { new SqlParameter("@CompanyCD",tbModel.CompanyCD ), new SqlParameter("@ModuleContent",tbModel.ModuleContent ), new SqlParameter("@TableID",tbModel.TableID ), new SqlParameter("@ModuleType",tbModel.ModuleType ), new SqlParameter("@UseStatus",tbModel.UseStatus ) }; foreach (SqlParameter para in param) { if (para.Value == null) { para.Value = DBNull.Value; } } tbID = Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), param)); tran.Commit(); strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { strMsg = "保存失败,该表的模板已定义!"; } return tbID; }
/// <summary> /// 添加销售机会及阶段 /// </summary> /// <param name="sellChanceModel">销售机会表实体</param> /// <param name="sellChancePushModel">销售阶段表实体</param> /// <returns>是否添加成功</returns> public static bool InsertSellChance(Hashtable ht,SellChanceModel sellChanceModel, SellChancePushModel sellChancePushModel) { bool isSucc = false;//是否添加成功 TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { int sellChID = InsertChanece(tran, sellChanceModel); //若是设置了手机提醒 则插入以下信息 if (sellChanceModel.IsMobileNotice == "1") { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into officedba.NoticeHistory("); strSql.Append(" CompanyCD,SourceFlag,SourceID,PlanNoticeDate ) "); strSql.Append(" values(@CompanyCD, @SourceFlag,@SourceID,@PlanNoticeDate ) "); SqlParameter[] param = { new SqlParameter("@CompanyCD",sellChanceModel.CompanyCD), new SqlParameter("@SourceFlag","4"), new SqlParameter("@SourceID",sellChID), new SqlParameter("@PlanNoticeDate",sellChanceModel.RemindTime) }; SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), param);//.ExecuteTransWithCommand(commN); } //拓展属性 GetExtAttrCmd(sellChanceModel,ht, tran); InsertPush(tran, sellChancePushModel); tran.Commit(); isSucc = true; } catch (Exception ex) { tran.Rollback(); isSucc = false; throw ex; } return isSucc; }
/// <summary> /// 添加新单据 /// </summary> /// <returns></returns> public static bool Insert(VoucherTemplateModel voucherTemplateModel, List<VoucherTemplateDetailModel> voucherTemplateDetailModelList, out string strMsg, out int Id) { bool isSucc = false;//是否添加成功 strMsg = ""; Id = 0; //判断单据编号是否存在 if (NoIsExist(voucherTemplateModel.TemNo)) { if (IsTypeUsed(voucherTemplateModel.TemType.ToString(), voucherTemplateModel.CompanyCD)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { InsertVoucherTemplate(voucherTemplateModel, tran, out Id); InsertVoucherTemplateDetail(voucherTemplateDetailModelList, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该模板类型已存在,请选择其他未使用的模板类型!"; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未使用的编号!"; } return isSucc; }
/// <summary> /// 保存销售计划 /// </summary> /// <returns></returns> public static bool Save(Hashtable ht,SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetailModel, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; //判断计划编号是否存在 if (NoIsExist(sellPlanModel.PlanNo)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { InsertOrder(sellPlanModel, tran); #region 拓展属性 GetExtAttrCmd(sellPlanModel, ht, tran); #endregion if (sellPlanDetailModel.PlanNo != null) { InsertOrderDetail(sellPlanDetailModel, tran); } tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未被使用的编号!"; } return isSucc; }
/// <summary> /// 添加销售报价单 /// </summary> /// <param name="sellChanceModel">销售机会表实体</param> /// <param name="sellChancePushModel">销售阶段表实体</param> /// <returns>是否添加成功</returns> public static bool InsertOrder(Hashtable ht, SellOfferModel sellOfferModel, List<SellOfferDetailModel> SellOrderDetailModelList, List<SellOfferHistoryModel> sellOfferHistoryModelList, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; //判断单据编号是否存在 if (NoIsExist(sellOfferModel.OfferNo)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { InsertSellOffer(sellOfferModel, tran); //拓展属性 GetExtAttrCmd(sellOfferModel, ht, tran); InsertSellOfferDetail(sellOfferModel, SellOrderDetailModelList, tran); InsertSellOfferHistory(sellOfferModel, sellOfferHistoryModelList, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); isSucc = false; strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未使用的编号!"; } return isSucc; }
/// <summary> /// 添加单据 /// </summary> /// <param name="sellChanceModel">销售机会表实体</param> /// <param name="sellChancePushModel">销售阶段表实体</param> /// <returns>是否添加成功</returns> public static bool InsertOrder(AdversaryInfoModel adversaryInfoModel, List<AdversaryDynamicModel> adversaryDynamicModelList) { bool isSucc = false;//是否添加成功 TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { InsertAdversaryInfo( adversaryInfoModel, tran); InsertAdversaryDynamic(adversaryDynamicModelList, tran); tran.Commit(); isSucc = true; } catch(Exception ex) { tran.Rollback(); isSucc = false; throw ex; } return isSucc; }
public static bool Insert(SellReportModel sellrptModel, List<SellReportDetailModel> sellRptDetailModellList, out string strMsg) { bool isSucc = false;//是否添加成功 int billID = 0; strMsg = ""; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { billID = InsertSellReport(sellrptModel, tran); InsertSellReportDetail(sellRptDetailModellList,billID, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!|"+billID; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } return isSucc; }
/// <summary> /// 修改销售合同 /// </summary> /// <param name="sellChanceModel">销售合同表实体</param> /// <param name="sellChancePushModel">销售阶段表实体</param> /// <returns>是否添加成功</returns> public static bool UpdateOrder(Hashtable ht,SellContractModel sellContractModel, List<SellContractDetailModel> SellContractDetailModelList, out string strMsg) { bool isSucc = false;//是否添加成功 strMsg = ""; if (IsUpdate(sellContractModel.ContractNo)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { UpdateSellContract(sellContractModel, tran); //拓展属性 GetExtAttrCmd(sellContractModel, ht, tran); InsertSellContractDetail(SellContractDetailModelList, sellContractModel, tran); tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "非制单状态的未提交审批、审批未通过或撤销审批单据不可修改!"; } return isSucc; }
public static bool UpdateMoveApplyCancelConfirm(string BillStatus, string ID, string userID, string CompanyID, string ReprotNo) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.RectApply"); sql.AppendLine(" SET BillStatus=@Status "); sql.AppendLine(" ,ModifiedDate=getdate() "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine(" ,ConfirmDate = null "); sql.AppendLine(" ,Confirmor = null "); sql.AppendLine("WHERE "); sql.AppendLine(" CompanyCD = @CompanyCD "); sql.AppendLine(" AND RectApplyNo = @RectApplyNo "); SqlParameter[] param; param = new SqlParameter[4]; param[0] = SqlHelper.GetParameter("@Status", BillStatus); param[1] = SqlHelper.GetParameter("@ModifiedUserID", userID); param[2] = SqlHelper.GetParameter("@CompanyCD", CompanyID); param[3] = SqlHelper.GetParameter("@RectApplyNo", ReprotNo); //SqlHelper.ExecuteTransSql(sql.ToString(), param); TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { FlowDBHelper.OperateCancelConfirm(CompanyID, Convert.ToInt32(XBase.Common.ConstUtil.BILL_TYPEFLAG_HUMAN), Convert.ToInt32(XBase.Common.ConstUtil.BILL_TYPECODE_HUMAN_RECT_APPLY), Convert.ToInt32(ID), userID, tran);//取消确认 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sql.ToString(), param); tran.Commit(); return true; } catch { tran.Rollback(); return false; } } catch { return false; } }
/// <summary> /// 取消调职确认信息 /// </summary> /// <param name="CarApplyM">车辆申请信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool UpdateMoveApplyCancelConfirm(string BillStatus,string ID, string userID, string CompanyID) { try { #region 车辆申请信息SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.EmplApply"); sql.AppendLine(" SET Status=@Status "); sql.AppendLine(" ,ModifiedDate=getdate() "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine("WHERE "); sql.AppendLine(" ID=@ID "); #endregion #region 车辆申请信息参数设置 SqlParameter[] param; param = new SqlParameter[3]; param[0] = SqlHelper.GetParameter("@Status", BillStatus); param[1] = SqlHelper.GetParameter("@ModifiedUserID", userID); param[2] = SqlHelper.GetParameter("@ID", ID); #endregion //SqlHelper.ExecuteTransSql(sql.ToString(), param); TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { FlowDBHelper.OperateCancelConfirm(CompanyID, 2, 12, Convert.ToInt32(ID), userID, tran);//取消确认 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sql.ToString(), param); tran.Commit(); return true; } catch { tran.Rollback(); return false; } } catch { return false; } }
/// <summary> /// 删除分项预算概要 及其项目摘要,项目预算表中与该“分项预算概要”相关的单据 /// </summary> /// <param name="billID">删除的ID串</param> /// <returns></returns> public static int DeLSubBudgetInfo(string billID) { StringBuilder sqlstr = new StringBuilder(); TransactionManager tran = new TransactionManager(); int num = 0; string[] billIDArr = billID.Split(','); string str = ""; string budgetIDstr = "-1"; //获取要删除的项目摘要ID串 for (int i = 0; i < billIDArr.Length; i++) { str = "select budgetID from officedba.budgetsummary where subBudgetID=@ID "; SqlParameter[] paramstr = { new SqlParameter("@ID",billIDArr[i].ToString().Trim()) }; int budgetID = Convert.ToInt32(SqlHelper.ExecuteScalar(str.ToString(), paramstr)); budgetIDstr += ","+budgetID; } //删除与此分项预算概要相关的“项目摘要”及其“项目预算表信息” sqlstr.AppendLine("delete from officedba.budgetSummary where subBudgetID in (" + billID + ")"); sqlstr.AppendLine("delete from officedba.ProjectBaseNum where SummaryID in (" + budgetIDstr + ")"); sqlstr.AppendLine("delete from officedba.ProjectBudgetDetails where SummaryID in (" + budgetIDstr + ")"); sqlstr.AppendLine("delete from officedba.SubBudget where ID in (" + billID + ")"); tran.BeginTransaction(); try { num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr.ToString()); tran.Commit(); } catch { tran.Rollback(); } return num; }
/// <summary> /// 添加新单据 /// </summary> /// <returns></returns> public static bool Insert(FeesModel sellOrderModel, List<FeesDetailModel> sellOrderDetailModellList, out string strMsg,out int Id) { bool isSucc = false;//是否添加成功 strMsg = ""; Id = 0; //判断单据编号是否存在 if (NoIsExist(sellOrderModel.FeesNo)) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { InsertSellOrder(sellOrderModel, tran,out Id); InsertSellOrderDetail(sellOrderDetailModellList, tran); if (sellOrderModel.FeesType != "0") { //非无源单时,更改源单开票状态 updateSourceByFeesType(sellOrderModel.FeesType, sellOrderModel.SourceNo, tran); } tran.Commit(); isSucc = true; strMsg = "保存成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "保存失败,请联系系统管理员!"; throw ex; } } else { isSucc = false; strMsg = "该编号已被使用,请输入未使用的编号!"; } return isSucc; }
public static bool Del(string orderNos, out string strMsg, out string strFieldText) { string strCompanyCD = string.Empty;//单位编号 bool isSucc = false; string allOrderNo = ""; strMsg = ""; strFieldText = ""; bool bTemp = false;//单据是否可以被删除 System.Text.StringBuilder sb = new System.Text.StringBuilder(); TransactionManager tran = new TransactionManager(); strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; string[] orderNoS = null; orderNoS = orderNos.Split(','); for (int i = 0; i < orderNoS.Length; i++) { if (!IsFlow(orderNoS[i])) { strFieldText += "单据:" + orderNoS[i] + "|"; strMsg += "已确认后的单据不允许删除!|"; bTemp = true; } orderNoS[i] = "'" + orderNoS[i] + "'"; sb.Append(orderNoS[i]); } allOrderNo = sb.ToString().Replace("''", "','"); if (!bTemp) { tran.BeginTransaction(); try { //源单改为“未开票” UpdateSourceIsFeesAccount(tran.Trans, strCompanyCD, allOrderNo); SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "DELETE FROM officedba.Fees WHERE FeesNo IN ( " + allOrderNo + " ) and CompanyCD='" + strCompanyCD + "'", null); SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "DELETE FROM officedba.FeesDetail WHERE FeesNo IN ( " + allOrderNo + " ) and CompanyCD='" + strCompanyCD + "'", null); tran.Commit(); isSucc = true; strMsg = "删除成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "删除失败,请联系系统管理员!"; isSucc = false; throw ex; } } else { isSucc = false; } return isSucc; }
/// <summary> /// 删除回款计划 /// </summary> /// <param name="strIDS"></param> /// <returns></returns> public static bool DelSellGathering(string strIDS, out string strMsg) { bool isSucc = false;//是否添加成功 string strSql = "delete from officedba.SellGathering where ID = @ID"; string[] strId = strIDS.Split(','); strMsg = ""; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { for (int i = 0; i < strId.Length; i++) { SqlParameter[] para = { new SqlParameter("@ID", Convert.ToInt32(strId[i])) }; SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql, para); } tran.Commit(); isSucc = true; strMsg = "删除成功!"; } catch (Exception ex) { tran.Rollback(); strMsg = "删除失败,请联系系统管理员!"; isSucc = false; throw ex; } return isSucc; }
public static int DelReportList(string idlist) { //删除报表设置 string sqlstr = "delete from defdba.ReportTable where ID in ( "+idlist+" )"; //删除菜单 string[] arr = idlist.Split(','); for (int i = 0; i < arr.Length; i++) { sqlstr += ";" + "delete from defdba.CustomModule where PropertyValue='Pages/Office/DefManager/ReportTableList.aspx?reportid=" + arr[i] + "'"; } TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { int num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr); tran.Commit(); return num; } catch { tran.Rollback(); return 0; } }
/// <summary> /// 删除单据 /// </summary> /// <param name="orderNos"></param> /// <returns></returns> public static bool DelOrder(string orderNos) { string strCompanyCD = string.Empty;//单位编号 bool isSucc = false; string allOrderNo = ""; System.Text.StringBuilder sb = new System.Text.StringBuilder(); TransactionManager tran = new TransactionManager(); strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; string[] orderNoS = null; orderNoS = orderNos.Split(','); for (int i = 0; i < orderNoS.Length; i++) { orderNoS[i] = "'" + orderNoS[i] + "'"; sb.Append(orderNoS[i]); } allOrderNo = sb.ToString().Replace("''", "','"); tran.BeginTransaction(); try { SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "DELETE FROM officedba.AdversaryInfo WHERE CustNo IN ( " + allOrderNo + " ) and CompanyCD='" + strCompanyCD + "'", null); SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "DELETE FROM officedba.AdversaryDynamic WHERE CustNo IN ( " + allOrderNo + " ) and CompanyCD='" + strCompanyCD + "'", null); tran.Commit(); isSucc = true; } catch (Exception ex) { tran.Rollback(); isSucc = false; throw ex; } return isSucc; }
/// <summary> /// 跟新单据单据 /// </summary> /// <param name="sellChanceModel">销售机会表实体</param> /// <param name="sellChancePushModel">销售阶段表实体</param> /// <returns>是否添加成功</returns> public static bool UpdateOrder(AdversaryInfoModel adversaryInfoModel, List<AdversaryDynamicModel> adversaryDynamicModelList) { bool isSucc = false;//是否添加成功 string strSql = "delete from officedba.AdversaryDynamic where CustNo=@CustNo and CompanyCD=@CompanyCD"; SqlParameter[] paras = { new SqlParameter("@CustNo", adversaryInfoModel.CustNo), new SqlParameter("@CompanyCD", adversaryInfoModel.CompanyCD) }; TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { UpdateAdversaryInfo( adversaryInfoModel, tran); SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), paras); InsertAdversaryDynamic(adversaryDynamicModelList, tran); tran.Commit(); isSucc = true; } catch(Exception ex) { tran.Rollback(); isSucc = false; throw ex; } return isSucc; }
/// <summary> /// 删除自定义表单 /// </summary> /// <param name="id">数据ID</param> /// <param name="tableName">物理表名</param> /// <param name="CompanyCD">机构代码</param> public static void DelTable(string id, string tableName, string CompanyCD) { TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { if (!string.IsNullOrEmpty(tableName)) {// 删除物理表 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "DROP TABLE " + tableName, null); } // 删除表 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "delete from defdba.CustomTable where ID =" + id, null); // 删除表结构 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "delete from defdba.StructTable where TableID =" + id, null); // 删除模板表 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, "delete from defdba.ModuleTable where TableID =" + id, null); // 删除菜单 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text , string.Format("DELETE FROM defdba.CustomModule WHERE PropertyValue ='Pages/Office/DefManager/DefTableList.aspx?tableid={0}' AND CompanyCD='{1}' ", id, CompanyCD), null); tran.Commit(); } catch { tran.Rollback(); } }