public static int InsertDeviceBas(DevicsBas Bas, ref string a_strErr)
{
int intInsert = 0;
SQLTrans sqlTrans = new SQLTrans();
sqlTrans.Open("SupplyCnn");
string strInsert = GSqlSentence.GetInsertInfoByD <DevicsBas>(Bas, "tk_DevicsBas");
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 UpdateDeviceBas(DevicsBas Bas, string ecode, ref string a_strErr)
{
int intInsert = 0;
SQLTrans sqlTrans = new SQLTrans();
sqlTrans.Open("SupplyCnn");
string strInsert = "update tk_DevicsBas set ControlCode = '" + Bas.StrControlCode + "',Ename = '" + Bas.StrEname + "',Manufacturer = '" + Bas.StrManufacturer + "',"
+ "FactoryNumber = '" + Bas.StrFactoryNumber + "',Specification = '" + Bas.StrSpecification + "',DevicsType = '" + Bas.StrDevicsType + "',"
+ "FactoryDate = '" + Bas.StrFactoryDate + "',TracingType = '" + Bas.StrTracingType + "',Precision = '" + Bas.StrPrecision + "',"
+ "Clrange = '" + Bas.StrClrange + "',CycleType = '" + Bas.StrCycleType + "',Cycle = '" + Bas.StrCycle + "',"
+ "CheckCompany = '" + Bas.StrCheckCompany + "',Remark = '" + Bas.StrRemark + "'"
+ " where ECode = '" + ecode + "'";
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 DevicsBas getDevicsByID(string id)
{
DevicsBas Bas = new DevicsBas();
string str = "select * from tk_DevicsBas where ECode = '" + id + "'";
DataTable dt = SQLBase.FillTable(str, "SupplyCnn");
if (dt.Rows.Count > 0)
{
Bas.StrControlCode = dt.Rows[0]["ControlCode"].ToString();
Bas.StrEname = dt.Rows[0]["Ename"].ToString();
Bas.StrManufacturer = dt.Rows[0]["Manufacturer"].ToString();
Bas.StrFactoryNumber = dt.Rows[0]["FactoryNumber"].ToString();
Bas.StrSpecification = dt.Rows[0]["Specification"].ToString();
Bas.StrDevicsType = dt.Rows[0]["DevicsType"].ToString();
if (dt.Rows[0]["FactoryDate"].ToString() != "")
{
Bas.StrFactoryDate = Convert.ToDateTime(dt.Rows[0]["FactoryDate"]).ToString("yyyy-MM-dd");
}
Bas.StrPrecision = dt.Rows[0]["Precision"].ToString();
Bas.StrTracingType = dt.Rows[0]["TracingType"].ToString();
Bas.StrClrange = dt.Rows[0]["Clrange"].ToString();
Bas.StrCycleType = dt.Rows[0]["CycleType"].ToString();
Bas.StrCycle = dt.Rows[0]["Cycle"].ToString();
Bas.StrCheckCompany = dt.Rows[0]["CheckCompany"].ToString();
Bas.StrRemark = dt.Rows[0]["Remark"].ToString();
}
return(Bas);
}
public static bool InsertNewDeviceBas(DevicsBas Bas, ref string a_strErr)
{
if (EquipPro.InsertDeviceBas(Bas, ref a_strErr) >= 1)
{
return(true);
}
else
{
return(false);
}
}
public static bool UpdateNewDevice(DevicsBas Bas, string ecode, ref string a_strErr)
{
if (EquipPro.UpdateDeviceBas(Bas, ecode, ref a_strErr) >= 1)
{
return(true);
}
else
{
return(false);
}
}
