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();
}
