public static int UpdateRativeSource(RativeSource Rsource, string id, ref string a_strErr) { int intInsert = 0; SQLTrans sqlTrans = new SQLTrans(); sqlTrans.Open("SupplyCnn"); string strInsert = "update tk_RativeSource set RID = '" + Rsource.StrRID + "',EquipID = '" + Rsource.StrEquipID + "',ProModel = '" + Rsource.StrProModel + "'," + "Source = '" + Rsource.StrSource + "',Manufacturer = '" + Rsource.StrManufacturer + "',Nominal = '" + Rsource.StrNominal + "',SourceNumber = '" + Rsource.StrSourceNumber + "' where ID = '" + id + "'"; try { if (strInsert != "") { intInsert = sqlTrans.ExecuteNonQuery(strInsert, CommandType.Text, null); } sqlTrans.Close(true); } catch (SqlException e) { sqlTrans.Close(false); a_strErr = e.Message; return(-1); } return(intInsert); }
public static int InsertRativeSource(RativeSource Rsource, ref string a_strErr) { int intInsert = 0; SQLTrans sqlTrans = new SQLTrans(); sqlTrans.Open("SupplyCnn"); string strInsert = GSqlSentence.GetInsertInfoByD <RativeSource>(Rsource, "tk_RativeSource"); try { if (strInsert != "") { intInsert = sqlTrans.ExecuteNonQuery(strInsert, CommandType.Text, null); } sqlTrans.Close(true); } catch (SqlException e) { sqlTrans.Close(false); a_strErr = e.Message; return(-1); } return(intInsert); }
public static bool UpdateNewRativeSource(RativeSource Rsource, string id, ref string a_strErr) { if (EquipPro.UpdateRativeSource(Rsource, id, ref a_strErr) >= 1) { return(true); } else { return(false); } }
public static bool InsertNewRativeSource(RativeSource Rsource, ref string a_strErr) { if (EquipPro.InsertRativeSource(Rsource, ref a_strErr) >= 1) { return(true); } else { return(false); } }
public static RativeSource getUpdateRative(string id) { RativeSource Rsource = new RativeSource(); string strSql = "select * from tk_RativeSource where ID = '" + id + "'"; DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn"); if (dt.Rows.Count > 0) { Rsource.StrRID = dt.Rows[0]["RID"].ToString(); Rsource.StrEquipID = dt.Rows[0]["EquipID"].ToString(); Rsource.StrProModel = dt.Rows[0]["ProModel"].ToString(); Rsource.StrSource = dt.Rows[0]["Source"].ToString(); Rsource.StrManufacturer = dt.Rows[0]["Manufacturer"].ToString(); Rsource.StrNominal = dt.Rows[0]["Nominal"].ToString(); Rsource.StrSourceNumber = dt.Rows[0]["SourceNumber"].ToString(); } return(Rsource); }