コード例 #1
0
        public bool Add(Business_DataModel model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append(" insert into opm_business_data(uid,btype,prjid,bcode,bname,codeid,dutyuser,designer,flowstate,begindate,  ");
            builder.Append(" enddate,cause,remark,adduser,addtime,isvalid) ");
            builder.Append(" values( ");
            builder.Append(" '" + model.UID + "', ");
            builder.Append(" '" + model.BType + "', ");
            builder.Append(" '" + model.PrjId + "', ");
            builder.Append(" '" + model.BCode + "', ");
            builder.Append(" '" + model.BName + "', ");
            builder.Append(" " + model.CodeId + ", ");
            builder.Append(" '" + model.DutyUser + "', ");
            builder.Append(" '" + model.Designer + "',");
            builder.Append(" " + model.FlowState + ", ");
            builder.Append(" '" + model.BeginDate + "', ");
            if (model.EndDate != null)
            {
                builder.Append(" '" + model.EndDate + "', ");
            }
            else
            {
                builder.Append(" NULL, ");
            }
            builder.Append(" '" + model.Cause + "', ");
            builder.Append(" '" + model.Remark + "', ");
            builder.Append(" '" + model.AddUser + "', ");
            builder.Append(" '" + model.AddTime + "', ");
            builder.Append(" '" + model.IsValid + "' )");
            return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
        }
コード例 #2
0
    public Business_DataModel GetModel()
    {
        Business_DataModel business_DataModel = new Business_DataModel();

        if (this.hdnUID.Value != "")
        {
            business_DataModel.UID = this.hdnUID.Value;
        }
        else
        {
            business_DataModel.UID = System.Guid.NewGuid().ToString();
        }
        business_DataModel.BType    = base.Request["codetype"].ToString();
        business_DataModel.PrjId    = base.Request["pc"].ToString();
        business_DataModel.BCode    = this.txtBCode.Text.Trim().Replace("'", "''");
        business_DataModel.BName    = this.txtBName.Text.Trim().Replace("'", "''");
        business_DataModel.CodeId   = this.CodeID;
        business_DataModel.DutyUser = this.txtDutyUser.Text.Trim().Replace("'", "''");
        if (this.hdfusercode.Value != "")
        {
            business_DataModel.Designer = this.hdfusercode.Value;
        }
        else
        {
            business_DataModel.Designer = this.txtDesigner.Value.Trim().Replace("'", "''");
        }
        business_DataModel.BeginDate = System.Convert.ToDateTime(this.txtBeginDate.Text);
        if (this.txtEndDate.Text != "")
        {
            business_DataModel.EndDate = this.txtEndDate.Text;
        }
        else
        {
            business_DataModel.EndDate = null;
        }
        business_DataModel.Cause     = this.txtCause.Value;
        business_DataModel.Remark    = this.txtRemark.Value.Replace("'", "''");
        business_DataModel.AddUser   = base.UserCode;
        business_DataModel.AddTime   = System.Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
        business_DataModel.IsValid   = "1";
        business_DataModel.FlowState = -1;
        return(business_DataModel);
    }
コード例 #3
0
        public bool Update(Business_DataModel model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append(" update opm_business_data set  ");
            builder.Append(" btype='" + model.BType + "',");
            builder.Append(" BCode='" + model.BCode + "',");
            builder.Append(" BName='" + model.BName + "',");
            builder.Append(" DutyUser='******',");
            builder.Append(" Designer='" + model.Designer + "',");
            builder.Append(" BeginDate='" + model.BeginDate + "',");
            if (model.EndDate != null)
            {
                builder.Append(" EndDate='" + model.EndDate + "',");
            }
            else
            {
                builder.Append(" EndDate=NULL,");
            }
            builder.Append(" Cause='" + model.Cause + "',");
            builder.Append(" Remark='" + model.Remark + "'");
            builder.Append(" where UID='" + model.UID + "'");
            return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
        }
コード例 #4
0
    protected void btnSave_Click(object sender, System.EventArgs e)
    {
        Business_DataModel model = new Business_DataModel();

        model = this.GetModel();
        if (base.Request["type"] != null)
        {
            if (base.Request["type"].ToString() == "add")
            {
                if (this.action.Add(model))
                {
                    base.RegisterScript("top.ui.tabSuccess({ parentName: '_Business_Data_Manage' });");
                    return;
                }
            }
            else
            {
                if (this.action.Update(model))
                {
                    base.RegisterScript("top.ui.tabSuccess({ parentName: '_Business_Data_Manage' });");
                }
            }
        }
    }