private void btnDel_Click(object sender, EventArgs e)
{
EquipmentMaintainFittingCollection equipmentMaintainFittingCollection = this.dgdFittingsDetail_GetData();
equipmentMaintainFittingCollection.RemoveAt(int.Parse(this.hdnSelectedIndex.Value));
this.dgdFittingsDetail_Bind(equipmentMaintainFittingCollection);
}
private void dgdFittingsDetail_Bind(EquipmentMaintainFittingCollection al)
{
this.dgdFittings.DataSource = al;
this.dgdFittings.DataBind();
this.Session["RepairRecordList"] = al;
this.lblState.Text = "共" + al.Count.ToString() + "条记录！";
}
protected void BtnRepairEdit_Click(object sender, EventArgs e)
{
EquipmentMaintainFittingCollection templist = this.dgdFittingsDetail_GetData();
string a;
if ((a = this.ViewState["OPTYPE"].ToString()) != null)
{
if (!(a == "0"))
{
if (!(a == "1"))
{
return;
}
if (EquipmentMaintainAction.UpdMaintainInfo(this.GetEquipmentMaintainInfo(), templist, (Guid)this.ViewState["MAINTAINUNIQUECODE"]) == 1)
{
this.js.Text = "alert('数据修改成功');window.returnValue=true;window.close();";
return;
}
this.js.Text = "alert('数据修改失败');";
}
else
{
if (EquipmentMaintainAction.AddMaintainInfo(this.GetEquipmentMaintainInfo(), templist) == 1)
{
this.js.Text = "alert('数据增加成功');window.returnValue = true;window.close();";
return;
}
this.js.Text = "alert('数据添加失败');";
return;
}
}
}
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 btnAdd_Click(object sender, EventArgs e)
{
EquipmentMaintainFittingCollection equipmentMaintainFittingCollection = this.dgdFittingsDetail_GetData();
equipmentMaintainFittingCollection.Add(new EquipmentMaintainFittingInfo
{
MaintainUniqueCode = (Guid)this.ViewState["MAINTAINUNIQUECODE"]
});
this.dgdFittingsDetail_Bind(equipmentMaintainFittingCollection);
}
public static EquipmentMaintainFittingCollection GetMaintainFittingsList(Guid maintainUniqueCode)
{
EquipmentMaintainFittingCollection fittings = new EquipmentMaintainFittingCollection();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from Ent_Ept_MaintainFittings where MaintainUniqueCode = '" + maintainUniqueCode.ToString() + "'"))
{
for (int i = 0; i < table.Rows.Count; i++)
{
fittings.Add(GetFittingInfoFrowDataRow(table.Rows[i]));
}
}
return(fittings);
}
private EquipmentMaintainFittingCollection dgdFittingsDetail_GetData()
{
EquipmentMaintainFittingCollection equipmentMaintainFittingCollection = (EquipmentMaintainFittingCollection)this.Session["RepairRecordList"];
for (int i = this.dgdFittings.Items.Count - 1; i >= 0; i--)
{
DataGridItem dataGridItem = this.dgdFittings.Items[i];
equipmentMaintainFittingCollection[i].FittingsName = ((TextBox)dataGridItem.Cells[0].Controls[1]).Text;
equipmentMaintainFittingCollection[i].Spec = ((TextBox)dataGridItem.Cells[1].Controls[1]).Text;
equipmentMaintainFittingCollection[i].Quality = Convert.ToInt32(((TextBox)dataGridItem.Cells[2].Controls[1]).Text);
equipmentMaintainFittingCollection[i].Operation = ((TextBox)dataGridItem.Cells[3].Controls[1]).Text;
equipmentMaintainFittingCollection[i].Remark = ((TextBox)dataGridItem.Cells[4].Controls[1]).Text;
}
return(equipmentMaintainFittingCollection);
}
public static string AddAndDeleteRecordList(EquipmentMaintainFittingCollection templist, Guid maintainUniqueCode)
{
string str = "";
object obj2 = str;
str = string.Concat(new object[] { obj2, " delete from Ent_Ept_MaintainFittings where MaintainUniqueCode='", maintainUniqueCode, "' " });
EquipmentMaintainFittingInfo info = new EquipmentMaintainFittingInfo();
for (int i = 0; i < templist.Count; i++)
{
info = templist[i];
if (info.FittingsName.Trim() != "")
{
object obj3 = str + " insert into Ent_Ept_MaintainFittings(MaintainUniqueCode,FittingsName,Spec,Quality,Operation,Remark) ";
str = string.Concat(new object[] { obj3, "values('", maintainUniqueCode, "','", info.FittingsName, "','", info.Spec, "',", info.Quality.ToString(), ",'", info.Operation, "','", info.Remark, "') " });
}
}
return(str);
}
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 "));
}