/// <summary>
/// [POST] Asset 네트워크 정보 업데이트
/// 2013-11-27 김두성
/// </summary>
/// <param name="Seq"></param>
/// <param name="SapNo"></param>
/// <param name="ServerName"></param>
/// <param name="EquipTypeCode"></param>
/// <param name="SiteCode"></param>
/// <param name="TaskCode"></param>
/// <param name="ServiceCode"></param>
/// <param name="IdcCode"></param>
/// <param name="RackCode"></param>
/// <param name="BuyDate"></param>
/// <param name="OsCode"></param>
/// <param name="VenderCode"></param>
/// <param name="Content"></param>
/// <returns></returns>
public JsonResult SetNetworkUpdate(Int64? Seq, string SapNo, string ServerName, string SerialNo, int Qty, string EquipTypeCode, string SiteCode,
String IdcCode, String RackCode, int RackStartLocationValue, DateTime BuyDate, string VenderCode, string Content)
{
ResultModel returnModel = new ResultModel();
AssetNetworkInfoT model = new AssetNetworkInfoT();
model.Seq = (Seq == null) ? 0 : Seq.Value;
model.SapNo = SapNo;
model.ServerName = ServerName;
model.SerialNo = SerialNo;
model.Qty = Qty;
model.EquipTypeCode = EquipTypeCode;
model.SiteCode = SiteCode;
model.IdcCode = IdcCode;
model.RackCode = RackCode;
model.RackStartLocationValue = RackStartLocationValue;
model.BuyDate = BuyDate;
model.VenderCode = VenderCode;
model.Content = Content;
model.InsOprt = this.UserID;
int nResult = new AssetBiz().UpdateNetworkInfo(model);
returnModel.statusCode = nResult > 0 ? StatusCodeEnum.Success : StatusCodeEnum.Fail;
return Json(returnModel);
}
/// <summary>
/// Asset 네트워크 정보 추가 및 업데이트
/// 2013-11-27 김두성
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateNetworkInfo(AssetNetworkInfoT model)
{
var SEQ = new DacHelper(DbHelper, "intradb_write").SelectScalar(
CommandType.StoredProcedure,
"dbo.UPAR_ASSETDB_Asset_UpdateAssetNetworkInfo",
SqlParameterHelper.CreateParameter("@SEQ", model.Seq == null ? 0 : model.Seq.Value, SqlDbType.BigInt),
SqlParameterHelper.CreateParameter("@BUY_DATE", model.BuyDate, SqlDbType.DateTime),
SqlParameterHelper.CreateParameter("@SAP_NO", model.SapNo, SqlDbType.VarChar, 50),
SqlParameterHelper.CreateParameter("@EQUIP_TYPE_CODE", model.EquipTypeCode, SqlDbType.VarChar, 10),
SqlParameterHelper.CreateParameter("@SERIAL_NO", model.SerialNo, SqlDbType.VarChar, 50),
SqlParameterHelper.CreateParameter("@SERVER_NAME", model.ServerName, SqlDbType.VarChar, 20),
SqlParameterHelper.CreateParameter("@SITE_CODE", model.SiteCode, SqlDbType.VarChar, 10),
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("@QTY", model.Qty.Value, SqlDbType.TinyInt),
SqlParameterHelper.CreateParameter("@CONTENT", model.Content, SqlDbType.VarChar, 4000),
SqlParameterHelper.CreateParameter("@INS_OPRT", model.InsOprt, SqlDbType.VarChar, 30)
);
return Convert.ToInt32(SEQ);
}
/// <summary>
/// Asset 네트워크 정보 추가 및 업데이트
/// 2013-11-27 김두성
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateNetworkInfo(AssetNetworkInfoT model)
{
return new AssetDac().UpdateNetworkInfo(model);
}
