public int APUpdateUndoSmtloading(string panel, OleExec DB)
{
string strSql = $@"update mes4.r_tr_product_detail set wo = '#' || substr(wo,2,11), p_sn = '#' || p_sn, tr_code = '#' || tr_code where p_sn in (select p_sn from mes4.r_sn_link where panel_no =:panel_no )";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":panel_no", panel) };
int i = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
strSql = $@"update mes4.r_sn_link set p_sn = '#' || p_sn, wo = '#' || substr(wo,2,11), panel_no = '#' || panel_no where panel_no =:panel_no ";
paramet = new OleDbParameter[] { new OleDbParameter(":panel_no", panel) };
i = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(i);
}
public int Delete(string ID, OleExec DB)
{
try
{
if (!string.IsNullOrEmpty(ID.Trim()))
{
string sql = $@"DELETE FROM C_FACTORY WHERE ID='{ID.Trim()}'";
int result = DB.ExecuteNonQuery(sql, CommandType.Text);
if (result > 0)
{
return(0); //delete success
}
else
{
return(1); // delete fail
}
}
else
{
return(2); //delete fail id is empty
}
}
catch (Exception e)
{
return(3); //exception
throw e;
}
}
public int Add(R_BACKFLUSH_HISTORY NewHis, OleExec sfcdb)
{
Row_R_BACKFLUSH_HISTORY NewHisRow = (Row_R_BACKFLUSH_HISTORY)NewRow();
NewHisRow.WORKORDERNO = NewHis.WORKORDERNO;
NewHisRow.SKUNO = NewHis.SKUNO;
NewHisRow.SAP_STATION = NewHis.SAP_STATION;
NewHisRow.WORKORDER_QTY = NewHis.WORKORDER_QTY;
NewHisRow.BACKFLUSH_QTY = NewHis.BACKFLUSH_QTY;
NewHisRow.SFC_QTY = NewHis.SFC_QTY;
NewHisRow.DIFF_QTY = NewHis.DIFF_QTY;
NewHisRow.SFC_STATION = NewHis.SFC_STATION;
NewHisRow.HAND_QTY = NewHis.HAND_QTY;
NewHisRow.LAST_SFC_QTY = NewHis.LAST_SFC_QTY;
NewHisRow.DIFF_QTY1 = NewHis.DIFF_QTY1;
NewHisRow.DIFF_QTY2 = NewHis.DIFF_QTY2;
NewHisRow.HISTORY_HAND_QTY = NewHis.HISTORY_HAND_QTY;
NewHisRow.MRB_QTY = NewHis.MRB_QTY;
NewHisRow.REC_TYPE = NewHis.REC_TYPE;
NewHisRow.BACK_DATE = NewHis.BACK_DATE;
NewHisRow.RESULT = NewHis.RESULT;
NewHisRow.TIMES = NewHis.TIMES;
NewHisRow.TOSAP = NewHis.TOSAP;
int result = sfcdb.ExecuteNonQuery(NewHisRow.GetInsertString(DBType), CommandType.Text);
return(result);
}
public int Add(R_MRB newMrb, OleExec DB)
{
string strSql = $@"insert into r_mrb( id,sn,workorderno,next_station,skuno,from_storage,to_storage,rework_wo,create_emp,create_time,mrb_flag,sap_flag,edit_emp,edit_time)";
strSql = strSql + $@"values(:id,:sn,:workorderno,:next_station,:skuno,:from_storage,:to_storage,:rework_wo,:create_emp,:create_time,:mrb_flag,:sap_flag,:edit_emp,:edit_time)";
OleDbParameter[] paramet = new OleDbParameter[]
{
new OleDbParameter(":id", newMrb.ID),
new OleDbParameter(":sn", newMrb.SN),
new OleDbParameter(":workorderno", newMrb.WORKORDERNO),
new OleDbParameter(":next_station", newMrb.NEXT_STATION),
new OleDbParameter(":skuno", newMrb.SKUNO),
new OleDbParameter(":from_storage", newMrb.FROM_STORAGE),
new OleDbParameter(":to_storage", newMrb.TO_STORAGE),
new OleDbParameter(":rework_wo", newMrb.REWORK_WO),
new OleDbParameter(":create_emp", newMrb.CREATE_EMP),
new OleDbParameter(":create_time", newMrb.CREATE_TIME),
new OleDbParameter(":mrb_flag", newMrb.MRB_FLAG),
new OleDbParameter(":sap_flag", newMrb.SAP_FLAG),
new OleDbParameter(":edit_emp", newMrb.EDIT_EMP),
new OleDbParameter(":edit_time", newMrb.EDIT_TIME)
};
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int RetrunUpdateKPSNBySnId(string snId, string stationName, string user, OleExec DB)
{
string sql = $@" update r_sn_kp set VALUE ='',edit_time=sysdate,edit_emp='{user}' where r_sn_id='{snId}' and station ='{stationName}'";
int res = DB.ExecuteNonQuery(sql, CommandType.Text, null);
return(res);
}
public int DeleteBySNID(string snID, OleExec sfcdb)
{
string sql = $@" delete r_sn_kp where r_sn_id='{snID}' ";
int res = sfcdb.ExecuteNonQuery(sql, CommandType.Text, null);
return(res);
}
public int DeleteById(string id, OleExec DB)
{
string strSql = $@"delete c_storage_item where id=:id";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", id) };
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int DeleteById(string Id, OleExec DB)
{
string strSql = $@"delete c_action_code where id=:Id";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":Id", Id) };
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int UpDate(string ID, decimal SEQ_NO, string NAME, string VALUE, OleExec DB)
{
string sql = $@" UPDATE C_BU_EX SET NAME='{NAME}' ,VALUE='{VALUE}' WHERE ID='{ID}' AND SEQ_NO={SEQ_NO}";
OleDbParameter[] parameters = null;
int result = DB.ExecuteNonQuery(sql, CommandType.Text, parameters);
return(result);
}
public int DeleteBuExByID_SEQ_NO(string ID, decimal SEQ_NO, OleExec DB)
{
string sql = $@"DELETE FROM C_BU_EX WHERE ID=:ID AND SEQ_NO=:SEQ_NO";
OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("ID", ID), new OleDbParameter("SEQ_NO", SEQ_NO) };
int result = DB.ExecuteNonQuery(sql, CommandType.Text, parameters);
return(result);
}
public int UpdateFINISHEDQTYAddOne(string r_wo, OleExec DB)
{
string strSql = $@"update r_wo_base set finished_qty=case when (finished_qty is null) then 1 else (finished_qty+1) end where workorderno=:wono";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":wono", r_wo) };
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int DeleteByReturn_Route_DetailId(string returnid, OleExec DB)
{
string strSql = $@"delete c_route_detail_return where return_route_detail_id=:return_route_detail_id";
OleDbParameter[] paramet = new OleDbParameter[1];
paramet[0] = new OleDbParameter(":return_route_detail_id", returnid);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int DeleteByDetailId(string detailId, OleExec DB)
{
string strSql = $@"delete c_route_detail_directlink where c_route_detail_id=:c_route_detail_id";
OleDbParameter[] paramet = new OleDbParameter[1];
paramet[0] = new OleDbParameter(":c_route_detail_id", detailId);
int res = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(res);
}
/// <summary>
/// 通過ID刪除
/// </summary>
/// <param name="id"></param>
/// <param name="DB"></param>
/// <returns></returns>
public int DeleteById(string id, OleExec DB)
{
string strSql = $@"delete c_route_detail where id=:id";
OleDbParameter[] paramet = new OleDbParameter[1];
paramet[0] = new OleDbParameter(":id", id);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int deleteById(string id, OleExec DB)
{
string sql = "delete c_line where id=:id";
int result = 0;
OleDbParameter[] paramet = new OleDbParameter[] {
new OleDbParameter(":id", id)
};
result = DB.ExecuteNonQuery(sql, CommandType.Text, paramet);
return(result);
}
public int updateTotalQTYAddOne(string strWo, string user_emp, OleExec DB)
{
string strSql = $@" update r_mrb_gt set total_QTY=case when (total_QTY is null) then 1 else (total_QTY+1) end,EDIT_EMP=:userno,EDIT_TIME=sysdate where workorderno=:wono and SAP_FLAG='0'";
OleDbParameter[] paramet = new OleDbParameter[2];
paramet[0] = new OleDbParameter(":userno", user_emp);
paramet[1] = new OleDbParameter(":wono", strWo);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int Add(C_ROUTE_DETAIL_DIRECTLINK newdirectlink, OleExec DB)
{
string strSql = $@"insert into c_route_detail_directlink(id,c_route_detail_id,directlink_route_detail_id)";
strSql = strSql + $@"values(:id,:c_route_detail_id,:directlink_route_detail_id)";
OleDbParameter[] paramet = new OleDbParameter[3];
paramet[0] = new OleDbParameter(":id", newdirectlink.ID);
paramet[1] = new OleDbParameter(":c_route_detail_id", newdirectlink.C_ROUTE_DETAIL_ID);
paramet[2] = new OleDbParameter(":directlink_route_detail_id", newdirectlink.DIRECTLINK_ROUTE_DETAIL_ID);
int res = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(res);
}
public int Add(C_ROUTE_DETAIL_RETURN newdetailreturn, OleExec DB)
{
string strSql = $@"insert into c_route_detail_return(id,route_detail_id,return_route_detail_id)";
strSql = strSql + $@" values(:id,:route_detail_id,:return_route_detail_id)";
OleDbParameter[] paramet = new OleDbParameter[3];
paramet[0] = new OleDbParameter(":id", newdetailreturn.ID);
paramet[1] = new OleDbParameter(":route_detail_id", newdetailreturn.ROUTE_DETAIL_ID);
paramet[2] = new OleDbParameter(":return_route_detail_id", newdetailreturn.RETURN_ROUTE_DETAIL_ID);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int OutMrbUpdate(string reworkno, string userEmp, string snno, OleExec DB)
{
string strSql = $@"update r_mrb set rework_wo=:rework_wo,mrb_flag='1',edit_emp=:edit_emp,edit_time=sysdate where sn=:sn and mrb_flag='0' and rework_wo is null";
OleDbParameter[] paramet = new OleDbParameter[]
{
new OleDbParameter(":rework_wo", reworkno),
new OleDbParameter(":edit_emp", userEmp),
new OleDbParameter(":sn", snno)
};
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
/// <summary>
/// 通過ID更新
/// </summary>
/// <param name="updateitem"></param>
/// <param name="DB"></param>
/// <returns></returns>
public int UpdateById(C_ROUTE_DETAIL updateitem, OleExec DB)
{
string strSql = $@"update c_route_detail set seq_no=:seq_no,station_name=:station_name,station_type=:station_type,return_flag=:return_flag where id=:id";
OleDbParameter[] paramet = new OleDbParameter[5];
paramet[0] = new OleDbParameter(":seq_no", updateitem.SEQ_NO);
paramet[1] = new OleDbParameter(":station_name", updateitem.STATION_NAME);
paramet[2] = new OleDbParameter(":station_type", updateitem.STATION_TYPE);
paramet[3] = new OleDbParameter(":return_flag", updateitem.RETURN_FLAG);
paramet[4] = new OleDbParameter(":id", updateitem.ID);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int UpdateById(C_ACTION_CODE NewActionCode, OleExec DB)
{
Row_C_ACTION_CODE NewActionCodeRow = (Row_C_ACTION_CODE)NewRow();
NewActionCodeRow.ID = NewActionCode.ID;
NewActionCodeRow.ACTION_CODE = NewActionCode.ACTION_CODE;
NewActionCodeRow.ENGLISH_DESCRIPTION = NewActionCode.ENGLISH_DESCRIPTION;
NewActionCodeRow.CHINESE_DESCRIPTION = NewActionCode.CHINESE_DESCRIPTION;
NewActionCodeRow.EDIT_EMP = NewActionCode.EDIT_EMP;
NewActionCodeRow.EDIT_TIME = NewActionCode.EDIT_TIME;
int result = DB.ExecuteNonQuery(NewActionCodeRow.GetUpdateString(DBType, NewActionCode.ID), CommandType.Text);
return(result);
}
public int Add(C_STORAGE_ITEM NewStorageItem, OleExec DB)
{
Row_C_STORAGE_ITEM NewStorageItemRow = (Row_C_STORAGE_ITEM)NewRow();
NewStorageItemRow.ID = NewStorageItem.ID;
NewStorageItemRow.ITEM_NAME = NewStorageItem.ITEM_NAME;
NewStorageItemRow.ITEM_SON = NewStorageItem.ITEM_SON;
NewStorageItemRow.STORAGE_CODE = NewStorageItem.STORAGE_CODE;
NewStorageItemRow.EDIT_EMP = NewStorageItem.EDIT_EMP;
NewStorageItemRow.EDIT_TIME = NewStorageItem.EDIT_TIME;
int result = DB.ExecuteNonQuery(NewStorageItemRow.GetInsertString(DBType), CommandType.Text);
return(result);
}
public int UpdateById(C_STORAGE_CODE NewStorageCode, OleExec DB)
{
Row_C_STORAGE_CODE NewStorageRow = (Row_C_STORAGE_CODE)NewRow();
NewStorageRow.ID = NewStorageCode.ID;
NewStorageRow.PLANT = NewStorageCode.PLANT;
NewStorageRow.STORAGE_CODE = NewStorageCode.STORAGE_CODE;
NewStorageRow.DESCRIPTION = NewStorageCode.DESCRIPTION;
NewStorageRow.EDIT_EMP = NewStorageCode.EDIT_EMP;
NewStorageRow.EDIT_TIME = NewStorageCode.EDIT_TIME;
int result = DB.ExecuteNonQuery(NewStorageRow.GetUpdateString(DBType, NewStorageCode.ID), CommandType.Text);
return(result);
}
public int AddNewErrorCode(C_ERROR_CODE NewErrorCode, OleExec DB)
{
Row_C_ERROR_CODE NewErrorCodeRow = (Row_C_ERROR_CODE)NewRow();
NewErrorCodeRow.ID = NewErrorCode.ID;
NewErrorCodeRow.ERROR_CODE = NewErrorCode.ERROR_CODE;
NewErrorCodeRow.ENGLISH_DESCRIPTION = NewErrorCode.ENGLISH_DESCRIPTION;
NewErrorCodeRow.CHINESE_DESCRIPTION = NewErrorCode.CHINESE_DESCRIPTION;
NewErrorCodeRow.EDIT_EMP = NewErrorCode.EDIT_EMP;
NewErrorCodeRow.EDIT_TIME = NewErrorCode.EDIT_TIME;
int result = DB.ExecuteNonQuery(NewErrorCodeRow.GetInsertString(DBType), CommandType.Text);
return(result);
}
public void DeleteById(JObject requestValue, JToken Data, MESStationReturn StationReturn)
{
string id = Data["ID"].ToString();
if (string.IsNullOrEmpty(id))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara = new List <Object>()
{
"Reason Code ID"
};
StationReturn.Data = null;
return;
}
OleExec sfcdb = DBPools["SFCDB"].Borrow();
string[] ids = id.Split(',');
Row_C_REASON_CODE row_reason_code = (Row_C_REASON_CODE) new T_C_REASON_CODE(sfcdb, DB_TYPE_ENUM.Oracle).NewRow();
try
{
string deleteString = null;
sfcdb.BeginTrain();
foreach (string deleteID in ids)
{
deleteString = row_reason_code.GetDeleteString(DB_TYPE_ENUM.Oracle, deleteID);
sfcdb.ExecuteNonQuery(deleteString, CommandType.Text, null);
}
sfcdb.CommitTrain();
}
catch (Exception ex)
{
sfcdb.RollbackTrain();
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw ex;
}
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000004";
StationReturn.Data = "";
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
/// <summary>
/// 通過ID更新路由
/// </summary>
/// <param name="newRoute"></param>
/// <param name="DB"></param>
/// <returns>成功返回大於零的數，失敗返回0</returns>
public int UpdateById(C_ROUTE newRoute, OleExec DB)
{
string strSql = $@"update c_route set route_name=:route_name ,default_skuno=:default_skuno ,route_type=:route_type ,edit_time=:edit_time ,edit_emp=:edit_emp where id=:id";
OleDbParameter[] paramet = new OleDbParameter[6];
paramet[0] = new OleDbParameter(":route_name", newRoute.ROUTE_NAME);
paramet[1] = new OleDbParameter(":default_skuno", newRoute.DEFAULT_SKUNO);
paramet[2] = new OleDbParameter(":route_type", newRoute.ROUTE_TYPE);
paramet[3] = new OleDbParameter(":edit_time", newRoute.EDIT_TIME);
paramet[4] = new OleDbParameter(":edit_emp", newRoute.EDIT_EMP);
paramet[5] = new OleDbParameter(":id", newRoute.ID);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
public int Insert(string FACTORY_CODE, string FACTORY_NAME, string FACTORY_ADDRESS, string DESCRIPTION, string EDIT_EMP, string BU, DB_TYPE_ENUM dbt, OleExec DB)
{
OleDbParameter[] param = null;
string sql;
int result;
string ID;
T_C_FACTORY factory = null;
DataTable table;
try
{
sql = $@"SELECT * FROM C_FACTORY WHERE UPPER(FACTORY_CODE)='{FACTORY_CODE}' AND UPPER(FACTORY_NAME)='{FACTORY_NAME}' AND UPPER(FACTORY_ADDRESS)='{FACTORY_ADDRESS}'";
table = DB.ExecSelect(sql).Tables[0];
if (table.Rows.Count > 0)
{ // factorycode+factoryname+factoryaddress existed fail primary key
return(0);
}
factory = new T_C_FACTORY(DB, dbt);
ID = factory.GetNewID(BU, DB, dbt);
param = new OleDbParameter[]
{
new OleDbParameter("ID", ID),
new OleDbParameter("FACTORY_CODE", FACTORY_CODE.ToUpper()),
new OleDbParameter("FACTORY_NAME", FACTORY_NAME.ToUpper()),
new OleDbParameter("FACTORY_ADDRESS", FACTORY_ADDRESS.ToUpper()),
new OleDbParameter("DESCRIPTION", DESCRIPTION),
new OleDbParameter("EDIT_EMP", EDIT_EMP)
};
sql = "INSERT INTO C_FACTORY VALUES(:ID,:FACTORY_CODE,:FACTORY_NAME,:FACTORY_ADDRESS,:DESCRIPTION, SYSDATE,:EDIT_EMP)";
result = DB.ExecuteNonQuery(sql, CommandType.Text, param);
if (result > 0)
{
return(1); //Insert success
}
else
{
return(2); //Insert fail
}
}
catch (Exception e)
{
return(3); //exception
throw e;
}
}
public int Update(string ID, string FACTORY_CODE, string FACTORY_NAME, string FACTORY_ADDRESS, string DESCRIPTION, string EDIT_EMP, OleExec DB)
{
OleDbParameter[] param = null;
int result;
string sql;
DataTable table;
try
{
sql = $@"SELECT * FROM C_FACTORY WHERE ID='{ID}'";
table = DB.ExecSelect(sql).Tables[0]; // check id exist ?
if (table.Rows.Count <= 0)
{
return(0); // id not exist
}
sql = $@"SELECT * FROM C_FACTORY WHERE UPPER(FACTORY_CODE)='{FACTORY_CODE}' AND UPPER(FACTORY_NAME)='{FACTORY_NAME}' AND UPPER(FACTORY_ADDRESS)='{FACTORY_ADDRESS}'";
table = DB.ExecSelect(sql).Tables[0];
if (table.Rows.Count > 0)
{
return(1); // factorycode+factoryname+factoryaddress existed fail primary key
}
sql = $@"UPDATE C_FACTORY SET FACTORY_CODE=:FACTORY_CODE,FACTORY_NAME=:FACTORY_NAME,FACTORY_ADDRESS=:FACTORY_ADDRESS,DESCRIPTION=:DESCRIPTION,EDIT_TIME=SYSDATE,EDIT_EMP=:EDIT_EMP WHERE ID='{ID}'";
param = new OleDbParameter[]
{
new OleDbParameter("FACTORY_CODE", FACTORY_CODE.ToUpper()),
new OleDbParameter("FACTORY_NAME", FACTORY_NAME.ToUpper()),
new OleDbParameter("FACTORY_ADDRESS", FACTORY_ADDRESS.ToUpper()),
new OleDbParameter("DESCRIPTION", DESCRIPTION),
new OleDbParameter("EDIT_EMP", EDIT_EMP)
};
result = DB.ExecuteNonQuery(sql, CommandType.Text, param);
if (result > 0)
{
return(2); //Update success
}
else
{
return(3); //Update fail
}
}
catch (Exception e)
{
return(4); //exception
throw e;
}
}
/// <summary>
/// 添加C_ROUTE_DETAIL
/// </summary>
/// <param name="newc_route_detail"></param>
/// <param name="DB"></param>
/// <returns></returns>
public int Add(C_ROUTE_DETAIL newc_route_detail, OleExec DB)
{
string strSql = $@"insert into c_route_detail(id,seq_no,route_id,station_name,station_type,return_flag)";
strSql = strSql + $@"values(:id,:seq_no,:route_id,:station_name,:station_type,:return_flag)";
OleDbParameter[] paramet = new OleDbParameter[6];
paramet[0] = new OleDbParameter(":id", newc_route_detail.ID);
paramet[1] = new OleDbParameter(":seq_no", newc_route_detail.SEQ_NO);
paramet[2] = new OleDbParameter(":route_id", newc_route_detail.ROUTE_ID);
paramet[3] = new OleDbParameter(":station_name", newc_route_detail.STATION_NAME);
paramet[4] = new OleDbParameter(":station_type", newc_route_detail.STATION_TYPE);
paramet[5] = new OleDbParameter(":return_flag", newc_route_detail.RETURN_FLAG);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
/// <summary>
/// 添加新的路由
/// </summary>
/// <param name="newRoute">新的路由</param>
/// <param name="DB"></param>
/// <returns>成功返回大於零的數，失敗返回0</returns>
public int Add(C_ROUTE newRoute, OleExec DB)
{
string strSql = $@"insert into c_route(id,route_name,default_skuno,route_type,edit_time,edit_emp)";
strSql = strSql + $@"values(:id,:route_name,:default_skuno,:route_type,:edit_time,:edit_emp)";
OleDbParameter[] paramet = new OleDbParameter[6];
paramet[0] = new OleDbParameter(":id", newRoute.ID);
paramet[1] = new OleDbParameter(":route_name", newRoute.ROUTE_NAME);
paramet[2] = new OleDbParameter(":default_skuno", newRoute.DEFAULT_SKUNO);
paramet[3] = new OleDbParameter(":route_type", newRoute.ROUTE_TYPE);
paramet[4] = new OleDbParameter(":edit_time", newRoute.EDIT_TIME);
paramet[5] = new OleDbParameter(":edit_emp", newRoute.EDIT_EMP);
int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);
return(result);
}
