protected void btnDel_Click(object sender, System.EventArgs e) { ConIncometContractService conIncometContractService = new ConIncometContractService(); BudContractTaskService budContractTaskService = new BudContractTaskService(); using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString)) { sqlConnection.Open(); SqlTransaction sqlTransaction = sqlConnection.BeginTransaction(); try { string message = ""; System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(); foreach (GridViewRow gridViewRow in this.gvConract.Rows) { CheckBox checkBox = gridViewRow.FindControl("cbBox") as CheckBox; if (checkBox != null && checkBox.Checked) { if (!this.incometContractBll.IsDel(checkBox.ToolTip)) { list.Clear(); message = "alert('系统提示:\\n\\n请先删除与收款合同相关的其他数据!')"; break; } ConIncometContract byContractId = conIncometContractService.GetByContractId(checkBox.ToolTip); budContractTaskService.DelRalationBudgetAndContract(byContractId.Project, checkBox.ToolTip); this.rptSev.DelByContractId(checkBox.ToolTip); list.Add(checkBox.ToolTip); message = "alert('系统提示:\\n\\n数据删除成功!');location='IncometContractList.aspx'"; } } Common2.DelByStrWhere("Con_Incomet_Contract", " where ContractId in (" + StringUtility.GetArrayToInStr(list.ToArray()) + ")"); ConConfigContractService conConfigContractService = new ConConfigContractService(); conConfigContractService.Deltes(list); base.RegisterScript(message); sqlTransaction.Commit(); this.BindGv(); } catch (System.Exception) { sqlTransaction.Rollback(); base.RegisterScript("alert('系统提示:\\n\\n对不起删除失败!');"); } } }
private void AddContractConfig(string contractID) { ConConfigContract conConfigContract = new ConConfigContract(); ConConfigContractService conConfigContractService = new ConConfigContractService(); string contractId = string.Empty; if (!string.IsNullOrEmpty(this.txtContractCode.Text.Trim())) { ConIncometContract byContractCode = new ConIncometContractService().GetByContractCode(this.txtContractCode.Text.Trim()); contractId = byContractCode.ContractID; } if (string.IsNullOrEmpty(contractID)) { conConfigContract.Id = System.Guid.NewGuid().ToString(); conConfigContract.ContractId = contractId; conConfigContract.PayoutAlarmDays = new int?(ContractParameter.PayoutAlarmDays); conConfigContract.IncomeAlarmDays = new int?(ContractParameter.IncomeAlarmDays); conConfigContract.HighPayAlarmLimit = new decimal?(ContractParameter.HighPayAlarmLimit); conConfigContract.HighBalanceAlarmLimit = new decimal?(ContractParameter.HighBalanceAlarmLimit); conConfigContract.MidPayAlarmUpperLimit = new decimal?(ContractParameter.MidPayAlarmUpperLimit); conConfigContract.MidPayAlarmLowerLimit = new decimal?(ContractParameter.MidPayAlarmLowerLimit); conConfigContract.MidBalanceAlarmUpperLimit = new decimal?(ContractParameter.LowBalanceAlarmUpperLimit); conConfigContract.MidBalanceAlarmLowerLimit = new decimal?(ContractParameter.LowBalanceAlarmLowerLimit); conConfigContract.LowPayAlarmUpperLimit = new decimal?(ContractParameter.LowPayAlarmUpperLimit); conConfigContract.LowPayAlarmLowerLimit = new decimal?(ContractParameter.LowBalanceAlarmLowerLimit); conConfigContract.LowBalanceAlarmUpperLimit = new decimal?(ContractParameter.LowBalanceAlarmUpperLimit); conConfigContract.LowBalanceAlarmLowerLimit = new decimal?(ContractParameter.LowBalanceAlarmLowerLimit); conConfigContract.IsPayoutAlarm = ContractParameter.IsPayoutAlarm; conConfigContract.IsPaymentAlarm = ContractParameter.IsPaymentAlarm; conConfigContract.IsIncomeAlarm = ContractParameter.IsIncomeAlarm; conConfigContract.IsBalanceAlarm = ContractParameter.IsBalanceAlarm; } else { conConfigContract = conConfigContractService.GetByContractID(contractID); conConfigContract.Id = System.Guid.NewGuid().ToString(); conConfigContract.ContractId = contractId; } conConfigContractService.Add(conConfigContract); }