protected void GetPageData() { SalaryGAModel model = this.sga.GetModel(this.rid); userManageDb userManageDb = new userManageDb(); this.txtUserCode.Text = userManageDb.GetUserName(model.UserCode); this.txtRemark.Text = model.Remark; this.DBApplyDate.Text = model.ApplyDate.ToString(); }
public int Update(SalaryGAModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update HR_Salary_GroupAdjust set "); builder.Append("AuditState=" + model.AuditState + ","); builder.Append("ApplyDate='" + model.ApplyDate + "',"); builder.Append("Remark='" + model.Remark + "',"); builder.Append("UserCode='" + model.UserCode + "',"); builder.Append("RecordDate='" + model.RecordDate + "',"); builder.Append("IsConfirm='" + model.IsConfirm + "'"); builder.Append(" where RecordID='" + model.RecordID + "' "); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(SalaryGAModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into HR_Salary_GroupAdjust("); builder.Append("AuditState,ApplyDate,Remark,UserCode,RecordDate,IsConfirm"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.AuditState + ","); builder.Append("'" + model.ApplyDate + "',"); builder.Append("'" + model.Remark + "',"); builder.Append("'" + model.UserCode + "',"); builder.Append("'" + model.RecordDate + "',"); builder.Append("'" + model.IsConfirm + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void GetPageData() { SalaryGAModel model = this.sga.GetModel(this.InstanceCode); userManageDb userManageDb = new userManageDb(); this.LbUserCode.Text = userManageDb.GetUserName(model.UserCode); this.LbRemark.Text = model.Remark; this.LbApplyDate.Text = model.ApplyDate.ToString(); SqlDataSource expr_65 = this.SqGroupAdjustDetail; object selectCommand = expr_65.SelectCommand; expr_65.SelectCommand = string.Concat(new object[] { selectCommand, " WHERE [RecordID] = '", this.InstanceCode, "' " }); this.GVGroupAdjustDetail.DataBind(); }
public SalaryGAModel GetModel(Guid RecordID) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" RecordID,AuditState,ApplyDate,Remark,UserCode,RecordDate,IsConfirm "); builder.Append(" from HR_Salary_GroupAdjust "); builder.Append(" where RecordID='" + RecordID + "' "); SalaryGAModel model = new SalaryGAModel(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { model.RecordID = new Guid(set.Tables[0].Rows[0]["RecordID"].ToString()); } if (set.Tables[0].Rows[0]["AuditState"].ToString() != "") { model.AuditState = new int?(int.Parse(set.Tables[0].Rows[0]["AuditState"].ToString())); } if (set.Tables[0].Rows[0]["ApplyDate"].ToString() != "") { model.ApplyDate = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["ApplyDate"].ToString())); } model.Remark = set.Tables[0].Rows[0]["Remark"].ToString(); model.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString(); if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "") { model.RecordDate = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString())); } model.IsConfirm = set.Tables[0].Rows[0]["IsConfirm"].ToString(); return(model); }