public int AddAttemper(EquipmentAttemperInfo ea)
{
string str2 = (" BEGIN " + " INSERT INTO Ent_Ept_Attemper (AttemperBillCode,EquipmentUniqueCode,") + " ToProjectUniqueCode,Suite,IntendingTime,UnitPrice,BeginDate," + " EndDate,Remark)";
object obj2 = (str2 + " VALUES ('" + ea.AttemperBillCode + "','" + ea.EquipmentUniqueCode.ToString() + "',") + " '" + ea.ToProjectUniqueCode.ToString() + "',";
object obj3 = string.Concat(new object[] { obj2, " '", ea.Suite, "','", ea.IntendingTime, "',", ea.UnitPrice, ",'", ea.BeginDate, "'," });
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj3, " '", ea.EndDate, "','", ea.Remark, "')" }) + " END "));
}
public int EDITAttemper(EquipmentAttemperInfo ea)
{
object obj2 = ((" BEGIN " + " UPDATE Ent_Ept_Attemper set AttemperBillCode = '" + ea.AttemperBillCode + "',") + " EquipmentUniqueCode = '" + ea.EquipmentUniqueCode.ToString() + "',") + " ToProjectUniqueCode = '" + ea.ToProjectUniqueCode.ToString() + "',";
object obj3 = string.Concat(new object[] { obj2, " Suite = '", ea.Suite, "', IntendingTime = '", ea.IntendingTime, "'," });
object obj4 = string.Concat(new object[] { obj3, " UnitPrice = ", ea.UnitPrice, "," });
object obj5 = string.Concat(new object[] { obj4, " BeginDate = '", ea.BeginDate, "',EndDate = '", ea.EndDate, "'," }) + " Remark = '" + ea.Remark + "' ";
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj5, " WHERE NoteSequenceID = '", ea.NoteSequenceID, "'" }) + " END"));
}
public static EquipmentAttemperInfo GetEquipmentAttemperInfo(int ID)
{
EquipmentAttemperInfo equipmentAttemperInfoFromDataRow = new EquipmentAttemperInfo();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from Ent_Ept_Attemper where NoteSequenceID = '" + ID + "'"))
{
if (table.Rows.Count > 0)
{
equipmentAttemperInfoFromDataRow = GetEquipmentAttemperInfoFromDataRow(table.Rows[0]);
}
}
return(equipmentAttemperInfoFromDataRow);
}
private void GetAttempterkInfo(int ID)
{
EquipmentAttemperInfo equipmentAttemperInfo = new EquipmentAttemperInfo();
equipmentAttemperInfo = EquipmentAttemperAction.GetEquipmentAttemperInfo(ID);
this.txtAttemperCode.Text = equipmentAttemperInfo.AttemperBillCode;
this.hdnProjectCode.Value = equipmentAttemperInfo.ToProjectUniqueCode.ToString();
this.txtToproject.Text = PMAction.GetNameByCode(equipmentAttemperInfo.ToProjectUniqueCode.ToString()).ToString();
this.txtIntendingTime.Text = equipmentAttemperInfo.IntendingTime.ToString();
this.txtPrice.Text = equipmentAttemperInfo.UnitPrice.ToString();
this.txtStarDate.Text = equipmentAttemperInfo.BeginDate.ToString("yyyy-MM-dd");
this.txtEndDate.Text = equipmentAttemperInfo.EndDate.ToString("yyyy-MM-dd");
this.txtSuite.Text = equipmentAttemperInfo.Suite;
this.txtRemark.Text = equipmentAttemperInfo.Remark;
}
private void GrdAttemper_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemIndex > -1)
{
EquipmentAttemperInfo equipmentAttemperInfo = (EquipmentAttemperInfo)e.Item.DataItem;
this._strKey = this.GrdAttemper.DataKeys[e.Item.ItemIndex].ToString();
try
{
e.Item.Cells[6].Text = EquipmentAttemperAction.QuerySubProject(equipmentAttemperInfo.ToProjectUniqueCode);
}
catch
{
}
e.Item.Attributes["onclick"] = "OnRecord(this);clickRow('" + equipmentAttemperInfo.NoteSequenceID.ToString() + "');";
e.Item.Attributes["onmouseover"] = "OnMouseOverRecord(this);";
e.Item.Attributes["style"] = "cursor:hand";
}
}
