public int UpdEquipmentPlan(EquipmentPlanInfo epi)
{
string str = "";
str = " begin ";
return(publicDbOpClass.ExecSqlString((((((((str + " update Ent_Ept_Plan ") + " set PlanCreatTime = '" + epi.PlanCreatTime.ToShortDateString() + "',") + " EnterDate = '" + epi.EnterDate.ToShortDateString() + "',") + " ExitDate = '" + epi.ExitDate.ToShortDateString() + "',") + " PlanMaker = '" + epi.PlanMaker + "',") + " Remark = '" + epi.Remark + "' ") + " where PlanCode = '" + epi.PlanCode + "' ") + " end "));
}
public int AddEquipmentPlan(EquipmentPlanInfo epi)
{
string str = "";
str = " begin ";
object obj2 = str + " insert into Ent_Ept_Plan(PlanCode, PlanCreatTime, EnterDate, ExitDate, PlanMaker, PrjCode, Remark, IsAuditing, IsFullUsed) ";
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] {
obj2, " values('", epi.PlanCode, "','", epi.PlanCreatTime.ToShortDateString(), "','", epi.EnterDate.ToShortDateString(), "','", epi.ExitDate.ToShortDateString(), "','", epi.PlanMaker, "','", epi.PrjCode.ToString(), "','", epi.Remark, "', ",
epi.IsAuditing, ", ", epi.IsFullUsed, ") "
}) + " end "));
}
private void resWfplan(string wfcode)
{
EquipmentPlanInfo equipmentPlanInfo = new EquipmentPlanInfo();
equipmentPlanInfo = this.equipmentAction.GetwfPlanforGuid(wfcode);
this.txtPlanCode.Text = equipmentPlanInfo.PlanCode;
this.txtPlanMaker.Text = equipmentPlanInfo.PlanMaker;
this.txtRemark.Text = equipmentPlanInfo.Remark;
this.calPlanCreatTime.Text = equipmentPlanInfo.PlanCreatTime.ToShortDateString();
this.calEnterDate.Text = equipmentPlanInfo.EnterDate.ToShortDateString();
this.calExitDate.Text = equipmentPlanInfo.ExitDate.ToShortDateString();
this.ViewState["ResourcesTable"] = this.equipmentAction.GetResourceByPlanCode(this.hdfCode.Value);
this.grdDetail.DataSource = this.ViewState["ResourcesTable"];
this.grdDetail.DataBind();
}
private void RestoreEquipmentPlan(string PlanId)
{
EquipmentPlanInfo equipmentPlanInfo = new EquipmentPlanInfo();
if (PlanId.Length > 20)
{
equipmentPlanInfo = this.equipmentAction.GetwfPlanforGuid(PlanId);
}
else
{
equipmentPlanInfo = this.equipmentAction.GetSingleEquipmentPlan(PlanId);
}
this.txtPlanCode.Text = equipmentPlanInfo.PlanCode;
this.txtPlanMaker.Text = equipmentPlanInfo.PlanMaker;
this.txtRemark.Text = equipmentPlanInfo.Remark;
this.calPlanCreatTime.Text = equipmentPlanInfo.PlanCreatTime.ToShortDateString();
this.calEnterDate.Text = equipmentPlanInfo.EnterDate.ToShortDateString();
this.calExitDate.Text = equipmentPlanInfo.ExitDate.ToShortDateString();
this.txtPrjName.Text = this.GetPrjName(equipmentPlanInfo.PrjCode.ToString());
this.ViewState["ResourcesTable"] = this.equipmentAction.GetResourceByPlanCode(equipmentPlanInfo.PlanCode);
this.grdDetail.DataSource = this.ViewState["ResourcesTable"];
this.grdDetail.DataBind();
}
