1.数据区
public static int updateDetailById(BackupDetail model)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + Setting.OWMER + "BACKUPDETAIL set WORKHUB=:workHub,JOBNUMBER=:jobNumber,BACKUPDESCRIPTION=:backupDescription,ORDERNO=:orderNo,FINISHTIME=:finishTime,ISWAIT=:isWait,MAERIALDESCRIPTION=:MaerialDescription,BUYTYPE=:buyType,CURRMARCH=:CurrMarch,DUTYMAN=:dutyMan,BUYPERSON=:buyPerson,BACKUPMAN=:backupMan,REMARK=:reMark where BACKUPID=:backupId");
OracleParameter[] par = {
new OracleParameter("workHub",model.WORKHUB ),
new OracleParameter("jobNumber",model.JOBNUMBER),
new OracleParameter("backupDescription",model.BACKUPDESCRIPTION),
new OracleParameter("isWait",model.ISWAIT),
new OracleParameter("MaerialDescription",model.MAERIALDESCRIPTION),
new OracleParameter("buyType",model.BUYTYPE),
new OracleParameter("CurrMarch",model.CURRMARCH),
new OracleParameter("dutyMan",model.DUTYMAN),
new OracleParameter("buyPerson",model.BUYPERSON),
new OracleParameter("backupMan",model.BACKUPMAN),
new OracleParameter("finishTime",model.FINISHTIME),
new OracleParameter("orderNo",model.ORDERNO),
new OracleParameter("reMark",model.REMARK),
new OracleParameter("backupId",model.BACKUPID)
};
try
{
return DbHelper.ExecuteNonQuery(sb.ToString(), par);
}
catch
{
throw;
}
}
2.修改后台区
3.页面部分修改区
runat="server">
runat="server">
runat="server">
runat="server">
runat="server">
runat="server">
runat="server">
Text='' runat="server">
runat="server">
runat="server">
runat="server">
runat="server">
CommandName="Update" Text="更新">
CommandName="Cancel" Text="取消">