/// <summary>
/// 通过CountryID修改信息
/// </summary>
/// <returns></returns>
public JsonResult EditCountryBycId()
{
var model = new D_CountriesEntity();
model.Name = Request.Params["Name"];
model.Code = Request.Params["Code"];
model.OtherName = Request.Params["OtherName"];
model.LogoUrl = Request.Params["LogoUrl"];
model.Area = Request.Params["Area"];
model.CountryID = Convert.ToInt32(Request.Params["CountryID"]);
if (_objCountries.EditCountryBycId(model))
{
return(Json(true));
}
return(Json(false));
}
public bool EditCountryBycId(D_CountriesEntity model)
{
string strSql = @"
UPDATE [dbo].[D_Countries]
SET [Name] = @cName
,[Code] = @cCode
,[OtherName] = @cOtherName
,[LogoUrl] = @cLogoUrl
,[Area] = @cArea
WHERE CountryID=@CountryID";
var parms = new SqlParameter[]
{
new SqlParameter("@cName", SqlDbType.VarChar)
{
Value = model.Name
}
, new SqlParameter("@cCode", SqlDbType.VarChar)
{
Value = model.Code
}
, new SqlParameter("@cOtherName", SqlDbType.VarChar)
{
Value = model.OtherName
}
, new SqlParameter("@cLogoUrl", SqlDbType.VarChar)
{
Value = model.LogoUrl
}
, new SqlParameter("@cArea", SqlDbType.VarChar)
{
Value = model.Area
}
, new SqlParameter("@CountryID", SqlDbType.Int)
{
Value = model.CountryID
}
};
var val = SqlHelper.ExecuteNonQuery(SqlHelper.ConStr, CommandType.Text, strSql, parms);
return(val > 0?true:false);
}
public bool EditCountryBycId(D_CountriesEntity model)
{
return(_dalCountries.EditCountryBycId(model));
}
