private void DGRepairList_ItemDataBound(object sender, DataGridItemEventArgs e)
{
switch (e.Item.ItemType)
{
case ListItemType.Item:
case ListItemType.AlternatingItem:
{
EquipmentMaintainInfo equipmentMaintainInfo = (EquipmentMaintainInfo)e.Item.DataItem;
e.Item.Attributes["onmouseover"] = "doMouseOver(this);";
e.Item.Attributes["onmouseout"] = "doMouseOut(this);";
e.Item.Attributes["onclick"] = string.Concat(new string[]
{
"doClick(this,'",
this.dgdRepairList.ClientID,
"');clickRow('",
equipmentMaintainInfo.MaintainUniqueCode.ToString(),
"');"
});
return;
}
default:
return;
}
}
private void RestoreMaintainInfo(Guid maintainUniqueCode)
{
EquipmentMaintainInfo equipmentMaintainInfo = new EquipmentMaintainInfo();
equipmentMaintainInfo = EquipmentMaintainAction.GetSingleEquipemntMaintainInfo(maintainUniqueCode);
this.ShowRepairInfo(equipmentMaintainInfo);
this.ShowEquipmentInfo(equipmentMaintainInfo.EquipmentUniqueCode);
this.dgdFittingsDetail_Bind(EquipmentMaintainAction.GetMaintainFittingsList(maintainUniqueCode));
}
public static int AddMaintainInfo(EquipmentMaintainInfo eptinfo, EquipmentMaintainFittingCollection templist)
{
string str = "";
string str2 = str + " begin " + " insert into Ent_Ept_Maintain";
string str3 = str2 + " values('" + eptinfo.MaintainUniqueCode.ToString() + "','" + eptinfo.EquipmentUniqueCode.ToString() + "',";
string str4 = str3 + "'" + eptinfo.MaintainType + "'," + eptinfo.MaintainCost.ToString() + ",'" + eptinfo.Fault + "',";
string str5 = str4 + "'" + eptinfo.MaintainContent + "','" + eptinfo.MaintainceMan + "','" + eptinfo.MaintainDate.ToShortDateString() + "',";
return(publicDbOpClass.ExecSqlString(((str5 + "'" + eptinfo.RecordDate.ToShortDateString() + "','" + eptinfo.Appraisal + "','" + eptinfo.Appraiser + "',") + "'" + eptinfo.AppraisalDate.ToShortDateString() + "') ") + AddAndDeleteRecordList(templist, eptinfo.MaintainUniqueCode) + " end "));
}
private void ShowRepairInfo(EquipmentMaintainInfo EptMtinfo)
{
this.txtMaintainType.Text = EptMtinfo.MaintainType;
this.txtMaintainCost.Text = EptMtinfo.MaintainCost.ToString();
this.txtMaintainDate.Text = ((EptMtinfo.MaintainDate == DateTime.MinValue) ? DateTime.Today.ToShortDateString() : EptMtinfo.MaintainDate.ToShortDateString());
this.txtFault.Text = EptMtinfo.Fault;
this.txtMaintainContent.Text = EptMtinfo.MaintainContent;
this.txtMaintainceMan.Text = EptMtinfo.MaintainceMan;
this.txtAppraisal.Text = EptMtinfo.Appraisal;
this.txtAppraiser.Text = EptMtinfo.Appraiser;
this.txtAppraisalDate.Text = ((EptMtinfo.AppraisalDate == DateTime.MinValue) ? DateTime.Today.ToShortDateString() : EptMtinfo.AppraisalDate.ToShortDateString());
}
public static EquipmentMaintainInfo GetSingleEquipemntMaintainInfo(Guid maintainUniqueCode)
{
EquipmentMaintainInfo maintainInfoFrowDataRow = new EquipmentMaintainInfo();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from Ent_Ept_Maintain where MaintainUniqueCode = '" + maintainUniqueCode.ToString() + "'"))
{
if (table.Rows.Count == 1)
{
maintainInfoFrowDataRow = GetMaintainInfoFrowDataRow(table.Rows[0]);
}
}
return(maintainInfoFrowDataRow);
}
private void RestoreMaintainInfo(Guid maintainUniqueCode)
{
EquipmentMaintainInfo eptMtinfo = new EquipmentMaintainInfo();
eptMtinfo = EquipmentMaintainAction.GetSingleEquipemntMaintainInfo(maintainUniqueCode);
this.ShowRepairInfo(eptMtinfo);
if (this.ViewState["OPTYPE"].ToString() == "0")
{
this.dgdFittingsDetail_Bind(new EquipmentMaintainFittingCollection());
return;
}
this.dgdFittingsDetail_Bind(EquipmentMaintainAction.GetMaintainFittingsList(maintainUniqueCode));
}
public static int UpdMaintainInfo(EquipmentMaintainInfo eptinfo, EquipmentMaintainFittingCollection templist, Guid maintainUniqueCode)
{
object obj2 = ((((((((((" begin " + " update Ent_Ept_Maintain ") + " set MaintainType = '" + eptinfo.MaintainType.ToString() + "',") + " MaintainCost = " + eptinfo.MaintainCost.ToString() + ",") + " Fault = '" + eptinfo.Fault.ToString() + "',") + " MaintainContent = '" + eptinfo.MaintainContent + "',") + " MaintainceMan = '" + eptinfo.MaintainceMan + "',") + " MaintainDate = '" + eptinfo.MaintainDate.ToShortDateString() + "',") + " RecordDate = '" + eptinfo.RecordDate.ToShortDateString() + "',") + " Appraisal = '" + eptinfo.Appraisal.ToString() + "',") + " Appraiser = '" + eptinfo.Appraiser.ToString() + "',") + " AppraisalDate = '" + eptinfo.AppraisalDate.ToShortDateString() + "' ";
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, " where MaintainUniqueCode = '", maintainUniqueCode, "'" }) + AddAndDeleteRecordList(templist, maintainUniqueCode) + " end "));
}
