/// <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); }