/// <summary>
/// 新增主品牌
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertMasterBrand(C_CarMasterBrandEntity model)
{
string strSql = @"INSERT INTO [dbo].[C_CarMasterBrand]
([MasterBrandName]
,[MasterBrandOtherName]
,[BrandEnName]
,[MasterBrandLogo]
,[AllSpells]
,[CountryID]
,[CreateTime]
,[UpdateTime])
VALUES
(@MasterBrandName
,@MasterBrandOtherName
,@BrandEnName
,@MasterBrandLogo
,@AllSpells
,@CountryID
,@CreateTime
,@UpdateTime)";
var parms = new SqlParameter[]
{
new SqlParameter("@MasterBrandName", model.MasterBrandName),
new SqlParameter("@MasterBrandOtherName", model.MasterBrandOtherName),
new SqlParameter("@BrandEnName", model.BrandEnName),
new SqlParameter("@MasterBrandLogo", model.MasterBrandLogo),
new SqlParameter("@AllSpells", model.AllSpells),
new SqlParameter("@CountryID", model.CountryID),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@UpdateTime", model.UpdateTime),
};
var val = SqlHelper.ExecuteNonQuery(SqlHelper.ConStr, CommandType.Text, strSql, parms);
return(val > 0?true:false);
}
/// <summary>
/// 修改主品牌信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditMasterBrand(C_CarMasterBrandEntity model)
{
string strSql = @"UPDATE [dbo].[C_CarMasterBrand]
SET [MasterBrandName] = @MasterBrandName
,[MasterBrandOtherName] = @MasterBrandOtherName
,[BrandEnName] = @BrandEnName
,[MasterBrandLogo] = @MasterBrandLogo
,[AllSpells] = @AllSpells
,[CountryID] = @CountryID
,[CreateTime] = @CreateTime
,[UpdateTime] = @UpdateTime
WHERE MasterBrandID=@MasterBrandID";
var parms = new SqlParameter[]
{
new SqlParameter("@MasterBrandName", model.MasterBrandName),
new SqlParameter("@MasterBrandOtherName", model.MasterBrandOtherName),
new SqlParameter("@BrandEnName", model.BrandEnName),
new SqlParameter("@MasterBrandLogo", model.MasterBrandLogo),
new SqlParameter("@AllSpells", model.AllSpells),
new SqlParameter("@CountryID", model.CountryID),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@UpdateTime", model.UpdateTime),
new SqlParameter("@MasterBrandID", model.MasterBrandID)
};
var val = SqlHelper.ExecuteNonQuery(SqlHelper.ConStr, CommandType.Text, strSql, parms);
return(val > 0?true:false);
}
/// <summary>
/// 编辑主品牌信息
/// </summary>
/// <returns></returns>
public JsonResult EditMasterBrand()
{
int mId = 0;
if (!int.TryParse(Request["MasterBrandID"], out mId))
{
mId = 0;
}
var model = new C_CarMasterBrandEntity();
model.MasterBrandName = Request["MasterBrandName"];
model.MasterBrandOtherName = Request["MasterBrandOtherName"];
model.BrandEnName = Request["BrandEnName"];
model.MasterBrandLogo = Request["MasterBrandLogo"];
model.AllSpells = Request["AllSpells"];
model.CountryID = Convert.ToInt32(Request["CountryID"]);
model.CreateTime = Convert.ToDateTime(Request["CreateTime"]);
model.UpdateTime = Convert.ToDateTime(Request["UpdateTime"]);
if (mId == 0)
{
return(Json(_objMasterBrand.InsertMasterBrand(model), JsonRequestBehavior.AllowGet));
}
model.MasterBrandID = mId;
return(Json(_objMasterBrand.EditMasterBrand(model), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改主品牌信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditMasterBrand(C_CarMasterBrandEntity model)
{
return(_dalMasterBrand.EditMasterBrand(model));
}
/// <summary>
/// 新增主品牌
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertMasterBrand(C_CarMasterBrandEntity model)
{
return(_dalMasterBrand.InsertMasterBrand(model));
}
