public static bool UpdateNewDCheckInfo(DCheckInfo CheckInfo, string id, string num, ref string a_strErr)
{
if (EquipPro.UpdateDCheckInfo(CheckInfo, id, num, ref a_strErr) >= 1)
{
return(true);
}
else
{
return(false);
}
}
public static bool InsertNewDCheckInfo(DCheckInfo CheckInfo, ref string a_strErr)
{
if (EquipPro.InsertDCheckInfo(CheckInfo, ref a_strErr) >= 2)
{
return(true);
}
else
{
return(false);
}
}
public static DCheckInfo getUpdateDCheckInfo(string id)
{
DCheckInfo Check = new DCheckInfo();
string strSql = "select * from tk_DCheckInfo where ID = '" + id + "'";
DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn");
if (dt.Rows.Count > 0)
{
Check.StrECode = dt.Rows[0]["ECode"].ToString();
Check.StrCheckDate = dt.Rows[0]["CheckDate"].ToString();
Check.StrCheckWay = dt.Rows[0]["CheckWay"].ToString();
Check.StrCheckCompany = dt.Rows[0]["CheckCompany"].ToString();
Check.StrCharge = GFun.SafeToFloat(dt.Rows[0]["Charge"].ToString());
Check.StrPrecision = dt.Rows[0]["Precision"].ToString();
Check.StrCensorshipRemark = dt.Rows[0]["CensorshipRemark"].ToString();
Check.StrPrincipal = dt.Rows[0]["Principal"].ToString();
Check.StrCalibrationResults = dt.Rows[0]["CalibrationResults"].ToString();
}
return(Check);
}
public static int UpdateDCheckInfo(DCheckInfo CheckInfo, string id, string num, ref string a_strErr)
{
int intInsert = 0;
int intUpdate = 0;
SQLTrans sqlTrans = new SQLTrans();
sqlTrans.Open("SupplyCnn");
string strInsert = "update tk_DCheckInfo set CheckDate = '" + CheckInfo.StrCheckDate + "',CheckWay = '" + CheckInfo.StrCheckWay + "',CheckCompany = '" + CheckInfo.StrCheckCompany + "',Charge = '" + CheckInfo.StrCharge + "',"
+ "Precision = '" + CheckInfo.StrPrecision + "',CensorshipRemark = '" + CheckInfo.StrCensorshipRemark + "',Principal = '" + CheckInfo.StrPrincipal + "',CalibrationResults = '" + CheckInfo.StrCalibrationResults + "' where ID = '" + id + "'";
string strUpdate = "";
if (num == "1")
{
DateTime CheckDate = Convert.ToDateTime(CheckInfo.StrCheckDate); DateTime PlanDate = new DateTime();
string strSql = "";
if (CheckInfo.StrCheckWay == "CK1")
{
strSql = "select CalibrationCycleType,CalibrationCycle from tk_DevicsBas where ECode = '" + CheckInfo.StrECode + "'";
DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn");
string CycelType = dt.Rows[0]["CalibrationCycleType"].ToString();
int Cycel = Convert.ToInt16(dt.Rows[0]["CalibrationCycle"]);
if (CycelType == "Cy1")
{
PlanDate = CheckDate.AddYears(Cycel);
}
if (CycelType == "Cy2")
{
PlanDate = CheckDate.AddMonths(Cycel);
}
if (CycelType == "Cy3")
{
PlanDate = CheckDate.AddDays(Cycel);
}
if (CheckInfo.StrPrecision != null)
{
strUpdate = "update tk_DevicsBas set LastCalibrationDate = '" + CheckInfo.StrCheckDate + "',PlanCalibrationDate = '" + PlanDate.ToString("yyyy-MM-dd") + "',Precision = '" + CheckInfo.StrPrecision + "' where ECode = '" + CheckInfo.StrECode + "'";
}
else
{
strUpdate = "update tk_DevicsBas set LastCalibrationDate = '" + CheckInfo.StrCheckDate + "',PlanCalibrationDate = '" + PlanDate.ToString("yyyy-MM-dd") + "' where ECode = '" + CheckInfo.StrECode + "'";
}
}
if (CheckInfo.StrCheckWay == "CK2")
{
strSql = "select CheckCycleType,CheckCycle from tk_DevicsBas where ECode = '" + CheckInfo.StrECode + "'";
DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn");
string CycelType = dt.Rows[0]["CheckCycleType"].ToString();
int Cycel = Convert.ToInt16(dt.Rows[0]["CheckCycle"]);
if (CycelType == "Cy1")
{
PlanDate = CheckDate.AddYears(Cycel);
}
if (CycelType == "Cy2")
{
PlanDate = CheckDate.AddMonths(Cycel);
}
if (CycelType == "Cy3")
{
PlanDate = CheckDate.AddDays(Cycel);
}
if (CheckInfo.StrPrecision != null)
{
strUpdate = "update tk_DevicsBas set LastCheckDate = '" + CheckInfo.StrCheckDate + "',PlanCheckDate = '" + PlanDate.ToString("yyyy-MM-dd") + "',Precision = '" + CheckInfo.StrPrecision + "' where ECode = '" + CheckInfo.StrECode + "'";
}
else
{
strUpdate = "update tk_DevicsBas set LastCheckDate = '" + CheckInfo.StrCheckDate + "',PlanCheckDate = '" + PlanDate.ToString("yyyy-MM-dd") + "' where ECode = '" + CheckInfo.StrECode + "'";
}
}
if (CheckInfo.StrCheckWay == "CK3")
{
strSql = "select TestCycleType,TestCycle from tk_DevicsBas where ECode = '" + CheckInfo.StrECode + "'";
DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn");
string CycelType = dt.Rows[0]["TestCycleType"].ToString();
int Cycel = Convert.ToInt16(dt.Rows[0]["TestCycle"]);
if (CycelType == "Cy1")
{
PlanDate = CheckDate.AddYears(Cycel);
}
if (CycelType == "Cy2")
{
PlanDate = CheckDate.AddMonths(Cycel);
}
if (CycelType == "Cy3")
{
PlanDate = CheckDate.AddDays(Cycel);
}
if (CheckInfo.StrPrecision != null)
{
strUpdate = "update tk_DevicsBas set LastTestDate = '" + CheckInfo.StrCheckDate + "',PlanTestDate = '" + PlanDate.ToString("yyyy-MM-dd") + "',Precision = '" + CheckInfo.StrPrecision + "' where ECode = '" + CheckInfo.StrECode + "'";
}
else
{
strUpdate = "update tk_DevicsBas set LastTestDate = '" + CheckInfo.StrCheckDate + "',PlanTestDate = '" + PlanDate.ToString("yyyy-MM-dd") + "' where ECode = '" + CheckInfo.StrECode + "'";
}
}
}
try
{
if (strInsert != "")
{
intInsert = sqlTrans.ExecuteNonQuery(strInsert, CommandType.Text, null);
}
if (strUpdate != "")
{
intUpdate = sqlTrans.ExecuteNonQuery(strUpdate, CommandType.Text, null);
}
sqlTrans.Close(true);
}
catch (SqlException e)
{
sqlTrans.Close(false);
a_strErr = e.Message;
return(-1);
}
return(intInsert);
}
public static int InsertDCheckInfo(DCheckInfo CheckInfo, ref string a_strErr)
{
int intInsert = 0;
int intUpdate = 0;
SQLTrans sqlTrans = new SQLTrans();
sqlTrans.Open("SupplyCnn");
string strInsert = GSqlSentence.GetInsertInfoByD <DCheckInfo>(CheckInfo, "tk_DCheckInfo");
string strUpdate = "";
DateTime CheckDate = Convert.ToDateTime(CheckInfo.StrCheckDate);
DateTime PlanDate = new DateTime();
string strSql = "";
strSql = "select CycleType,Cycle from tk_DevicsBas where ECode = '" + CheckInfo.StrECode + "'";
DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn");
string CycelType = dt.Rows[0]["CycleType"].ToString();
int Cycel = Convert.ToInt16(dt.Rows[0]["Cycle"]);
if (CycelType == "Cy1")
{
PlanDate = CheckDate.AddYears(Cycel);
}
if (CycelType == "Cy2")
{
PlanDate = CheckDate.AddMonths(Cycel);
}
if (CycelType == "Cy3")
{
PlanDate = CheckDate.AddDays(Cycel);
}
if (CheckInfo.StrPrecision != null)
{
strUpdate = "update tk_DevicsBas set LastDate = '" + CheckInfo.StrCheckDate + "',PlanDate = '" + PlanDate.ToString("yyyy-MM-dd") + "',Precision = '" + CheckInfo.StrPrecision + "' where ECode = '" + CheckInfo.StrECode + "'";
}
else
{
strUpdate = "update tk_DevicsBas set LastDate = '" + CheckInfo.StrCheckDate + "',PlanDate = '" + PlanDate.ToString("yyyy-MM-dd") + "' where ECode = '" + CheckInfo.StrECode + "'";
}
try
{
if (strInsert != "")
{
intInsert = sqlTrans.ExecuteNonQuery(strInsert, CommandType.Text, null);
}
if (strUpdate != "")
{
intUpdate = sqlTrans.ExecuteNonQuery(strUpdate, CommandType.Text, null);
}
sqlTrans.Close(true);
}
catch (SqlException e)
{
sqlTrans.Close(false);
a_strErr = e.Message;
return(-1);
}
return(intInsert + intUpdate);
}
