/// <summary>
/// 获取实体对象
/// </summary>
/// <param name="PKID">PKID</param>
/// <returns>返回值</returns>
public Common.Entity.CarColor GetCarColorByPKID(int PKID)
{
string sql = string.Format(@"select * from CarColor where PKID=@PKID");
SqlParameter[] param =
{
new SqlParameter("@PKID", PKID)
};
try
{
Common.Entity.CarColor model = new Common.Entity.CarColor();
DataTable dt = SqlHelper.GetDateTable(SqlHelper.connStr, CommandType.Text, sql, param);
if (dt.Rows.Count > 0)
{
model.PKID = Convert.ToInt32(dt.Rows[0]["PKID"]);
model.Name = dt.Rows[0]["Name"].ToString();
model.Code = dt.Rows[0]["Code"].ToString();
model.CarID = Convert.ToInt32(dt.Rows[0]["CarID"].ToString());
model.Remark = dt.Rows[0]["Remark"].ToString();
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回值</returns>
public bool EastAdd(Common.Entity.CarColor model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert into CarColor(CarID,Code,Name,Remark)
Values (@CarID,@Code,@Name,@Remark)");
strSql.Append(";SELECT @@IDENTITY");// 返回插入用户的主键
SqlParameter[] param =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Code", model.Code),
new SqlParameter("@CarID", model.CarID),
new SqlParameter("@Remark", model.Remark),
};
try
{
int result = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void EastSaveData(HttpContext context)
{
int carId = Convert.ToInt32(context.Request["hidCarId"]);
int HidCarColorId = Convert.ToInt32(context.Request["HidCarColorId"]);
string name = context.Request["colorName"];
string code = context.Request["colorCode"];
BLL.CarInfo bll = new BLL.CarInfo();
Common.Entity.CarColor model = new Common.Entity.CarColor();
if (carId > 0)
{
if (HidCarColorId > 0)
{
model.PKID = HidCarColorId;
model.Code = code;
model.Name = name;
model.CarID = carId;
int result = bll.EastUpdate(model);
if (result > 0)
{
context.Response.Write("{\"msg\":\"保存成功。\",\"success\":true}");
}
else
{
context.Response.Write("{\"msg\":\"保存失败。\",\"success\":false}");
}
}
else
{
model.CarID = carId;
model.Code = code;
model.Name = name;
if (bll.EastExists(carId, code))
{
context.Response.Write("{\"state\":1, \"msg\":\"" + code + "\"}");
}
else if (bll.EastAdd(model))
{
context.Response.Write("{\"msg\":\"保存成功。\",\"success\":true}");
}
else
{
context.Response.Write("{\"msg\":\"保存失败。\",\"success\":false}");
}
}
}
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回值</returns>
public int EastUpdate(Common.Entity.CarColor model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Update CarColor set Name=@Name,Code=@Code,Remark=@Remark where PKID=@PKID");
SqlParameter[] param =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Code", model.Code),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@PKID", model.PKID)
};
try
{
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param)));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回值</returns>
public int EastUpdate(Common.Entity.CarColor model)
{
return(new DAL.CarInfo().EastUpdate(model));
}
/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回值</returns>
public bool EastAdd(Common.Entity.CarColor model)
{
return(new DAL.CarInfo().EastAdd(model));
}
