/// <summary>
/// [POST] Asset 서버 정보 업데이트
/// 2013-11-25 문태중
/// </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 SetServerUpdate(Int64? Seq, string SapNo, string ServerName, string SerialNo, int Qty, string EquipTypeCode, string SiteCode, string TaskCode,
string ServiceCode, String IdcCode, String RackCode, int RackStartLocationValue, DateTime BuyDate, string OsCode, string VenderCode, string Content)
{
ResultModel returnModel = new ResultModel();
AssetServerInfoT model = new AssetServerInfoT();
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.TaskCode = TaskCode;
model.ServiceCode = ServiceCode;
model.IdcCode = IdcCode;
model.RackCode = RackCode;
model.RackStartLocationValue = RackStartLocationValue;
model.BuyDate = BuyDate;
model.OsCode = OsCode;
model.VenderCode = VenderCode;
model.Content = Content;
model.InsOprt = this.UserID;
int nResult = new AssetBiz().UpdateServerInfo(model);
returnModel.statusCode = nResult > 0 ? StatusCodeEnum.Success : StatusCodeEnum.Fail;
return Json(returnModel);
}
/// <summary>
/// Asset 서버 정보 추가 및 업데이트
/// 2013-11-25 문태중
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateServerInfo(AssetServerInfoT model)
{
var SEQ = new DacHelper(DbHelper, "intradb_write").SelectScalar(
CommandType.StoredProcedure,
"dbo.UPAR_ASSETDB_Asset_UpdateAssetServerInfo",
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("@TASK_CODE", model.TaskCode, SqlDbType.VarChar, 10),
SqlParameterHelper.CreateParameter("@SERVICE_CODE", model.ServiceCode, SqlDbType.VarChar, 10),
SqlParameterHelper.CreateParameter("@IDC_CODE", model.IdcCode, SqlDbType.VarChar, 20),
SqlParameterHelper.CreateParameter("@RACK_CODE", 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.Int),
SqlParameterHelper.CreateParameter("@OS_CODE", model.OsCode, SqlDbType.VarChar, 10),
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-25 문태중
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateServerInfo(AssetServerInfoT model)
{
return new AssetDac().UpdateServerInfo(model);
}
