public JsonResult SetEtcUpdate(Int64? Seq, string ServerName, string EquipTypeCode,
String IdcCode, String RackCode, int RackStartLocationValue, string VenderCode, string Content)
{
ResultModel returnModel = new ResultModel();
AssetEtcInfoT model = new AssetEtcInfoT();
model.Seq = (Seq == null) ? 0 : Seq.Value;
model.ServerName = ServerName;
model.EquipTypeCode = EquipTypeCode;
model.IdcCode = IdcCode;
model.RackCode = RackCode;
model.RackStartLocationValue = RackStartLocationValue;
model.VenderCode = VenderCode;
model.Content = Content;
int nResult = new AssetBiz().UpdateEtcInfo(model);
returnModel.statusCode = nResult > 0 ? StatusCodeEnum.Success : StatusCodeEnum.Fail;
return Json(returnModel);
}
/// <summary>
/// Asset 서버 정보 추가 및 업데이트
/// 2013-11-28 최혁남
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateEtcInfo(AssetEtcInfoT model)
{
var SEQ = new DacHelper(DbHelper, "intradb_write").SelectScalar(
CommandType.StoredProcedure,
"dbo.UPAR_ASSETDB_Asset_UpdateAssetEtcInfo",
SqlParameterHelper.CreateParameter("@SEQ", model.Seq == null ? 0 : model.Seq.Value, SqlDbType.BigInt),
SqlParameterHelper.CreateParameter("@EQUIP_TYPE_CODE", model.EquipTypeCode, SqlDbType.VarChar, 10),
SqlParameterHelper.CreateParameter("@SERVER_NAME", model.ServerName, SqlDbType.VarChar, 20),
SqlParameterHelper.CreateParameter("@IDC_SEQ", model.IdcCode, SqlDbType.VarChar, 20),
SqlParameterHelper.CreateParameter("@RACK_SEQ", model.RackCode, SqlDbType.VarChar, 20),
SqlParameterHelper.CreateParameter("@RACK_START_LOCATION_VALUE", model.RackStartLocationValue.Value, SqlDbType.Int),
SqlParameterHelper.CreateParameter("@VENDER_CODE", model.VenderCode, SqlDbType.VarChar, 20),
SqlParameterHelper.CreateParameter("@CONTENT", model.Content, SqlDbType.VarChar, 4000),
SqlParameterHelper.CreateParameter("@INS_OPRT", model.InsOprt, SqlDbType.VarChar, 30)
);
//return(int)SEQ;
return Convert.ToInt32(SEQ);
}
/// <summary>
/// Asset 서버 정보 추가 및 업데이트
/// 2013-11-25 문태중
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateEtcInfo(AssetEtcInfoT model)
{
return new AssetDac().UpdateEtcInfo(model);
}