/// <summary>
/// [POST] Asset Storage 정보 업데이트
/// 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>
/// <param name="InsOprt"></param>
/// <param name="DelDate"></param>
/// <param name="InsDate"></param>
/// <returns></returns>
public JsonResult SetStorageUpdate(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();
AssetStorageInfoT model = new AssetStorageInfoT();
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().UpdateStorageInfo(model);
returnModel.statusCode = nResult > 0 ? StatusCodeEnum.Success : StatusCodeEnum.Fail;
return Json(returnModel);
}
/// <summary>
/// Asset Storage 정보 추가 및 업데이트
/// 2013-11-27 변승현
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateStorageInfo(AssetStorageInfoT model)
{
var SEQ = new DacHelper(DbHelper, "intradb_write").SelectScalar(
CommandType.StoredProcedure,
"dbo.UPAR_ASSETDB_Asset_UpdateAssetStorageInfo",
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.Int),
SqlParameterHelper.CreateParameter("@CONTENT", model.Content, SqlDbType.VarChar, 4000),
SqlParameterHelper.CreateParameter("@INS_OPRT", model.InsOprt, SqlDbType.VarChar, 30)
);
return Convert.ToInt32(SEQ);
}
/// <summary>
/// Asset Storage 정보 추가 및 업데이트
/// 2013-11-27 변승현
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateStorageInfo(AssetStorageInfoT model)
{
return new AssetDac().UpdateStorageInfo(model);
}