public static int InsertWarehouseStockHistory(IDbContext context, mms_warehouseStockHistory history)
{
var userName = MmsHelper.GetUserName();
history.CreateDate = DateTime.Now;
history.CreatePerson = userName;
history.UpdateDate = DateTime.Now;
history.UpdatePerson = userName;
var stock = context.Select <mms_warehouseStock>("Num,UnitPrice")
.From("mms_warehouseStock")
.Where("WarehouseCode=@0 and MaterialCode=@1")
.Parameters(history.WarehouseCode, history.MaterialCode)
.QuerySingle();
if (stock != null)
{
history.StockNum = stock.Num;
history.StockUnitPrice = stock.UnitPrice;
history.StockMoney = stock.Money;
}
var result = context.Insert <mms_warehouseStockHistory>("mms_warehouseStockHistory", history).AutoMap(x => x.Id).Execute();
return(result);
}
public void AppendLoginHistory(JObject request)
{
var lanIP = ZHttp.ClientIP;
var hostName = ZHttp.IsLanIP(lanIP) ? ZHttp.ClientHostName : string.Empty; //如果是内网就获取，否则出错获取不到，且影响效率
var UserCode = request.Value <string>("usercode");
var UserName = MmsHelper.GetUserName();
var IP = request.Value <string>("ip");
var City = request.Value <string>("city");
if (IP != lanIP)
{
IP = string.Format("{0}/{1}", IP, lanIP).Trim('/').Replace("::1", "localhost");
}
var item = new sys_loginHistory();
item.UserCode = UserCode;
item.UserName = UserName;
item.HostName = hostName;
item.HostIP = IP;
item.LoginCity = City;
item.LoginDate = DateTime.Now;
db.Insert <sys_loginHistory>("sys_loginHistory", item).AutoMap(x => x.ID).Execute();
}
protected override void OnAfterHandleExcel(ref DataTable dtSheet)
{
var service = new SYS_BN_UserService();
dtSheet.Columns.Add("CreatePerson", typeof(string));
dtSheet.Columns.Add("CreateTime", typeof(DateTime));
dtSheet.Columns.Add("ModifyPerson", typeof(string));
dtSheet.Columns.Add("ModifyTime", typeof(DateTime));
dtSheet.Columns.Add("UserBarcode", typeof(string));
string maxBarCode = db.Sql(@"SELECT ISNULL(MAX(UserBarcode),'USER00000000') FROM dbo.SYS_BN_User WHERE UserBarcode IS NOT NULL AND LTRIM(RTRIM(UserBarcode)) <> ''").QuerySingle <string>();
long maxNum = Convert.ToInt64(maxBarCode.Substring(4));
var userCodeAndBarcodeList = db.Sql(@"SELECT UserCode,UserBarcode FROM dbo.SYS_BN_User WHERE UserBarcode IS NOT NULL AND LTRIM(RTRIM(UserBarcode)) <> ''").QueryMany <dynamic>();
Dictionary <string, string> dicUserCodeAndBarcode = new Dictionary <string, string>();
userCodeAndBarcodeList.ForEach(item => { dicUserCodeAndBarcode.Add(item.UserCode, item.UserBarcode); });
var userName = MmsHelper.GetUserName();
var newDT = DateTime.Now;
foreach (DataRow item in dtSheet.Rows)
{
string dName = item["DepartmentName"].ToString();
string sql = string.Format(@"select DepartmentCode from SYS_BN_Department where DepartmentName='{0}'", dName);
string hID = db.Sql(sql).QuerySingle <string>();
item["DepartmentCode"] = hID;
string isenable = item["IsEnable"].ToString();
if (isenable == "否")
{
item["IsEnable"] = 0;
}
else
{
item["IsEnable"] = 1;
}
var UserCode = item["UserCode"].ToString();
item["CreatePerson"] = userName;
item["CreateTime"] = newDT;
item["ModifyPerson"] = userName;
item["ModifyTime"] = newDT;
if (dicUserCodeAndBarcode.ContainsKey(UserCode))
{
item["UserBarcode"] = dicUserCodeAndBarcode[UserCode];
}
else
{
Interlocked.Increment(ref maxNum);
item["UserBarcode"] = "USER" + maxNum.ToString().PadLeft(8, '0');
}
var Query = ParamDelete.Instance().AndWhere("UserCode", UserCode);
service.Delete(Query);
}
base.OnAfterHandleExcel(ref dtSheet);
}
public void PostOnSaveWorkStep(dynamic data)
{
List <PRS_ProcessWorkSteps> model = new List <PRS_ProcessWorkSteps>();
foreach (var item in data.model)
{
int?ManHours = item.ManHours;
PRS_ProcessWorkSteps step = new PRS_ProcessWorkSteps();
step.WorkStepsLineCode = item.WorkStepsLineCode;
step.WorkStepsName = item.WorkStepsName;
step.WorkStepsContent = item.WorkStepsContent;
step.ManHours = ManHours;
step.Unit = Convert.ToInt32(item.Unit);
step.ProcessRouteID = Convert.ToInt32(data["gyid"].ToString());
step.CreatePerson = MmsHelper.GetUserName();
step.CreateTime = DateTime.Now;
step.ModifyPerson = step.CreatePerson;
step.ModifyTime = step.CreateTime;
step.IsEnable = 1;
model.Add(step);
}
if (model.Count > 0)
{
new PRS_ProcessWorkStepsService().Insert(model);
}
}
public ResultModel UpdateSavantAndPBomNum(long id, int num)
{
try
{
MES_SavantAndPBom modelA = db.Sql(string.Format(@"SELECT * FROM MES_SavantAndPBom WHERE ID = {0}", id)).QuerySingle <MES_SavantAndPBom>();
if (modelA == null)
{
throw new Exception("查不到 MES_SavantAndPBom 完整数据");
}
else
{
PRS_Process_BOM_Blanking modelB = db.Sql(string.Format(@"SELECT * FROM dbo.PRS_Process_BOM_Blanking WHERE IsEnable = 1 AND ID = {0}", modelA.ProcessBomID)).QuerySingle <PRS_Process_BOM_Blanking>();
if (modelB == null)
{
throw new Exception("查不到 PRS_Process_BOM_Blanking 完整数据");
}
else if (modelB.BlankingNum == null)
{
throw new Exception("没有维护数据");
}
else
{
int alreadyBlankingNum = db.Sql(string.Format(@"SELECT tbTemp.AlreadyBlankingNum FROM (SELECT ProcessBomID,SUM(ISNULL(BlankingNum,0)) AS AlreadyBlankingNum FROM dbo.MES_SavantAndPBom WHERE ID NOT IN ({0}) GROUP BY ProcessBomID) tbTemp WHERE tbTemp.ProcessBomID = {1}", modelA.ID, modelA.ProcessBomID)).QuerySingle <int>();
if (num >= 0 && num <= (modelB.BlankingNum - alreadyBlankingNum))
{
string sql = WinFormClientService.GetUpdateSQL(nameof(MES_SavantAndPBom), new KeyValuePair <string, object>("ID", id), new
{
BlankingNum = num,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = DateTime.Now
});
return(new ResultModel()
{
Result = db.Sql(sql).Execute() > 0,
Msg = @"保存成功！"
});
}
else
{
throw new Exception("无效的数量，请重新填写！");
}
}
}
}
catch (Exception ex)
{
return(new ResultModel()
{
Result = false,
Msg = ex.Message
});
}
}
public void PostWorkingTicketLower(dynamic data)
{
string WTList = data.WTList;
new MES_WorkingTicketService()
.Update(ParamUpdate.Instance()
.Update("MES_WorkingTicket")
.Column("ApproveState", 2)
.Column("ApproveTime", DateTime.Now)
.Column("ApprovePerson", MmsHelper.GetUserName())
.AndWhere("ID", WTList, Cp.In));
}
/// <summary>
/// 采购接单主界面
/// </summary>
/// <returns></returns>
public ActionResult Index2()
{
var code = new sys_codeService();
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string departcode = string.Empty;
string departname = string.Empty;
if (depart != null)
{
departcode = depart.DepartmentCode;
departname = depart.DepartmentName;
}
var model = new
{
dataSource = new
{
},
urls = new
{
query = "/api/Mms/APS_ProductPurchaseDetail1",
newkey = "/api/Mms/APS_ProductPurchaseDetail1/getnewkey",
edit = "/api/Mms/APS_ProductPurchaseDetail1/edit"
},
resx = new
{
noneSelect = "请先选择一条数据！",
editSuccess = "保存成功！",
auditSuccess = "单据已审核！"
},
form = new
{
WarehouseName = "",
PurchaseDate = "",
ContractCode = "",
ProjectName = "",
SaleMan = MmsHelper.GetUserName(),
UserCode = MmsHelper.GetUserCode(),
DepartmentCode = departcode
},
defaultRow = new
{
},
setting = new
{
idField = "ID",
postListFields = new string[] { "ID", "MainID", "InventoryCode", "SingleProductRequestQuantity", "TotalRequestQuantity", "Remark", "PurchaseState", "IsEnable", "CreatePerson", "CreateTime", "ModifyPerson", "ModifyTime", "PurchaseQuantity", "StockQuantity", "RequestedQuantity", "SaleMan", "DepartmentCode", "DepartmentName", "WarehouseCode", "WarehouseName", "SupplierCode", "SupplierName", "OrderQuantity", "PurchaseFeedback", "PurchaseRemark", "UserCode", "PurchaseDate" }
}
};
return(View(model));
}
public dynamic AddSavantAndPBomData(string ids, string savantCode)
{
try
{
StringBuilder sb = new StringBuilder();
DateTime newDT = DateTime.Now;
ids.Split(',').ToList().ForEach(item =>
{
string[] arr = item.Split('|');
sb.Append(WinFormClientService.GetInsertSQL(new MES_SavantAndPBom()
{
SavantCode = savantCode,
ProcessBomID = Convert.ToInt32(arr[0]),
BlankingNum = Convert.ToInt32(arr[1]),
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT
}));
});
sb.Append(string.Format(@"
UPDATE dbo.MES_SavantManage
SET SpareMateNum = 1,
SplitNum =
(
SELECT SUM(BlankingNum)
FROM dbo.MES_SavantAndPBom
WHERE SavantCode = '{0}'
);
", savantCode));
string sql = sb.ToString();
return(new ResultModel()
{
Result = db.Sql(sql).Execute() > 0,
Msg = @"新增成功！"
});
}
catch (Exception ex)
{
return(new ResultModel()
{
Result = false,
Msg = ex.Message
});
}
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new CheckApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("check"),
resx = MmsHelper.GetEditResx("盘点单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject),
yearItems = codeService.GetYearItems(),
monthItems = codeService.GetMonthItems()
},
defaultForm = new mms_check().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
Years = DateTime.Now.Year,
Months = DateTime.Now.Month
}),
defaultRow = new
{
BookNum = 0,
BookMoney = 0,
ActualNum = 0,
ActualUnitPrice = 0,
OperateNum = 0,
OperateMoney = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "BookNum", "BookMoney", "ActualNum", "ActualUnitPrice", "OperateNum", "OperateMoney", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new ReceiveApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("receive"),
resx = MmsHelper.GetEditResx("收料单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
supplyType = codeService.GetValueTextListByType("SupplyType"),
payKinds = codeService.GetValueTextListByType("PayType"),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_receive().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
ReceiveDate = DateTime.Now,
SupplyType = codeService.GetDefaultCode("SupplyType"),
PayKind = codeService.GetDefaultCode("PayType"),
}),
defaultRow = new
{
CheckNum = 1,
Num = 1,
UnitPrice = 0,
Money = 0,
PrePay = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "CheckNum", "Num", "UnitPrice", "PrePay", "Money", "Remark" }
}
};
return(View(model));
}
//出场保存之后，更新进场单中的剩余数量
protected override void OnAfterEditDetail(EditEventArgs arg)
{
var userName = MmsHelper.GetUserName();
decimal num = arg.row.Value <decimal>("Num") - (arg.rowOld.Num ?? 0);
string srcBillNo = arg.row.Value <string>("SrcBillNo");
int srcRowId = arg.row.Value <int>("SrcRowId");
arg.db.Sql(string.Format(@"
update mms_rentInDetail
set RemainNum = isnull(RemainNum,0) - {0} ,
UpdateDate = getdate(),
UpdatePerson = '{1}'
where BillNo='{2}'
and RowId='{3}'", num, userName, srcBillNo, srcRowId)).Execute();
base.OnAfterEditDetail(arg);
}
public ActionResult Edit(string id = "")
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new DealApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("deal"),
resx = MmsHelper.GetEditResx("处置单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
disposalTypes = codeService.GetValueTextListByType("DisposalType"),
disposalWays = codeService.GetValueTextListByType("DisposalWay")
},
defaultForm = new mms_deal().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
ApplyDate = DateTime.Now,
DealType = codeService.GetDefaultCode("DisposalType"),
DealKind = codeService.GetDefaultCode("DisposalWay"),
}),
defaultRow = new
{
UnitPrice = 0,
Num = 1,
Money = 0,
DealDate = DateTime.Now
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialName", "Model", "Unit", "DealDate", "ExpendCompany", "UnitPrice", "Num", "Money", "Remark" }
}
};
return(View(model));
}
//更新材料库存信息
public static int UpdateWarehouseStock(IDbContext context, string warehouseCode, string MaterialCode, string Unit, decimal UnitPrice, decimal Num)
{
var userName = MmsHelper.GetUserName();
var builder = context.Select <mms_warehouseStock>("*")
.From("mms_warehouseStock")
.Where("WarehouseCode=@0 and MaterialCode=@1")
.Parameters(warehouseCode, MaterialCode);
mms_warehouseStock stock = builder.QuerySingle() ?? new mms_warehouseStock()
{
WarehouseCode = warehouseCode,
MaterialCode = MaterialCode,
Unit = Unit,
UnitPrice = 0,
Num = 0,
Money = 0,
CreateDate = DateTime.Now,
CreatePerson = userName
};
stock.Num = (stock.Num ?? 0) + Num;
stock.Money = (stock.Money ?? 0) + UnitPrice * Num;
stock.UnitPrice = stock.Money / (stock.Num == 0 ? 1 : stock.Num);
stock.UpdateDate = DateTime.Now;
stock.UpdatePerson = userName;
var rowsAffect = context.Update <mms_warehouseStock>("mms_warehouseStock", stock)
.AutoMap(x => x.WarehouseCode, x => x.MaterialCode)
.Where(x => x.WarehouseCode).Where(x => x.MaterialCode)
.Execute();
if (rowsAffect == 0)
{
rowsAffect = context.Insert <mms_warehouseStock>("mms_warehouseStock", stock).AutoMap().Execute();
}
if (rowsAffect < 0)
{
throw new Exception("更新仓库库存时发错误，请重试或联系管理员！");
}
return(rowsAffect);
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new SendApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("send"),
resx = MmsHelper.GetEditResx("发料单"),
dataSource = new
{
priceKinds = codeService.GetValueTextListByType("Pricing"),
materialUse = codeService.GetValueTextListByType("MaterialUse"),
measureUnit = codeService.GetMeasureUnitListByType(),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_send().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
SendDate = DateTime.Now,
PriceKind = codeService.GetDefaultCode("Pricing")
}),
defaultRow = new
{
Num = 1,
UnitPrice = 0,
Money = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "UnitPrice", "Num", "Money", "Remark", "SrcBillType", "SrcBillNo", "SrcRowId" }
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new RentinApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("rentin"),
resx = MmsHelper.GetEditResx("租赁进场单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
materialUse = codeService.GetValueTextListByType("MaterialUse"),
billingUnit = codeService.GetValueTextListByType("BillingUnit")
},
defaultForm = new mms_rentIn().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
RentInDate = DateTime.Now,
Purpose = codeService.GetDefaultCode("MaterialUse")
}),
defaultRow = new
{
Num = 1,
UnitPrice = 1
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "UseUnit", "PriceUnit", "Num", "UnitPrice", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id = "")
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new RentoutApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("rentout"),
resx = MmsHelper.GetEditResx("租赁出场单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType()
},
defaultForm = new mms_rentOut().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
RentOutDate = DateTime.Now
}),
defaultRow = new
{
CheckNum = 1,
InStoreNum = 1,
InStoreUnitPrice = 0,
TotalMoney = 0,
PrePay = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "SrcBillNo", "SrcRowId", "MaterialCode", "Unit", "Num", "Remark" }
}
};
return(View(model));
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new RentOffApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = MmsHelper.GetEditUrls("rentOff"),
resx = MmsHelper.GetEditResx("停租单"),
dataSource = new
{
measureUnit = codeService.GetMeasureUnitListByType(),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_rentOff().Extend(new
{
BillNo = id,
BillDate = DateTime.Now,
DoPerson = userName,
BeginDate = DateTime.Now
}),
defaultRow = new
{
UnitPrice = 0,
Num = 1,
Day = 1,
PrePay = 0
},
setting = new
{
postFormKeys = new string[] { "BillNo" },
postListFields = new string[] { "BillNo", "RowId", "MaterialCode", "Unit", "UnitPrice", "Num", "Day", "Money", "Remark" }
}
};
return(View(model));
}
public static int UpdateMaterialWarnning(IDbContext context, string projectCode, string MaterialCode, decimal Num)
{
var userName = MmsHelper.GetUserName();
var builder = context.Select <mms_materialWarnning>("*")
.From("mms_materialWarnning")
.Where("ProjectCode=@0 and MaterialCode=@1")
.Parameters(projectCode, MaterialCode);
mms_materialWarnning warnning = builder.QuerySingle() ?? new mms_materialWarnning()
{
ProjectCode = projectCode,
MaterialCode = MaterialCode,
LowerNum = 0,
UpperNum = 0,
Num = 0,
CreatePerson = userName,
CreateDate = DateTime.Now,
};
warnning.Num = (warnning.Num ?? 0) + Num;
warnning.UpdateDate = DateTime.Now;
warnning.UpdatePerson = userName;
var rowsAffect = context.Update <mms_materialWarnning>("mms_materialWarnning", warnning)
.AutoMap(x => x.ProjectCode, x => x.MaterialCode)
.Where(x => x.ProjectCode).Where(x => x.MaterialCode)
.Execute();
if (rowsAffect == 0)
{
rowsAffect = context.Insert <mms_materialWarnning>("mms_materialWarnning", warnning).AutoMap().Execute();
}
if (rowsAffect < 0)
{
throw new Exception("更新项目库存时发错误，请重试或联系管理员！");
}
return(rowsAffect);
}
public ActionResult Upload(HttpPostedFileBase fileData, string Object_ID = "", string TableName = "")
{
if (fileData != null)
{
try
{
ControllerContext.HttpContext.Request.ContentEncoding = Encoding.GetEncoding("UTF-8");
ControllerContext.HttpContext.Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
ControllerContext.HttpContext.Response.Charset = "UTF-8";
// 文件上传后的保存路径
string filePath = Server.MapPath("~/Upload/" + TableName + "/");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string fileName = Path.GetFileName(fileData.FileName); //原始文件名称
string fileExtension = Path.GetExtension(fileName);
//文件扩展名
string saveName = "[" + DateTime.Now.ToString("yyyyMMddhhmmss") + "]" + fileName; //保存文件名称
fileData.SaveAs(string.Format("{0}\\{1}", filePath, saveName));
string userName = MmsHelper.GetUserName();
string InsertSql = string.Format(@"update PMS_BN_PartFile set FileAddress='{0}' where ID ='{1}'", filePath + saveName, Object_ID);
using (var db = Db.Context("Mms"))
{
//db.UseTransaction(true);
int effectRow = db.Sql(InsertSql).Execute();
}
return(Content("true"));
}
catch (Exception ex)
{
return(Content("false"));
}
}
else
{
return(Content("false"));
}
}
public void PostUpdate5(int id, string docName, string fileName, string filePath, string tableName)
{
PRS_Process_BOM ppBom = new PRS_Process_BOMService().SelectPRS_Process_BOM(id.ToString());
if (docName.IndexOf('.').Equals(-1))
{
throw new Exception("无法读取文件名！");
}
else
{
DateTime newDT = DateTime.Now;
fileName += Path.GetExtension(docName);
//filePath = HttpContext.Current.Server.MapPath("~/Upload/" + filePath) + fileName;
string FtpServer = "ftp://" + ConfigurationManager.AppSettings["FtpServer"] + ":" + ConfigurationManager.AppSettings["FtpPort"];
filePath = FtpServer + "/" + filePath + fileName;
PRS_ProcessFigure model = new PRS_ProcessFigure()
{
ContractCode = ppBom.ContractCode,
ProductID = ppBom.ProductID,
PartCode = ppBom.PartCode,
DocName = docName,
FileName = fileName,
FileAddress = filePath,
IsEnable = 1,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT
};
string sql = WinFormClientService.GetInsertSQL(model);
using (var db = Db.Context("Mms"))
{
db.Sql(sql).Execute();
}
}
}
public dynamic PostProjectDetailOnDelete(List <PMS_BN_ProjectDetail> model)
{
bool result = false;
model[0].ModifyTime = DateTime.Now;
model[0].ModifyPerson = MmsHelper.GetUserName();
using (var db = Db.Context("Mms"))
{
db.UseTransaction(true);
string sql1 = string.Format("update PMS_BN_ProjectDetail set IsEnable=0 where ID={0} ", model[0].ID);
string sql2 = string.Format("update PMS_ProductTask set IsEnable=0 where ProductID='{0}'", model[0].ID);
string sql3 = string.Format("update PMS_DesignTaskDetail set IsEnable=0 where ProductID='{0}'", model[0].ID);
string sql4 = string.Format("update PMS_ProductPlanDetail set IsEnable=0 where ProductID='{0}'", model[0].ID);
bool resProjectDetail = db.Sql(sql1).Execute() >= 0;
bool resProductTask = db.Sql(sql2).Execute() >= 0;
bool resDesignTaskDetail = db.Sql(sql3).Execute() >= 0;
bool resProductPlanDetail = db.Sql(sql4).Execute() >= 0;
if (resProjectDetail)
{
db.Commit();
return(new
{
msg = "删除成功",
result
});
}
else
{
db.Rollback();
return(new
{
msg = "删除失败",
result
});
}
}
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new DrainpipeductApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = new
{
getdetail = "/api/mms/drainpipeduct/getdetail/",
getmaster = "/api/mms/drainpipeduct/geteditmaster/",
edit = "/api/mms/drainpipeduct/edit/",
audit = "/api/mms/drainpipeduct/audit/",
getrowid = "/mms/drainpipeduct/getnewrowid/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditReject = "信息已取消审核！",
auditPassed = "信息已通过审核"
},
dataSource = new
{
Category = codeService.Decode("InspectionWellCategory"),
AdministrativeArea = codeService.Decode("AdministrativeArea"),
SectionForm = codeService.Decode("drainGrooveSectionForm"),
Type = codeService.Decode("drainpipeductType"),
GrooveType = codeService.Decode("drainGrooveType"),
Material = codeService.Decode("PipeMaterial"),
PressureType = codeService.Decode("PipePressureType"),
FacilityStatus = codeService.Decode("FacilityStatus"),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_drainpipeduct().Extend(new
{
BillNo = id,
IdentificationCode = "",
DrainageCode = "",
Address = "",
Start_stopPoint = "",
Category = codeService.GetDefaultCodeNew("InspectionWellCategory"),
GrooveType = codeService.GetDefaultCodeNew("drainGrooveType"),
Length = "",
StartCode = "",
StopCode = "",
StartElevation = "",
StopElevation = "",
SectionForm = codeService.GetDefaultCodeNew("drainGrooveSectionForm"),
Diameter = "",
Material = codeService.GetDefaultCodeNew("PipeMaterial"),
PressureType = codeService.GetDefaultCodeNew("PipePressureType"),
LiningMaterial = codeService.GetDefaultCodeNew("PipeLiningMaterial"),
LiningThick = "",
Slope = "",
Siphon = "",
OwnershipUnit = "",
FacilityStatus = codeService.GetDefaultCodeNew("FacilityStatus"),
DataSources = codeService.GetDefaultCodeNew("DataSources"),
ReportingUnit = "",
Remark = "",
Type = codeService.GetDefaultCodeNew("drainpipeductType"),
AdministrativeArea = codeService.GetDefaultCodeNew("AdministrativeArea")
}),
setting = new
{
postFormKeys = new string[] { "BillNo" }
}
};
return(View(model));
}
public void Cover_MES_BN_MatchingTableDetail(List <MES_BN_MatchingTableDetail> MES_BN_MatchingTableDetailList, List <PRS_Process_BOM> ProcessBomList)
{
try
{
db.UseTransaction(true);
var MaxID = new MES_BN_MatchingTableDetailService().GetField <int>(ParamQuery.Instance().Select("max(ID) as ID").From("MES_BN_MatchingTableDetail"));
string MES_BN_MatchingTableDetailListStr = string.Join(",", MES_BN_MatchingTableDetailList.Select(a => a.ID));
db.Sql($"update MES_BN_MatchingTableDetail set IsEnable=0 where ID in({MES_BN_MatchingTableDetailListStr})").Execute();
var PMS_BN_ProjectList = new PMS_BN_ProjectService().GetModelList();
var PMS_BN_ProjectDetailList = new PMS_BN_ProjectDetailService().GetModelList();
var UpdateList = new List <int>();
ProcessBomList.ForEach(item =>
{
var PartCode = item.PartCode;
var ParentCode = item.ParentCode;
var IsExist = MES_BN_MatchingTableDetailList.Where(a => a.PartCode == PartCode && a.PPartCode == ParentCode).Select(a => a.ID);
if (IsExist.Count() > 0)
{
UpdateList.Add(IsExist.FirstOrDefault());
}
else
{
MES_BN_MatchingTableDetail model = new MES_BN_MatchingTableDetail();
model.ID = ++MaxID;
model.PartCode = PartCode;
model.PartName = item.PartName;
model.PPartCode = item.ParentCode;
model.ContractCode = item.ContractCode;
model.ProjectDetailID = item.ProductID;
model.ProjectName = PMS_BN_ProjectDetailList.Where(a => a.ID == item.ProductID).FirstOrDefault().ProductName;
model.NeedQuantity = item.PartQuantity ?? 0 * PMS_BN_ProjectDetailList.Where(a => a.ID == item.ProductID).FirstOrDefault().Quantity ?? 0;
model.Type = item.IsSelfMade;
model.TypeName = item.IsSelfMade == "0" ? "成品件" : "加工件";
model.BomQuantity = item.PartQuantity ?? 0;
model.IsMaterial = 0;
model.IsEnable = 1;
model.ApproveState = "1";
model.CreatePerson = MmsHelper.GetUserName();
model.CreateTime = DateTime.Now;
//db.Insert<MES_BN_MatchingTableDetail>("MES_BN_MatchingTableDetail", model).AutoMap(a => a.ID).ExecuteReturnLastId<int>();
string sql = WinFormClientService.GetInsertSQL <MES_BN_MatchingTableDetail>(model);
db.Sql(sql).Execute();
}
});
if (UpdateList.Count > 0)
{
db.Sql($"update MES_BN_MatchingTableDetail set IsEnable=1 where ID in({string.Join(",", UpdateList)})").Execute();
}
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
}
}
public int AuditBillCode(string BillCode, out string msg)
{
msg = string.Empty;
//var rowsAffected = 0;
string sql = String.Format(@"
SELECT t1.*,
t1.QualifiedQuntity,
t3.WarehouseID,
t3.WarehouseName,
t2.CheckQuantity
,t4.QuantityUnit
,t4.Model
, t4.InventoryCode
,t4.InventoryName
,t3.WorkshopID
,t3.WorkshopName
FROM dbo.QMS_ProcessInspection t1
LEFT JOIN MES_ProcessInspectionRequest t2
ON t1.PBillCode = t2.BillCode
AND t1.IsEnable = 1
AND t2.IsEnable = 1
AND t2.BillState = 2
LEFT JOIN dbo.MES_BN_ProductProcessRoute t3
ON t2.ProductProcessRouteID = t3.ID
AND t3.IsEnable = 1
inner JOIN dbo.SYS_Part t4 ON t1.PartCode=t4.PartCode
AND t4.IsEnable=1 where t1.BillCode='{0}'" , BillCode);
dynamic stateList = db.Sql(sql).QueryMany <dynamic>();
if (stateList[0].BillState == 2)
{
msg = "单据已审核";
return(0);
}
else
{
sql = string.Format(@"update QMS_ProcessInspection set BillState=2 where BillCode='{0}'", BillCode);
//string insertSql=string.Format(@"")
using (db.UseTransaction(true))
{
int countMain = db.Sql(sql).Execute();
string documentNo = "";
documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "ZXRK", "", "");
//billstate = 2;
#region WMS_BN_BillMain表
string sqlA = string.Format(@"
INSERT INTO dbo.WMS_BN_BillMain
(
ID,
BillCode,
BillType,
ContractCode,
ProjectName,
SalesmanCode,
Salesman,
DepartmentID,
DepartmentName,
SupplierCode,
SupplierName,
WarehouseCode,
WarehouseName,
PickPersonCode,
PickPerson,
ApproveState,
ApprovePerson,
ApproveDate,
ApproveRemark,
Remark,
CreatePerson,
CreateTime,
ModifyPerson,
ModifyTime,
IsEnable
)
VALUES
( {0}, -- ID - int
'{1}', -- BillCode - varchar(50)
{2}, -- BillType - int
'{3}', -- ContractCode - varchar(50)
'{4}', -- ProjectName - varchar(50)
'', -- SalesmanCode - varchar(50)
'', -- Salesman - varchar(50)
'', -- DepartmentID - varchar(50)
'', -- DepartmentName - varchar(50)
'', -- SupplierCode - varchar(50)
'', -- SupplierName - varchar(50)
'{5}', -- WarehouseCode - varchar(50)
'{6}', -- WarehouseName - varchar(50)
'', -- PickPersonCode - varchar(50)
'', -- PickPerson - varchar(50)
'1', -- ApproveState - varchar(50)
'', -- ApprovePerson - varchar(50)
GETDATE(), -- ApproveDate - datetime
'', -- ApproveRemark - varchar(500)
'', -- Remark - varchar(500)
'{7}', -- CreatePerson - varchar(50)
GETDATE(), -- CreateTime - datetime
'{7}', -- ModifyPerson - varchar(50)
GETDATE(), -- ModifyTime - datetime
1 -- IsEnable - int
)
", Convert.ToInt32(new WMS_BN_BillMainService().GetNewKey("ID", "Maxplus")), documentNo, 8, stateList[0].ContractCode,
stateList[0].ProjectName, stateList[0].WarehouseID, stateList[0].WarehouseName, MmsHelper.GetUserName());
#endregion
int countA = db.Sql(sqlA).Execute();
#region WMS_BN_BillDetail表
string sqlB = string.Format(@"
INSERT INTO dbo.WMS_BN_BillDetail
(
BillCode,
OrderBillCode,
InventoryCode,
InventoryName,
Specs,
Unit,
MateNum,
ConfirmNum,
UnitPrice,
TotalPrice,
PackageCode,
BatchCode,
PBillCode,
AccountabilityCode,
Remark,
CreatePerson,
CreateTime,
ModifyPerson,
ModifyTime,
IsEnable
)
VALUES
( '{0}', -- BillCode - varchar(50)
'', -- OrderBillCode - varchar(50)
N'{1}', -- InventoryCode - nvarchar(50)
N'{2}', -- InventoryName - nvarchar(50)
'{3}', -- Specs - varchar(50)
N'{4}', -- Unit - nvarchar(10)
{5}, -- MateNum - float
{6}, -- ConfirmNum - float
0.0, -- UnitPrice - float
0.0, -- TotalPrice - float
'', -- PackageCode - varchar(50)
'', -- BatchCode - varchar(50)
'', -- PBillCode - varchar(50)
'', -- AccountabilityCode - varchar(50)
N'', -- Remark - nvarchar(500)
N'{7}', -- CreatePerson - nvarchar(50)
GETDATE(), -- CreateTime - datetime
N'{7}', -- ModifyPerson - nvarchar(50)
GETDATE(), -- ModifyTime - datetime
1 -- IsEnable - int
)
", documentNo, stateList[0].InventoryCode, stateList[0].InventoryName, stateList[0].Model,
stateList[0].Unit, stateList[0].QualifiedQuntity, stateList[0].QualifiedQuntity, MmsHelper.GetUserName());
#endregion
int countB = db.Sql(sqlB).Execute();
int countC = 0;
bool aaa = true;
bool ccc = true;
//更新库存表
//库存表
List <WMS_BN_RealStock> realStockData = db.Sql("SELECT * FROM WMS_BN_RealStock WHERE IsEnable = 1").QueryMany <WMS_BN_RealStock>();
var realStocks = realStockData.Where(s =>
{
bool a = s.WarehouseCode == null ? false : s.WarehouseCode.Equals(stateList[0].WarehouseID);
bool b = s.InventoryCode == null ? false : s.InventoryCode.Equals(stateList[0].InventoryCode);
bool c = s.BatchCode == null ? false : s.BatchCode.Equals(stateList[0].BatchCode);
return(a && b && c);
}).ToList();
string updateStockSal = "";
if (stateList[0].WarehouseName == stateList[0].WorkshopName)
{
#region
//没有库存则新增
if (realStocks.Count <= 0)
{
WMS_BN_RealStock realStockModel = new WMS_BN_RealStock()
{
InventoryCode = stateList[0].InventoryCode,
InventoryName = stateList[0].InventoryName,
Model = stateList[0].Model,
RealStock = (double)stateList[0].QualifiedQuntity,
TotalStock = (double)stateList[0].QualifiedQuntity,
WarehouseCode = stateList[0].WarehouseID,
WarehouseName = stateList[0].WarehouseName,
BatchCode = stateList[0].BatchCode,
Unit = stateList[0].Unit,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = DateTime.Now,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = DateTime.Now,
IsEnable = 1
};
countC = db.Insert("WMS_BN_RealStock", realStockModel).AutoMap(x => x.ID).Execute();
updateStockSal += String.Format(@" update WMS_BN_BillMain set ApproveState=2 where BillCode = '{0}'", documentNo);
}
//有则更新数量
else if (realStocks.Count.Equals(1))
{
updateStockSal = string.Format("UPDATE WMS_BN_RealStock SET RealStock = {0},TotalStock = {1},ModifyPerson = '{2}',ModifyTime = '{3}' WHERE ID = {4} ;\r\n",
realStocks[0].RealStock + stateList[0].QualifiedQuntity, realStocks[0].TotalStock + stateList[0].QualifiedQuntity, MmsHelper.GetUserName(), DateTime.Now, realStocks[0].ID);
updateStockSal += String.Format(@" update WMS_BN_BillMain set ApproveState=2 where BillCode = '{0}'", documentNo);
}
else
{
return(0);
msg = @"仓库物料种类繁多，可惜不知取哪一种！";
}
#endregion
ccc = db.Sql(updateStockSal).Execute() > 0;
}
if (aaa && countMain > 0 && countA > 0 && countB > 0 && ccc && countC > 0)
{
db.Commit();
msg = "审核单据成功";
return(1);
}
else
{
db.Rollback();
msg = "审核单据失败，请确认数据";
return(1);
}
}
}
}
public void PostCreateProductRequest(dynamic data)
{
var list = data.list;
foreach (dynamic item in list)
{
string ContractCode = item["ContractCode"];
string CreateType = item["CreateType"];
var BoardOrBarData = new List <dynamic>();
switch (CreateType)
{
case "板材":
BoardOrBarData = new PRS_BoardCreateMateService().GetDynamicList(ParamQuery.Instance().AndWhere("ContractCode", ContractCode));
break;
case "棒材":
BoardOrBarData = new PRS_BarCreateMateService().GetDynamicList(ParamQuery.Instance().AndWhere("ContractCode", ContractCode));
break;
case "车间":
int MainID = item["ID"];
BoardOrBarData = new MES_WorkshopPurchaseDetailService().GetDynamicList
(
ParamQuery
.Instance()
.Select("InventoryCode,PurchaseQuantity as InventoryNum,Remark")
.From("MES_WorkshopPurchaseDetail")
.AndWhere("MainID", MainID)
);
break;
default:
break;
}
using (var db = Db.Context("Mms"))
{
db.UseTransaction(true);
try
{
int MainID = new APS_ProductPurchaseMainService().GetModelList().Count > 0 ?
new APS_ProductPurchaseMainService().GetModelList().Max(a => a.ID) + 1 : 1;
db.Insert("APS_ProductPurchaseMain")
.Column("ID", MainID)
.Column("PurchaseDocumentCode", MmsHelper.GetOrderNumber("APS_ProductPurchaseMain", "PurchaseDocumentCode", "SCQG", "", ""))
.Column("ContractCode", ContractCode)
.Column("DepartmentCode", "0202")
.Column("PurchaseDate", DateTime.Now)
.Column("IsEnable", 1)
.Column("BillState", 1)
.Column("PurchaseType", CreateType.Equals("板材") ? 2 : CreateType.Equals("棒材") ? 3 : CreateType.Equals("车间") ? 4 : 1)
.Column("CreateTime", DateTime.Now)
.Column("CreatePerson", MmsHelper.GetUserName()).Execute();
foreach (var item_board in BoardOrBarData)
{
double PurchaseQuantity = Convert.ToDouble(item_board.InventoryNum);
string InventoryCode = item_board.New_InventoryCode;
string Remark = item_board.Remark;
string unit = "";
if (CreateType != "车间")
{
unit = item_board.Unit;
}
db.Insert("APS_ProductPurchaseDetail")
.Column("MainID", MainID)
//.Column("InventoryCode", InventoryCode)
.Column("InventoryCode", InventoryCode)
.Column("TotalRequestQuantity", Convert.ToInt32(PurchaseQuantity))
.Column("PurchaseQuantity", PurchaseQuantity)
.Column("StockQuantity", 0)
.Column("PurchaseState", 0)
.Column("DepartmentCode", "0202")
.Column("DepartmentName", "供应")
.Column("IsEnable", 1)
.Column("CreateTime", DateTime.Now)
.Column("Remark", Remark)
.Column("Unit", unit)
.Column("CreatePerson", MmsHelper.GetUserName()).ExecuteReturnLastId <int>();
}
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
break;
}
}
}
}
public ActionResult Edit(string id)
{
var userName = MmsHelper.GetUserName();
var currentProject = MmsHelper.GetCurrentProject();
var data = new DischargeportApiController().GetEditMaster(id);
var codeService = new sys_codeService();
var model = new
{
form = data.form,
scrollKeys = data.scrollKeys,
urls = new
{
getdetail = "/api/mms/dischargeport/getdetail/",
getmaster = "/api/mms/dischargeport/geteditmaster/",
edit = "/api/mms/dischargeport/edit/",
audit = "/api/mms/dischargeport/audit/",
getrowid = "/mms/dischargeport/getnewrowid/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditReject = "信息已取消审核！",
auditPassed = "信息已通过审核"
},
dataSource = new
{
Category = codeService.Decode("InspectionWellCategory"),
Form = codeService.Decode("DischargeportForm"),
AdministrativeArea = codeService.Decode("AdministrativeArea"),
FilmDoorMaterial = codeService.Decode("FilmDoorMaterial"),
FilmDoor = codeService.Decode("AdditionalFacilities"),
FacilityStatus = codeService.Decode("FacilityStatus"),
warehouseItems = new mms_warehouseService().GetWarehouseItems(currentProject)
},
defaultForm = new mms_dischargeport().Extend(new
{
BillNo = id,
OrgX = "",
OrgY = "",
IdentificationCode = "",
DrainageCode = "",
ReceivingCode = "",
Address = "",
Category = codeService.GetDefaultCodeNew("InspectionWellCategory"),
Size = "",
FilmDoor = codeService.GetDefaultCodeNew("AdditionalFacilities"),
FilmDoorMaterial = codeService.GetDefaultCodeNew("FilmDoorMaterial"),
FilmDoorDiameter = "",
FilmDoorToopElevation = "",
FilmDoorBottomElevation = "",
SubmergedWaterLevel = "",
TideCurve = "",
BottomElevation = "",
Form = codeService.GetDefaultCodeNew("DischargeportForm"),
FacilityStatus = codeService.GetDefaultCodeNew("FacilityStatus"),
DataSources = codeService.GetDefaultCodeNew("DataSources"),
ReportingUnit = "",
Remark = "",
AdministrativeArea = codeService.GetDefaultCodeNew("AdministrativeArea")
}),
setting = new
{
postFormKeys = new string[] { "BillNo" }
}
};
return(View(model));
}
public int AuditBillCode(string BillCode, out string msg)
{
msg = string.Empty;
var rowsAffected = 0;
string sql = String.Format(@"SELECT t1.*,
t3.ProductPurchaseCode,
t4.Model,
t4.Unit,
t4.UnitPrice,
t4.TotalPrice
FROM dbo.QMS_GoodsCheck t1
INNER JOIN dbo.MES_GoodsInspection t2
ON t1.PBillCode = t2.BillCode
AND t2.IsEnable = 1
INNER JOIN dbo.MES_PurchaseOrderMain t3
ON t2.PurchaseOrderCode = t3.BillCode
AND t3.IsEnable = 1
AND t3.BillState = 2
INNER JOIN dbo.MES_PurchaseOrderDetail t4
ON t4.MainID = t3.ID
AND t4.IsEnable = 1 where t1.BillCode='{0}'", BillCode);
string insertSql = "";
dynamic GoodsCheck = db.Sql(sql).QueryMany <dynamic>();
if (GoodsCheck.Count == 0)
{
msg = "请保存数据后审核";
return(0);
}
if (GoodsCheck[0].BillState == 2)
{
msg = "单据已审核";
return(0);
}
else
{
using (var trans = db.UseTransaction(true))
{
#region
/*
* sql = string.Format(@"update QMS_GoodsCheck set BillState=2 where BillCode='{0}'", BillCode);
* rowsAffected = db.Sql(sql).Execute();
* var dno = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "CGRK", "", "");
* insertSql = string.Format(@" INSERT dbo.WMS_BN_BillMain
* (
* ID,
* BillCode,
* BillType,
* ContractCode,
* ProjectName,
* SalesmanCode,
* Salesman,
* DepartmentID,
* DepartmentName,
* SupplierCode,
* SupplierName,
* WarehouseCode,
* WarehouseName,
* ApproveState,
* OrderBillCode,
* Remark,
* CreatePerson,
* CreateTime,
* ModifyPerson,
* ModifyTime,
* IsEnable
* )
* VALUES
* ( (select MAX(id)+1 from WMS_BN_BillMain), -- ID - int ID,
* '{0}', -- BillCode - varchar(50) BillCode,
* ( SELECT Value FROM HBHC_Sys.dbo.sys_code WHERE Text='采购入库' ), --BillType,
* '{1}', -- ContractCode - varchar(50) ContractCode,
* '{2}', -- ProjectName - varchar(50) ProjectName,
* '{3}', -- SalesmanCode - varchar(50) SalesmanCode,
* '{4}', -- Salesman - varchar(50) Salesman,
* '{5}', -- DepartmentID - varchar(50) DepartmentID,
* '{6}', -- DepartmentName - varchar(50) DepartmentName,
* '{7}', -- SupplierCode - varchar(50) SupplierCode,
* '{8}', -- SupplierName - varchar(50) SupplierName,
* '{9}', -- WarehouseCode - varchar(50) WarehouseCode,
* '{10}', -- WarehouseName - varchar(50) WarehouseName,
* '1', -- ApproveState,
* '{11}', --OrderBillCode,
* '{12}', --Remark,
* '{13}', --CreatePerson,)
* GETDATE(), -- CreateTime,
* '{14}', --ModifyPerson,
* GETDATE(), -- ModifyTime,
* 1 -- IsEnable
* )", dno, GoodsCheck[0].ContractCode, GoodsCheck[0].ProjectName, GoodsCheck[0].SalesmanCode, GoodsCheck[0].Salesman, GoodsCheck[0].DepartmentID, GoodsCheck[0].DepartmentName, GoodsCheck[0].SupplierCode,
* GoodsCheck[0].SupplierName, GoodsCheck[0].WarehouseID, GoodsCheck[0].WarehouseName, GoodsCheck[0].ProductPurchaseCode, "", MmsHelper.GetUserName(), MmsHelper.GetUserName());
* insertSql += string.Format(@"INSERT INTO dbo.WMS_BN_BillDetail
* (
* BillCode,
* OrderBillCode,
* InventoryCode,
* InventoryName,
* Specs,
* Unit,
* MateNum,
* ConfirmNum,
* UnitPrice,
* TotalPrice,
* BatchCode,
* PBillCode,
* Remark,
* CreatePerson,
* CreateTime,
* ModifyPerson,
* ModifyTime,
* IsEnable
* )
* VALUES
* ( '{0}', -- BillCode - varchar(50)
* '{1}', -- OrderBillCode - varchar(50)
* N'{2}', -- InventoryCode - nvarchar(50)
* N'{3}', -- InventoryName - nvarchar(50)
* '{4}', -- Specs - varchar(50)
* N'{5}', -- Unit - nvarchar(10)
* '{6}', -- MateNum - float
* '{7}', -- ConfirmNum - float
* '{8}', -- UnitPrice - float
* '{9}', -- TotalPrice - float
* '{10}', -- BatchCode - varchar(50)
* '{11}', -- PBillCode - varchar(50)
* N'', -- Remark - nvarchar(500)
* N'{12}', -- CreatePerson - nvarchar(50)
* GETDATE(), -- CreateTime - datetime
* N'{13}', -- ModifyPerson - nvarchar(50)
* GETDATE(), -- ModifyTime - datetime
* 1 -- IsEnable - int
* )", dno, GoodsCheck[0].ProductPurchaseCode, GoodsCheck[0].InventoryCode, GoodsCheck[0].InventoryName, GoodsCheck[0].Model, GoodsCheck[0].Unit, GoodsCheck[0].QualifiedQuantity,
* GoodsCheck[0].QualifiedQuantity, GoodsCheck[0].UnitPrice, GoodsCheck[0].TotalPrice, GoodsCheck[0].BatchCode, GoodsCheck[0].BillCode, MmsHelper.GetUserName(), MmsHelper.GetUserName());
*
* var res = db.Sql(insertSql).Execute();
* if (rowsAffected > 0 && res == 2)
* {
* msg = "检验记录审核成功";
* trans.Commit();
* return rowsAffected;
* }
* else
* {
* trans.Rollback();
* msg = "检验记录审核失败";
* return 0;
* }
*/
#endregion
string sqlA = string.Format(@"update QMS_GoodsCheck set BillState=2 where BillCode='{0}'", BillCode);
string bCode = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "CGRK", "", "");
DateTime newDT = DateTime.Now;
string sqlB = WinFormClientService.GetInsertSQL(new WMS_BN_BillMain()
{
ID = db.Sql("select MAX(id)+1 from WMS_BN_BillMain").QuerySingle <int>(),
BillCode = bCode,
BillType = db.Sql("SELECT Value FROM HBHC_Sys.dbo.sys_code WHERE Text='采购入库'").QuerySingle <int>(),
ContractCode = GoodsCheck[0].ContractCode,
ProjectName = GoodsCheck[0].ProjectName,
SalesmanCode = GoodsCheck[0].SalesmanCode,
Salesman = GoodsCheck[0].Salesman,
DepartmentID = GoodsCheck[0].DepartmentID,
DepartmentName = GoodsCheck[0].DepartmentName,
SupplierCode = GoodsCheck[0].SupplierCode,
SupplierName = GoodsCheck[0].SupplierName,
WarehouseCode = GoodsCheck[0].WarehouseID,
WarehouseName = GoodsCheck[0].WarehouseName,
ApproveState = "1",
OrderBillCode = GoodsCheck[0].ProductPurchaseCode,
Remark = string.Empty,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT,
IsEnable = 1
});
string sqlC = WinFormClientService.GetInsertSQL(new WMS_BN_BillDetail()
{
BillCode = bCode,
OrderBillCode = GoodsCheck[0].ProductPurchaseCode,
InventoryCode = GoodsCheck[0].InventoryCode,
InventoryName = GoodsCheck[0].InventoryName,
Specs = GoodsCheck[0].Model,
Unit = GoodsCheck[0].Unit,
MateNum = GoodsCheck[0].QualifiedQuantity,
ConfirmNum = GoodsCheck[0].QualifiedQuantity,
UnitPrice = GoodsCheck[0].UnitPrice,
TotalPrice = GoodsCheck[0].TotalPrice,
BatchCode = GoodsCheck[0].BatchCode,
PBillCode = GoodsCheck[0].BillCode,
Remark = string.Empty,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT,
IsEnable = 1
});
string sqlTemp = string.Format(@"
SELECT tbB.* FROM MES_PurchaseOrderMain tbA LEFT JOIN MES_PurchaseOrderDetail tbB ON tbA.ID = tbB.MainID AND tbB.IsEnable = 1 WHERE tbA.IsEnable = 1
AND tbB.InventoryCode = '{0}'
AND tbA.BillCode IN (
SELECT PurchaseOrderCode FROM dbo.MES_GoodsInspection WHERE IsEnable = 1 AND BillCode = '{1}'
)
", GoodsCheck[0].InventoryCode, GoodsCheck[0].PBillCode);
MES_PurchaseOrderDetail mES_PurchaseOrderDetail = db.Sql(sqlTemp).QuerySingle <MES_PurchaseOrderDetail>();
if (mES_PurchaseOrderDetail != null)
{
string sqlD = WinFormClientService.GetUpdateSQL(mES_PurchaseOrderDetail, new
{
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT,
CheckedQuantity = (mES_PurchaseOrderDetail.CheckedQuantity ?? 0) + (GoodsCheck[0].QualifiedQuantity ?? 0)
});
bool tempA = db.Sql(sqlA).Execute() > 0;
bool tempB = db.Sql(sqlB).Execute() > 0;
bool tempC = db.Sql(sqlC).Execute() > 0;
bool tempD = db.Sql(sqlD).Execute() > 0;
bool result = tempA && tempB && tempC && tempD;
if (result)
{
trans.Commit();
msg = "检验记录审核成功";
return(1);
}
else
{
trans.Rollback();
msg = "检验记录审核失败";
return(0);
}
}
else
{
trans.Rollback();
msg = "检验记录审核失败";
return(0);
}
}
}
}
public int AuditBillCode(string mainID, out string msg)
{
msg = string.Empty;
var rowsAffected = 0;
string sql = String.Format(@" select * FROM MES_PurchaseOrderMain t1 left join MES_PurchaseOrderDetail t2 on t1.ID=t2.MainID where t1.ID='{0}'", mainID);
//if sql.Contains
var resList = db.Sql(sql).QueryMany <dynamic>();
if (resList[0].BillState == 2)
{
msg = "单据已审核";
return(0);
}
else if (resList.Count == 0)
{
msg = "请先保存数据再审核";
return(0);
}
else
{
int isFalse = 0;
int res = 0;
try
{
db.UseTransaction(true);
sql = string.Format(@"update MES_PurchaseOrderMain set BillState=2 where BillCode='{0}'", resList[0].BillCode);
rowsAffected = db.Sql(sql).Execute();
if (rowsAffected > 0)
{
msg = "采购订单审核成功";
sql = String.Format(@" select t2.ID as id from MES_PurchaseOrderMain t1 left join APS_ProductPurchaseMain t2 on t1.ProductPurchaseCode=t2.PurchaseDocumentCode
where t1.ID='{0}'", mainID);
string mID = db.Sql(sql).QuerySingle <string>();
sql = "";
foreach (var item in resList)
{
res++;
sql = sql + string.Format(@" update APS_ProductPurchaseDetail set PurchaseState=2 where MainID='{0}' and InventoryCode='{1}' ", mID, item.InventoryCode);
}
rowsAffected = db.Sql(sql).Execute();
//遍历采购订单明细表，生成采购过程数据
foreach (var item in resList)
{
//item.MatchTableID
MES_BN_MatchingTableDetail MatchingTable = new MES_BN_MatchingTableDetailService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("ID", item.MatchTableID));
MatchingTable = MatchingTable ?? new MES_BN_MatchingTableDetail();
string sqlMaterial = string.Format(@" SELECT MaterialCode from dbo.PRS_Process_BOM WHERE InventoryCode='{0}' AND IsEnable=1", item.InventoryCode);
Mes_PurchaseProcess process = new Mes_PurchaseProcess();
process.ContractCode = item.ContractCode;
//process.ProductID = MatchingTable.ID ?? 0;
//process.ProductID = item.ProcessCode;
process.UserCode = item.UserCode;
if (MatchingTable.ProjectDetailID != null)
{
process.ProductID = MatchingTable.ProjectDetailID;
}
process.SaleMan = item.SaleMan;
process.InventoryCode = item.InventoryCode;
process.InventoryName = item.InventoryName;
process.Model = item.Model;
process.MaterialCode = db.Sql(sqlMaterial).QuerySingle <string>();
process.SupplierCode = item.SupplierCode;
process.Quantity = item.OrderQuantity;
process.PurchaseCode = item.BillCode;
process.PrchaseDate = item.OrderDate;
process.IsEnable = 1;
process.PlanArrivelDate = item.PlanArrivelDate;
process.CreatePerson = MmsHelper.GetUserName();
process.CreateTime = DateTime.Now;
process.ModifyPerson = MmsHelper.GetUserName();
process.ModifyTime = DateTime.Now;
var detailID = db.Insert <Mes_PurchaseProcess>("Mes_PurchaseProcess", process)
.AutoMap(x => x.ID).ExecuteReturnLastId <int>();
}
if (rowsAffected == res)
{
msg = "操作成功";
db.Commit();
return(1);
}
else
{
isFalse++;
return(0);
}
//return rowsAffected;
}
else
{
msg = "采购订单审核失败";
db.Rollback();
return(0);
}
}
catch (Exception ex)
{
msg = "采购订单审核失败";
db.Rollback();
return(0);
}
//sql = string.Format(@"update APS_ProductPurchaseMain set BillState=2 where PurchaseDocumentCode='{0}'", res.ProductPurchaseCode);
}
}
public ResultModel SaveBlankingPlanData(dynamic data)
{
try
{
//List<int> productIDs = new List<int>();
//List<int> pbomIDs = new List<int>();
//
//foreach (var item in data)
//{
// productIDs.Add(data[0].product_ID);
// pbomIDs.Add(data[0].pbom_ID);
//}
//
//List<PMS_BN_ProjectDetail> listA = db.Sql(string.Format(@"SELECT * FROM dbo.PMS_BN_ProjectDetail WHERE IsEnable = 1 AND ID IN ({0})", string.Join(",", productIDs))).QueryMany<PMS_BN_ProjectDetail>();
//List<PRS_Process_BOM> listB = db.Sql(string.Format(@"SELECT * FROM dbo.PRS_Process_BOM WHERE IsEnable = 1 AND ID IN ({0})", string.Join(",", pbomIDs))).QueryMany<PRS_Process_BOM>();
StringBuilder sb = new StringBuilder();
string savantCode = MmsHelper.GetOrderNumber("MES_SavantManage", "SavantCode", "ZJJ", "", "");
DateTime newDT = DateTime.Now;
int partTotalNum = 0;
foreach (var item in data)
{
//PMS_BN_ProjectDetail product = listA.Single(i => i.ID.Equals(item.product_ID));
//PRS_Process_BOM pbom = listB.Single(i => i.ID.Equals(item.pbom_ID));
//零件总数
partTotalNum += ((int?)item.BlankingNum ?? 0);
sb.Append(WinFormClientService.GetInsertSQL(new MES_SavantAndPBom()
{
SavantCode = savantCode,
ProcessBomID = item.pbom_ID,
BlankingNum = item.BlankingNum,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT
}));
}
string iCode = new SYS_PartService().GetSysPartAutoMaxICode("030502");
sb.Append(WinFormClientService.GetInsertSQL(new MES_SavantManage()
{
SavantCode = savantCode,
ProcessBomID = data[0].pbom_ID,
SpareMateSize = data[0].BlankingSize,
SpareMateNum = partTotalNum,//备料数量
IsEnable = 1,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT,
SplitNum = 1,//切分数量
InventoryCode = iCode
}));
sb.Append(WinFormClientService.GetInsertSQL(new SYS_Part()
{
InventoryCode = iCode,
InventoryName = data[0].SetMateName,
Model = data[0].BlankingSize,
IsEnable = 1,
CreatePerson = MmsHelper.GetUserName(),
CreateTime = newDT,
ModifyPerson = MmsHelper.GetUserName(),
ModifyTime = newDT
}));
string sql = sb.ToString();
db.UseTransaction(true);
bool result = db.Sql(sql).Execute() > 0;
if (result)
{
db.Commit();
}
else
{
db.Rollback();
}
return(new ResultModel()
{
Result = result,
Msg = result ? @"操作成功！" : @"操作失败！"
});
}
catch (Exception ex)
{
return(new ResultModel()
{
Result = false,
Msg = ex.Message
});
}
}
public int AuditBillCode(string mainID, out string msg)
{
msg = string.Empty;
var rowsAffected = 0;
string sql = String.Format(@" select BillState FROM PRS_BlankingRecord where ID='{0}'", mainID);
var state = db.Sql(sql).QuerySingle <int>();
if (state == 2)
{
msg = "单据已审核";
return(0);
}
else
{
try
{
using (db.UseTransaction(true))
{
int isFalse = 0;
sql = string.Format(@"update PRS_BlankingRecord set BillState=2 where ID='{0}'", mainID);
rowsAffected = db.Sql(sql).Execute();
if (rowsAffected > 0)
{
msg = "生产请购单据审核成功";
var pQuery = ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("MainID", mainID);
List <PRS_BlankingResult> resList = new PRS_BlankingResultService().GetModelList(pQuery);
foreach (var result in resList)
{
for (int i = 0; i < result.PartBlankingQuntity; i++)
{
pQuery = ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("MainID", result.ID);
List <PRS_BlankingPlateDetail> plateList = new PRS_BlankingPlateDetailService().GetModelList(pQuery);
foreach (var plate in plateList)
{
int res = db.Insert("Mes_BlankingResult")
.Column("BlankingResultID", plate.MainID)
.Column("BlankingQuantity", 1)
.Column("IsEnable", 1)
.Column("Ispicking", 0)
.Column("BiankingSize", plate.PlateSize)
.Column("CreateTime", DateTime.Now)
.Column("CreatePerson", MmsHelper.GetUserName())
.Column("ModifyTime", DateTime.Now)
.Column("ModifyPerson", MmsHelper.GetUserName()).Execute();
if (res <= 0)
{
isFalse++;
}
}
}
}
//return rowsAffected;
}
else
{
msg = "生产请购单据审核失败,请先保存数据后审核";
db.Rollback();
return(0);
}
if (isFalse > 0)
{
db.Rollback();
return(0);
}
else
{
db.Commit();
msg = "生产请购单据审核成功";
return(1);
}
}
}
catch
{
msg = "生产请购单据审核失败";
return(0);
}
}
}