/// <summary>
/// 部分修改保存
/// </summary>
/// <param name="model">对象clsCheckItem的一个实例参数</param>
/// <returns></returns>
public int UpdatePart(clsCheckItem model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
sb.Length = 0;
try
{
sb.Append("UPDATE TCHECKITEM SET ");
sb.AppendFormat("StdCode='{0}',", model.StdCode);
sb.AppendFormat("ItemDes='{0}',", model.ItemDes);
sb.AppendFormat("CheckType='{0}',", model.CheckType);
sb.AppendFormat("StandardCode='{0}',", model.StandardCode);
sb.AppendFormat("StandardValue='{0}',", model.StandardValue);
sb.AppendFormat("Unit='{0}',", model.Unit);
sb.AppendFormat("DemarcateInfo='{0}',", model.DemarcateInfo);
sb.AppendFormat("TestValue='{0}',", model.TestValue);
sb.AppendFormat("OperateHelp='{0}',", model.OperateHelp);
sb.AppendFormat("CheckLevel='{0}',", model.CheckLevel);
sb.AppendFormat("IsReadOnly={0},", model.IsReadOnly);
sb.AppendFormat("IsLock={0},", model.IsLock);
sb.AppendFormat("Remark='{0}'", model.Remark);
sb.AppendFormat(" WHERE SysCode='{0}',", model.SysCode);
//+ "StdCode='" + model.StdCode + "',"
//+ "ItemDes='" + model.ItemDes + "',"
//+ "CheckType='" + model.CheckType + "',"
//+ "StandardCode='" + model.StandardCode + "',"
//+ "StandardValue='" + model.StandardValue + "',"
//+ "Unit='" + model.Unit + "',"
//+ "DemarcateInfo='" + model.DemarcateInfo + "',"
//+ "TestValue='" + model.TestValue + "',"
//+ "OperateHelp='" + model.OperateHelp + "',"
//+ "CheckLevel='" + model.CheckLevel + "',"
//+ "IsReadOnly=" + model.IsReadOnly + ","
//+ "IsLock=" + model.IsLock + ","
//+ "Remark='" + model.Remark + "'"
//+ " where SysCode='" + model.SysCode + "' ";
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
//Log.WriteLog("更新clsCheckItem",e);
errMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 插入一条明细记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(clsCheckItem model, out string sErrMsg)
{
sErrMsg = string.Empty;
int rtn = 0;
sb.Length = 0;
try
{
sb.Append("INSERT INTO tCheckItem");
sb.Append("(SysCode,StdCode,ItemDes,CheckType,StandardCode,StandardValue,Unit,");
sb.Append("DemarcateInfo,TestValue,OperateHelp,CheckLevel,IsReadOnly,IsLock,Remark)");
sb.Append(" VALUES(");
sb.AppendFormat("'{0}',", model.SysCode);
sb.AppendFormat("'{0}',", model.StdCode);
sb.AppendFormat("'{0}',", model.ItemDes);
sb.AppendFormat("'{0}',", model.CheckType);
sb.AppendFormat("'{0}',", model.StandardCode);
sb.AppendFormat("'{0}',", model.StandardValue);
sb.AppendFormat("'{0}',", model.Unit);
sb.AppendFormat("'{0}',", model.DemarcateInfo);
sb.AppendFormat("'{0}',", model.TestValue);
sb.AppendFormat("'{0}',", model.OperateHelp);
sb.AppendFormat("'{0}',", model.CheckLevel);
sb.AppendFormat("{0},", model.IsReadOnly);
sb.AppendFormat("{0},", model.IsLock);
sb.AppendFormat("'{0}'", model.Remark);
sb.Append(")");
DataBase.ExecuteCommand(sb.ToString(), out sErrMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
//Log.WriteLog("添加clsCheckItem",e);
sErrMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 下载|更新 检测项目
/// </summary>
/// <param name="model">clsCheckItem</param>
/// <param name="errMsg"></param>
/// <returns></returns>
public int InsertOrUpdate(clsCheckItem model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
DataTable dt = this.GetAsDataTable("SysCode Like '" + model.SysCode + "'", string.Empty, 8);
if (dt != null && dt.Rows.Count > 0)
{
sb.Length = 0;
sb.AppendFormat("Update tCheckItem Set StdCode='{0}',ItemDes='{1}',CheckType='{2}',StandardCode='{3}',StandardValue='{4}',",
model.StdCode, model.ItemDes, model.CheckType, model.StandardCode, model.StandardValue);
sb.AppendFormat("Unit='{0}',DemarcateInfo='{1}',TestValue='{2}',OperateHelp='{3}',CheckLevel='{4}',",
model.Unit, model.DemarcateInfo, model.TestValue, model.OperateHelp, model.CheckLevel);
sb.AppendFormat("IsReadOnly={0},IsLock={1},Remark='{2}',UDate='{3}' Where SysCode='{4}'",
model.IsReadOnly, model.IsLock, model.Remark, model.UDate, model.SysCode);
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
}
else
{
sb.Length = 0;
sb.Append("Insert Into tCheckItem");
sb.Append(" (SysCode,StdCode,ItemDes,CheckType,StandardCode,StandardValue,Unit,DemarcateInfo,TestValue,OperateHelp,CheckLevel,IsLock,IsReadOnly,Remark,UDate) Values(");
sb.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", model.SysCode, model.StdCode, model.ItemDes, model.CheckType, model.StandardCode);
sb.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", model.StandardValue, model.Unit, model.DemarcateInfo, model.TestValue, model.OperateHelp);
sb.AppendFormat("'{0}',{1},{2},'{3}','{4}'", model.CheckLevel, model.IsLock, model.IsReadOnly, model.Remark, model.UDate);
sb.Append(")");
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
}
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
errMsg = e.Message;
}
return(rtn);
}