Exemplo n.º 1
0
    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对不起删除失败!');");
            }
        }
    }
Exemplo n.º 2
0
    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);
    }