///// <summary> ///// 通过获取子类得到折旧周期 ///// </summary> ///// <returns></returns> public string GetPeriodAidType(string parentId) { //var subTypeList = new AIDSvc().GetPeriodAidType(parentId); //var strJson = ConvertToSelectJson(subTypeList, "Depreciation_year", "Depreciation_year"); //return strJson.ToString(); List <T_PTR> Record = new List <T_PTR>(); Record = new AIDSvc().GetPeriodAidType(parentId); return(new JavaScriptSerializer().Serialize(Record)); }
/// <summary> /// 删除采购记录 /// </summary> /// <param name="id">productbom纪录标识</param> /// <returns></returns> public string DelProductBomDetail(string id, int nodelevel) { bool result = new AIDSvc().DelProductBomDetail(id, nodelevel); string msg = string.Empty; if (result) { return("success"); } else { return("failed"); } }
/// <summary> /// 删除采购记录 /// </summary> /// <param name="id">收款纪录标识</param> /// <returns></returns> public string DelAssetPurchaseRecord(string id) { var result = AIDSvc.DelAIDIERecord(id); string msg = string.Empty; if (result == 1) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 更改状态 /// </summary> /// <param name="id"></param> /// <param name="state"></param> /// <returns></returns> public string UpdIndirectMaterialPurchasingRecordState(string id, string state) { bool result = new AIDSvc().UpdAIDState("I", id, state); string msg = string.Empty; if (result) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 删除采购记录 /// </summary> /// <param name="id">收款纪录标识</param> /// <returns></returns> public string DelDirectMaterialPurchasingRecord(string id) { bool result = new AIDSvc().DelAIDIERecord(id); string msg = string.Empty; if (result) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
public string UpdateFixedAssets(FixAssetsAmount fixAmount) { fixAmount.C_GUID = Session["CurrentCompanyGuid"].ToString(); bool result = new AIDSvc().UpdateFixAssetAmount(fixAmount); ExceResult res = new ExceResult(); res.success = result; if (result) { res.msg = "更新成功!"; } else { res.msg = "更新失败!"; } return(JsonConvert.SerializeObject(res)); }
/// <summary> /// 更新间接物品采购纪录 /// </summary> /// <param name="head">收入主数据</param> /// <param name="list">收入明细数据</param> /// <returns></returns> public string UpdDirectMaterialPurchasingRecord(T_AIDRecord form) { bool result = false; string msg = string.Empty; form.C_GUID = Session["CurrentCompany"].ToString(); result = new AIDSvc().UpdDirectMaterialPurchasingRecord(form); if (result) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
///// <summary> ///// 获取bom结构 ///// </summary> ///// <returns></returns> public string GetProductBom(string subId) { ExceResult rs = new ExceResult(); DataTable bom = AIDSvc.GetProductBomList(subId); List <ProductNode> treeNode = new FMS.BLL.ProductManageController().GetProductNoeList(bom); if (treeNode != null) { rs.success = true; rs.msg = JsonConvert.SerializeObject(treeNode); } else { rs.success = false; rs.msg = "该产品未设置结构,请先设置结构。"; } return(JsonConvert.SerializeObject(rs)); }
///// <summary> ///// 更新物料数量 ///// </summary> ///// <returns></returns> public string EditProductBomRecord(T_ProductBom form) { ExceResult rs = new ExceResult(); bool result = false; string msg = string.Empty; result = new AIDSvc().UpdProductBomRecord(form); if (result) { rs.success = true; rs.msg = "修改成功"; } else { rs.success = true; rs.msg = "修改失败"; } return(JsonConvert.SerializeObject(rs)); }
/// <summary> /// 更新费用纪录(转售) /// </summary> /// <param name="head">费用主数据</param> /// <param name="list">费用明细数据</param> /// <returns></returns> public string UpdResaleExpenseRecord(T_AIDRecord form) { bool result = false; string msg = string.Empty; form.C_GUID = Session["CurrentCompanyGuid"].ToString(); //当前用户 form.Creator = base.userData.LoginFullName; result = new AIDSvc().UpdResaleIndirectMaterialPurchasingRecord(form); if (result) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 删除类别 /// </summary> /// <param name="partner">删除类别</param> /// <returns></returns> public string DelPurchasingTypeRecord(T_PTR ptr) { string rs = ""; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); bool result = new AIDSvc().DelPurchasingTypeRecord(ptr); if (result) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
public string UpdAssetPurchaseRecord(string id, string rper, decimal amount, string invtype, string remark, string currency, string addstyle, DateTime date, int depreciationperiod, string description, decimal surplusvalue, string state) { bool result = false; string msg = string.Empty; T_AIDRecord Record = new T_AIDRecord(); Record.C_GUID = Session["CurrentCompany"].ToString(); Record.GUID = id; Record.RPer = rper; Record.Date = date; Record.Amount = amount; Record.InvType = invtype; Record.Remark = remark; Record.Currency = currency; Record.Description = description; Record.DepreciationPeriod = depreciationperiod; Record.SurplusValue = surplusvalue; Record.State = state; DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString()); if (Record.Date <= DateTime.Now && Record.Date >= EditThreshold) { result = new AIDSvc().UpdAssetPurchaseRecord(Record); if (result) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } } else { result = false; msg = FMS.Resource.Finance.Finance.DateError; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 添加bom物料前的查询 /// </summary> /// <param name="partner">更新父类别前查询</param> /// <returns></returns> public string GetUpdPurchasingBomTypeRecord(T_ProductBom pb) { string rs = ""; int count = 0; string C_GUID = Session["CurrentCompanyGuid"].ToString(); List <T_ProductBom> Record = new List <T_ProductBom>(); Record = new AIDSvc().GetUpdPurchasingBomTypeRecord(out count, C_GUID, pb.nodes, pb.subnodes, pb.nodelevel, pb.nodesid, pb.MaterielManage_GUID); if (Record.Count == 0) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
/// <summary> /// 保存直接物料 /// </summary> /// <param name="recordList">直接物料列表</param> /// <returns></returns> public string UpdateRecord(List <T_AIDRecord> recordList) { bool saved = false; DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString()); //日期必须在Now 和 EditThreshold之间 var dateCheck = DateCheck(recordList); ExceResult res = new ExceResult(); //无符合的日期返回日期异常提示 if (dateCheck.Count == 0) { res.success = false; res.msg = FMS.Resource.Finance.Finance.DateError; return(JsonConvert.SerializeObject(res)); } foreach (T_AIDRecord aid in recordList) { aid.C_GUID = Session["CurrentCompanyGuid"].ToString(); aid.State = "库存"; saved = new AIDSvc().UpdDirectMaterialPurchasingRecord(aid); if (saved) { res.success = true; res.msg = General.Resource.Common.Success; } else { res.success = false; res.msg = General.Resource.Common.Failed; break; } } return(JsonConvert.SerializeObject(res)); }
/// <summary> /// 更新父类别前查询 /// </summary> /// <param name="partner">更新父类别前查询</param> /// <returns></returns> public string GetUpdPurchasingTypeRecord(T_PTR ptr) { string rs = ""; int count = 0; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); List <T_AIDRecord> Record = new List <T_AIDRecord>(); Record = new AIDSvc().GetUpdPurchasingTypeRecord(out count, ptr.AidTypeName, ptr.AID_FLAG, ptr.C_GUID); if (Record.Count == 0) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
/// <summary> /// 删除类别前查询 /// </summary> /// <param name="partner">删除类别</param> /// <returns></returns> public string GetDelMaterielManage(T_PTR ptr) { string rs = ""; int count = 0; ptr.C_GUID = Session["CurrentCompanyGuid"].ToString(); List <T_AIDRecord> Record = new List <T_AIDRecord>(); Record = new AIDSvc().GetDelMaterielManage(out count, ptr.C_GUID, ptr.MM_GUID, ptr.MM_FLAG); if (Record.Count == 0) { rs = "true"; } else { rs = "false"; } return(rs); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
/// <summary> /// 添加物料 /// </summary> /// <returns></returns> public string SubmitProductBomRecord(List <T_ProductBom> recordList) { bool saved = false; ExceResult res = new ExceResult(); foreach (T_ProductBom aid in recordList) { saved = new AIDSvc().SubmitProductBomRecord(aid); if (saved) { res.success = true; res.msg = General.Resource.Common.Success; } else { res.success = false; res.msg = General.Resource.Common.Failed; break; } } return(JsonConvert.SerializeObject(res)); }
/// <summary> /// 批量导入excel数据 /// </summary> public ActionResult Upexcel(FormCollection from) { HttpPostedFileBase file = Request.Files["upload"]; string result = string.Empty; if (file == null || file.ContentLength <= 0) { } else { try { Workbook workbook = new Workbook(file.InputStream); Cells cells = workbook.Worksheets[0].Cells; DataTable tab = cells.ExportDataTable(0, 0, cells.Rows.Count, cells.MaxDisplayRange.ColumnCount); int rowsnum = tab.Rows.Count; if (rowsnum == 0) { result = "Excel表为空!请重新导入!"; //当Excel表为空时,对用户进行提示 } //数据表一共多少行! DataRow[] dr = tab.Select(); //按行进行数据存储操作! for (int i = 1; i < dr.Length; i++) { //RPer,B_Guid,BA_Guid数据需要比对! string rper = (new BusinessPartnerSvc().GetPartnersDts(Session["CurrentCompanyGuid"].ToString(), dr[i][3].ToString())).ToString(); T_AIDRecord record = new T_AIDRecord(); record.C_GUID = Session["CurrentCompanyGuid"].ToString(); record.GUID = Guid.NewGuid().ToString(); record.Date = dr[i][0].ToString(); record.Amount = Convert.ToDecimal(dr[i][1].ToString()); record.Currency = dr[i][2].ToString(); record.RPer = rper; record.InvType = dr[i][4].ToString(); record.Description = dr[i][5].ToString(); record.DepreciationPeriod = Convert.ToInt32(dr[i][6].ToString()); record.Remark = dr[i][7].ToString(); record.SurplusValue = Convert.ToDecimal(dr[i][1].ToString()); record.State = "折旧中"; bool TorF = new AIDSvc().UpdAssetPurchaseRecord(record); if (TorF) { result = "导入成功!"; } else { result = "导入失败!"; } } } catch (Exception) { result = "导入失败,请检查EXCEL格式是否错误!"; } } JsonResult json = new JsonResult(); json.Data = result; return(json); }
public ActionResult ImportExcel() { ExceResult res = new ExceResult(); res.success = true; var file = Request.Files; string result = string.Empty; if (file == null || file.Count <= 0) { res.success = false; res.msg = "无有效文件"; } else { try { Workbook workbook = new Workbook(file[0].InputStream); Cells cells = workbook.Worksheets[0].Cells; DataTable tab = cells.ExportDataTable(0, 0, cells.Rows.Count, cells.MaxDisplayRange.ColumnCount); int rowsnum = tab.Rows.Count; if (rowsnum == 0) { res.success = false; result = "Excel表为空!请重新导入!"; //当Excel表为空时,对用户进行提示 } //数据表一共多少行! DataRow[] dr = tab.Select(); //按行进行数据存储操作! for (int i = 1; i < dr.Length; i++) { T_AIDRecord record = new T_AIDRecord(); record.C_GUID = Session["CurrentCompanyGuid"].ToString(); record.GUID = Guid.NewGuid().ToString(); record.Date = dr[i][0].ToString(); record.Amount = Convert.ToDecimal(dr[i][1].ToString()); if (record.Date.CompareTo(GetNowDate()) > 0) { result = "导入失败,购入日期错误"; break; } try { string currency = (new CurrencySvc().GetCurrency(dr[i][2].ToString())).ToString(); record.Currency = currency; } catch (Exception) { result = "导入失败,无此货币"; break; } try { string rper = (new BusinessPartnerSvc().GetPartnersDts(Session["CurrentCompanyGuid"].ToString(), dr[i][3].ToString())).ToString(); record.RPer = rper; } catch (Exception) { result = "导入失败,无此供应商"; break; } record.AssetType = dr[i][4].ToString(); if (record.AssetType != "固定资产" && record.AssetType != "无形资产") { result = "导入失败,无此资产分类"; break; } try { string InvType = (new AIDSvc().GetAssetTypeCatId(Session["CurrentCompanyGuid"].ToString(), dr[i][4].ToString(), dr[i][5].ToString())).ToString(); record.InvType = InvType; } catch (Exception) { result = "导入失败,无此资产类别"; break; } try { string SonInvType = (new AIDSvc().GetSubTypeCatId(Session["CurrentCompanyGuid"].ToString(), dr[i][6].ToString(), dr[i][5].ToString())).ToString(); record.SonInvType = SonInvType; } catch (Exception) { result = "导入失败,无此资产子类别"; break; } //record.DepreciationPeriod = int.Parse(dr[i][6].ToString()); //record.Remark = ""; record.State = "折旧中"; bool TorF = new AIDSvc().UpdAssetPurchaseRecord(record); if (TorF) { result = "导入成功!"; } else { result = "导入失败!"; } } } catch (Exception) { result = "导入失败,请检查EXCEL格式是否错误!"; } } JsonResult json = new JsonResult(); json.Data = result; return(json); }