private ProgressProceedInfo FormatToModel(DataRow dr) { ProgressProceedInfo info = new ProgressProceedInfo { Account = dr["Account"].ToString(), AdministerFruitUnit = dr["AdministerFruitUnit"].ToString(), AppPrejectName = dr["AppPrejectName"].ToString(), DealinMinister = dr["DealinMinister"].ToString(), EndDate = DateTime.Parse(dr["EndDate"].ToString()), PPMAdvancementIncomeCount = decimal.Parse(dr["PPMAdvancementIncomeCount"].ToString()), Engineer = dr["Engineer"].ToString() }; if (DateTime.Parse(dr["EntAuditDate"].ToString()).ToShortDateString() != "1900-1-1") { info.EntAuditDate = DateTime.Parse(dr["EntAuditDate"].ToString()); } info.EntAuditIdea = dr["EntAuditIdea"].ToString(); info.EntAuditPeople = dr["EntAuditPeople"].ToString(); info.EntAuditResult = dr["EntAuditResult"].ToString() == "True"; info.EtcaeterasPeopleAmount = int.Parse(dr["EtcaeterasPeopleAmount"].ToString()); info.FruitContent = dr["FruitContent"].ToString(); info.FruitName = dr["FruitName"].ToString(); info.MainID = int.Parse(dr["MainID"].ToString()); info.PPMAuditResult = int.Parse(dr["PPMAuditResult"].ToString()); info.PPMCommitteeIdea = dr["PPMCommitteeIdea"].ToString(); info.PPMDeclareUnitIdea = dr["PPMDeclareUnitIdea"].ToString(); info.PPMGroupIdea = dr["PPMGroupIdea"].ToString(); info.PPMRemark = dr["PPMRemark"].ToString(); info.PPMSerialNumber = dr["PPMSerialNumber"].ToString(); info.PrejectMinister = dr["PrejectMinister"].ToString(); info.PrjCode = dr["PrjCode"].ToString(); info.StartDate = DateTime.Parse(dr["StartDate"].ToString()); info.AuditValue = decimal.Parse(dr["ComAuditValue"].ToString()); return(info); }
public static bool EntpmAuditProce(ProgressProceedInfo objInfo) { string str2 = "Update Prj_TechnologyAdvancementIncome set EntAuditPeople='" + objInfo.EntAuditPeople + "',EntAuditDate='"; string str3 = str2 + objInfo.EntAuditDate.ToString() + "',EntAuditResult=" + (objInfo.EntAuditResult ? "1" : "0") + ",EntAuditIdea='"; return(publicDbOpClass.NonQuerySqlString(str3 + objInfo.EntAuditIdea + "',ComAuditValue=" + objInfo.AuditValue.ToString() + " where MainId = " + objInfo.MainID.ToString())); }
public static bool PpmAuditProce(ProgressProceedInfo objInfo) { string str2 = "Update Prj_TechnologyAdvancementIncome set PPMSerialNumber='" + objInfo.PPMSerialNumber + "',PPMAuditResult="; string str3 = str2 + objInfo.PPMAuditResult.ToString() + ",PPMDeclareUnitIdea='" + objInfo.PPMDeclareUnitIdea + "',PPMGroupIdea='"; return(publicDbOpClass.NonQuerySqlString((str3 + objInfo.PPMGroupIdea + "',PPMCommitteeIdea='" + objInfo.PPMCommitteeIdea + "',PPMRemark='") + objInfo.PPMRemark + "' where MainID = " + objInfo.MainID.ToString())); }
public static bool EditProce(ProgressProceedInfo objInfo) { string str2 = "Update Prj_TechnologyAdvancementIncome set FruitName='"; string str3 = str2 + objInfo.FruitName + "',AdministerFruitUnit='" + objInfo.AdministerFruitUnit + "',EtcaeterasPeopleAmount="; string str4 = str3 + objInfo.EtcaeterasPeopleAmount.ToString() + ",AppPrejectName='" + objInfo.AppPrejectName + "',StartDate='"; string str5 = (str4 + objInfo.StartDate.ToString() + "',EndDate='" + objInfo.EndDate.ToString() + "',PPMAdvancementIncomeCount=") + objInfo.PPMAdvancementIncomeCount.ToString(); string str6 = str5 + ",Account='" + objInfo.Account + "',FruitContent='" + objInfo.FruitContent + "',Engineer='" + objInfo.Engineer; return(publicDbOpClass.NonQuerySqlString((str6 + "',PrejectMinister='" + objInfo.PrejectMinister + "',DealinMinister='" + objInfo.DealinMinister + "'") + " where MainID = " + objInfo.MainID.ToString())); }
private void BindData() { ProgressProceedAction progressProceedAction = new ProgressProceedAction(); ProgressProceedInfo proceInfo = progressProceedAction.GetProceInfo(int.Parse(this.hidMainId.Value)); this.txtEntAuditDate.Text = proceInfo.EntAuditDate.ToShortDateString(); this.txtEntAuditIdea.Text = proceInfo.EntAuditIdea; this.txtEntAuditPeople.Text = ((proceInfo.EntAuditPeople == "") ? userManageDb.GetCurrentUserInfo().UserName : proceInfo.EntAuditPeople); this.ddlEntAuditResult.SelectedValue = (proceInfo.EntAuditResult ? "1" : "0"); this.txtAuditValue.Text = proceInfo.AuditValue.ToString(); }
public ProgressProceedInfo GetProceInfo(int MainID) { string sqlString = string.Format("select * from Prj_TechnologyAdvancementIncome where MainID={0}", MainID); ProgressProceedInfo info = new ProgressProceedInfo(); foreach (DataRow row in publicDbOpClass.DataTableQuary(sqlString).Rows) { info = this.FormatToModel(row); } return(info); }
public static bool AddNewProce(ProgressProceedInfo objInfo, out int MainID) { objInfo.MainID = GetNewMainID(); string str2 = "insert into Prj_TechnologyAdvancementIncome values(" + objInfo.MainID.ToString() + ",'" + objInfo.PrjCode + "'"; string str3 = str2 + ",'" + objInfo.FruitName + "','" + objInfo.AdministerFruitUnit + "'," + objInfo.EtcaeterasPeopleAmount.ToString(); string str4 = str3 + ",'" + objInfo.AppPrejectName + "'," + objInfo.PPMAdvancementIncomeCount.ToString(); string str5 = str4 + ",'" + objInfo.StartDate.ToString() + "','" + objInfo.EndDate.ToString(); string sqlString = (str5 + "','" + objInfo.Account + "','" + objInfo.FruitContent + "','" + objInfo.Engineer + "','" + objInfo.PrejectMinister) + "','" + objInfo.DealinMinister + "','','',0,'','',0,'','','','',0)"; MainID = objInfo.MainID; return(publicDbOpClass.NonQuerySqlString(sqlString)); }
private void BindData() { ProgressProceedAction progressProceedAction = new ProgressProceedAction(); ProgressProceedInfo proceInfo = progressProceedAction.GetProceInfo(int.Parse(this.hidMainId.Value)); this.txtPPMSerialNumber.Text = proceInfo.PPMSerialNumber; this.txtPPMRemark.Text = proceInfo.PPMRemark; this.txtPPMGroupIdea.Text = proceInfo.PPMGroupIdea; this.txtPPMDeclareUnitIdea.Text = proceInfo.PPMDeclareUnitIdea; this.txtPPMCommitteeIdea.Text = proceInfo.PPMCommitteeIdea; this.ddlPPMAuditResult.SelectedValue = proceInfo.PPMAuditResult.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { ProgressProceedInfo progressProceedInfo = new ProgressProceedInfo(); progressProceedInfo.Account = this.txtAccount.Text; progressProceedInfo.AdministerFruitUnit = this.txtAdministerFruitUnit.Text; progressProceedInfo.AppPrejectName = this.txtAppPrejectName.Text; progressProceedInfo.DealinMinister = this.txtDealinMinister.Text; progressProceedInfo.EndDate = DateTime.Parse(this.txtEndDate.Text); progressProceedInfo.Engineer = this.txtEngineer.Text; progressProceedInfo.EtcaeterasPeopleAmount = int.Parse(this.txtEtcaeterasPeopleAmount.Text); progressProceedInfo.FruitContent = this.txtFruitContent.Text; progressProceedInfo.FruitName = this.txtFruitName.Text; progressProceedInfo.PPMAdvancementIncomeCount = decimal.Parse(this.txtPPMAdvancementIncomeCount.Text); progressProceedInfo.PrejectMinister = this.txtPrejectMinister.Text; progressProceedInfo.StartDate = DateTime.Parse(this.txtStartDate.Text); progressProceedInfo.PrjCode = this.hidPrjCode.Value; int mainID; if (!this.isNew) { progressProceedInfo.MainID = int.Parse(this.hidMainId.Value); mainID = progressProceedInfo.MainID; if (ProgressProceedAction.EditProce(progressProceedInfo)) { this.js.Text = "alert(\"操作成功!\");window.returnValue=true;window.close();"; } else { this.js.Text = "alert(\"操作失败!\");"; } } else { if (ProgressProceedAction.AddNewProce(progressProceedInfo, out mainID)) { this.js.Text = "alert(\"操作成功!\");window.returnValue=true;window.close();"; } else { this.js.Text = "alert(\"操作失败!\");"; } } this.hidMainId.Value = mainID.ToString(); this.hidIsNew.Value = "false"; this.BindData(); }
private void BindData() { ProgressProceedAction progressProceedAction = new ProgressProceedAction(); int mainID = (this.hidMainId.Value == "") ? 0 : int.Parse(this.hidMainId.Value); ProgressProceedInfo proceInfo = progressProceedAction.GetProceInfo(mainID); this.txtAccount.Text = proceInfo.Account; this.txtAdministerFruitUnit.Text = proceInfo.AdministerFruitUnit; this.txtAppPrejectName.Text = proceInfo.AppPrejectName; this.txtDealinMinister.Text = proceInfo.DealinMinister; this.txtEndDate.Text = proceInfo.EndDate.ToShortDateString(); this.txtEngineer.Text = proceInfo.Engineer; this.txtEtcaeterasPeopleAmount.Text = proceInfo.EtcaeterasPeopleAmount.ToString(); this.txtFruitContent.Text = proceInfo.FruitContent; this.txtFruitName.Text = proceInfo.FruitName; this.txtPPMAdvancementIncomeCount.Text = proceInfo.PPMAdvancementIncomeCount.ToString(); this.txtPrejectMinister.Text = proceInfo.PrejectMinister; this.txtStartDate.Text = proceInfo.StartDate.ToShortDateString(); this.hidMainId.Value = proceInfo.MainID.ToString(); }