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