/// <summary>
/// 部分修改保存
/// </summary>
/// <param name="model">对象clsFoodClass的一个实例参数</param>
/// <returns></returns>
public int UpdatePart(clsFoodClass model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
sb.AppendFormat("UPDATE tFoodClass SET StdCode='{0}'", model.StdCode);
sb.AppendFormat(",Name='{0}'", model.Name);
sb.AppendFormat(",ShortCut='{0}'", model.ShortCut);
sb.AppendFormat(",CheckLevel='{0}'", model.CheckLevel);
sb.AppendFormat(",CheckItemCodes='{0}'", model.CheckItemCodes);
sb.AppendFormat(",CheckItemValue='{0}'", model.CheckItemValue);
sb.Append(",IsReadOnly=");
sb.Append(model.IsReadOnly);
sb.Append(",IsLock=");
sb.Append(model.IsLock);
sb.AppendFormat(",Remark='{0}'", model.Remark);
sb.AppendFormat(",FoodProperty='{0}'", model.FoodProperty);
sb.AppendFormat(" WHERE SysCode='{0}'", model.SysCode);
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
//Log.WriteLog("更新clsFoodClass",e);
errMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 插入一条明细记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(clsFoodClass model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
sb.Append("INSERT INTO TFOODCLASS");
sb.Append("(SysCode,StdCode,Name,ShortCut,CheckLevel,CheckItemCodes");
sb.Append(",CheckItemValue,IsReadOnly,IsLock,Remark,FoodProperty)");
sb.Append("VALUES(");
sb.AppendFormat("'{0}',", model.SysCode);
sb.AppendFormat("'{0}',", model.StdCode);
sb.AppendFormat("'{0}',", model.Name);
sb.AppendFormat("'{0}',", model.ShortCut);
sb.AppendFormat("'{0}',", model.CheckLevel);
sb.AppendFormat("'{0}',", model.CheckItemCodes);
sb.AppendFormat("'{0}',", model.CheckItemValue);
sb.AppendFormat("{0},", model.IsReadOnly);
sb.AppendFormat("{0},", model.IsLock);
sb.AppendFormat("'{0}',", model.Remark);
sb.AppendFormat("'{0}'", model.FoodProperty);
sb.Append(")");
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
//Log.WriteLog("添加clsFoodClass",e);
errMsg = e.Message;
}
return(rtn);
}