/// <summary>
/// 插入一条明细记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(clsDistrict model, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
sb.Append("INSERT INTO tDistrict(SysCode,StdCode,Name,ShortCut,DistrictIndex,CheckLevel,IsLocal,IsReadOnly,IsLock,Remark)");
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.DistrictIndex);
sb.AppendFormat("'{0}',", model.CheckLevel);
sb.AppendFormat("{0},", model.IsLocal);
sb.AppendFormat("{0},", model.IsReadOnly);
sb.AppendFormat("{0},", model.IsLock);
sb.AppendFormat("'{0}'", model.Remark);
sb.Append(")");
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
//Log.WriteLog("添加clsDistrict",e);
errMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 部分修改保存
/// </summary>
/// <param name="model">对象clsDistrict的一个实例参数</param>
/// <returns></returns>
public int UpdatePart(clsDistrict model, int lev, out string errMsg)
{
errMsg = string.Empty;
int rtn = 0;
try
{
sb.Length = 0;
sb.Append("UPDATE tDistrict SET ");
sb.Append(" StdCode='");
sb.Append(model.StdCode);
sb.Append("'");
sb.Append(",Name='");
sb.Append(model.Name);
sb.Append("'");
sb.Append(",ShortCut='");
sb.Append(model.ShortCut);
sb.Append("'");
sb.Append(",DistrictIndex=");
sb.Append(model.DistrictIndex);
sb.Append(",CheckLevel='");
sb.Append(model.CheckLevel);
sb.Append("'");
sb.Append(",IsLocal=");
sb.Append(model.IsLocal);
sb.Append(",IsReadOnly=");
sb.Append(model.IsReadOnly);
sb.Append(",IsLock=");
sb.Append(model.IsLock);
sb.Append(",Remark='");
sb.Append(model.Remark);
sb.Append("' WHERE SysCode='");
sb.Append(model.SysCode);
sb.Append("'");
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
//string updateSql="update tDistrict set "
//+ "StdCode='" + model.StdCode + "',"
//+ "Name='" + model.Name + "',"
//+ "ShortCut='" + model.ShortCut + "',"
//+ "DistrictIndex=" + model.DistrictIndex + ","
//+ "CheckLevel='" + model.CheckLevel + "',"
//+ "IsLocal=" + model.IsLocal + ","
//+ "IsReadOnly=" + model.IsReadOnly + ","
//+ "IsLock=" + model.IsLock + ","
//+ "Remark='" + model.Remark + "'"
//+ " where SysCode='" + model.SysCode + "' ";
//DataBase.ExecuteCommand(updateSql,out sErrMsg);
if (model.IsLocal)
{
sb.Append("UPDATE tDistrict SET ");
sb.Append(" IsLocal=");
sb.Append(model.IsLocal);
sb.Append(" WHERE SysCode LIKE '");
sb.Append(model.SysCode);
sb.Append("%'");
DataBase.ExecuteCommand(sb.ToString(), out errMsg);
sb.Length = 0;
//string sql="update tDistrict set "
// + "IsLocal=" + model.IsLocal
// + " where SysCode like '" + model.SysCode + "%'";
//DataBase.ExecuteCommand(sql,out sErrMsg);
}
rtn = 1;
}
catch (Exception e)
{
//Log.WriteLog("更新clsDistrict",e);
errMsg = e.Message;
}
return(rtn);
}