public bool UpdateBase(FeedbackBase BaseInfo, SqlTransaction tran)
{
string strsql = @"update ZL_FeedbackBase set WorkProcedure=@WorkProcedure,
BatchNo=BatchNo,Model=@Model,Qty=@Qty,EquipmentName=@EquipmentName,EquipmentNo=@EquipmentNo,FeedbackMan=@FeedbackMan
where OrderNo=@OrderNo";
if (_sqlconnnect.Execute(strsql, BaseInfo, tran) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddFeedbackBase(FeedbackBase baseInfo, SqlTransaction tran)
{
string strsql = @"insert into ZL_FeedbackBase(OrderNo,WorkProcedure,BatchNo,Model,Qty,EquipmentName,
EquipmentNo,FeedbackMan,FeedbackTime,Status,ProblemLevel,ProductClass) values(@OrderNo,@WorkProcedure,@BatchNo,@Model,@Qty,@EquipmentName,
@EquipmentNo,@FeedbackMan,@FeedbackTime,@Status,@ProblemLevel,@ProductClass)";
int iResult = _sqlconnnect.Execute(strsql, baseInfo, tran);
if (iResult > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert(FeedbackBase baseInfo, SqlTransaction tran)
{
string strsql = @"
insert into ZL_FeedbackBase(ID,OrderNo,WorkProcedure,BatchNo,Model,Qty,EquipmentName,
EquipmentNo,FeedbackMan,FeedbackTime,Status,ProblemLevel,ProductClass,OrderType,Measure,Report,
TechnologistMembers,EmployeeID,ImageList,ImageHtml)
values(@ID,@OrderNo,@WorkProcedure,@BatchNo,@Model,@Qty,@EquipmentName,
@EquipmentNo,@FeedbackMan,@FeedbackTime,@Status,@ProblemLevel,@ProductClass,
@OrderType,@Measure,@Report,@TechnologistMembers,@EmployeeID,@ImageList,@ImageHtml)";
int iResult = _sqlconnnect.Execute(strsql, baseInfo, tran);
if (iResult > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateBase(FeedbackBase BaseInfo, SqlTransaction tran)
{
return(_repository.UpdateBase(BaseInfo, tran));
}
public bool Insert(FeedbackBase baseInfo, SqlTransaction tran)
{
return(_repository.Insert(baseInfo, tran));
}
public bool AddFeedbackBase(FeedbackBase baseInfo, SqlTransaction tran)
{
return(_repository.AddFeedbackBase(baseInfo, tran));
}
public Object AddFeedback([FromBody] FeedbackData PostData)
{
ResultData result = new ResultData();
using (SqlConnection sqlconnection = new SqlConnection(conString))
{
bool flag = true;
FeedbackBaseService service = new FeedbackBaseService(sqlconnection);
List <FeedbackBase> BaseList = service.GetOrderInfoByWhere(" where OrderNo='" + PostData.OrderNo + "'");
if (sqlconnection.State == ConnectionState.Closed)
{
sqlconnection.Open();
}
SqlTransaction transaction = sqlconnection.BeginTransaction();
try
{
FeedbackBase feedbackbase = new FeedbackBase();
feedbackbase.OrderNo = PostData.OrderNo;
feedbackbase.Model = PostData.Model;
feedbackbase.FeedbackMan = PostData.FeedbackMan;
//feedbackbase.FeedbackTime = DateTime.Now;
feedbackbase.Qty = PostData.Qty;
feedbackbase.WorkProcedure = PostData.WorkProcedure;
feedbackbase.BatchNo = PostData.BatchNo;
feedbackbase.EquipmentName = PostData.EquipmentName;
feedbackbase.EquipmentNo = PostData.EquipmentNo;
feedbackbase.ProductClass = PostData.ProductClass;
if (PostData.FeedbackTime == "")
{
feedbackbase.FeedbackTime = DateTime.Now;
}
else
{
feedbackbase.FeedbackTime = Convert.ToDateTime(PostData.FeedbackTime);
}
feedbackbase.Status = PostData.Status;
feedbackbase.ProblemLevel = PostData.ProblemLevel;
//FeedbackBaseService service = new FeedbackBaseService(sqlconnection);
//List<FeedbackBase> BaseList= service.GetOrderInfoByWhere(" where OrderNo='" + PostData.OrderNo + "'",transaction);
if (BaseList != null && BaseList.Count > 0)
{
flag = service.Delete(PostData.OrderNo, transaction);
}
if (!Directory.Exists(SavePath))
{
Directory.CreateDirectory(SavePath);
}
if (service.AddFeedbackBase(feedbackbase, transaction))
{
FeedbackExProblemService PService = new FeedbackExProblemService(sqlconnection);
FeedbackExReasonService RService = new FeedbackExReasonService(sqlconnection);
BllProductCard BllCard = new BllProductCard(sqlconnection);
FeedbackExProblem Problem = new FeedbackExProblem();
FeedbackExReason Reason = new FeedbackExReason();
foreach (var list in PostData.ReasonData)
{
if (list.ReasonType != "" && list.ReasonDetails != "")
{
Reason.ReasonType = list.ReasonType;
Reason.ReasonDetails = list.ReasonDetails;
Reason.OrderNo = PostData.OrderNo;
if (!RService.AddReason(Reason, transaction))
{
flag = false;
break;
}
}
}
foreach (var list in PostData.ProblemData)
{
if (list.CodeString != "" || list.PicturePath != "" || list.ProblemDetails != "")
{
Problem.CodeString = list.CodeString;
Problem.OrderNo = PostData.OrderNo;
string PicturePath = list.PicturePath;
string filePath = "";
if (PicturePath != "" && PicturePath != null)
{
var chrPath = PicturePath.Split('|');
for (int iPath = 0; iPath < chrPath.Length; iPath++)
{
if (chrPath[iPath].Contains("base64"))
{
SaveImage save = new SaveImage();
string fileName = DateTime.Now.Ticks.ToString();
save.SaveInageForBase(chrPath[iPath].Split(',')[1], SavePath, fileName);
filePath = filePath + "ProblemPicture/" + fileName + ".png" + ",";
}
else if (chrPath[iPath] != "")
{
string tempPath = "";
for (var i = 0; i < chrPath[iPath].Split('/').Length; i++)
{
if (i >= 3)
{
tempPath = tempPath + chrPath[iPath].Split('/')[i] + "/";
}
}
if (tempPath != "")
{
tempPath = tempPath.Substring(0, tempPath.LastIndexOf("/"));
filePath = filePath + tempPath + ",";
}
}
}
}
if (filePath != "")
{
filePath = filePath.Substring(0, filePath.LastIndexOf(","));
}
Problem.PicturePath = filePath;
Problem.ProblemDetails = list.ProblemDetails;
if (!PService.AddProblem(Problem, transaction))
{
flag = false;
break;
}
}
}
foreach (var list in PostData.CardList)
{
list.FKOrderNo = PostData.OrderNo;
if (!BllCard.InsertCard(list, transaction))
{
flag = false;
break;
}
}
if (PostData.IfQC)
{
FeedbackExHandleService BllHandler = new FeedbackExHandleService(sqlconnection);
FeedbackExHandle Handler = new FeedbackExHandle();
Handler.HandleMan = PostData.HandleMan;
Handler.HandleNote = PostData.HandleNote;
Handler.HandleSuggestion = PostData.HandleSuggestion;
Handler.HandleTime = DateTime.Now;
Handler.QualityClass = PostData.QualityClass;
Handler.OrderNo = PostData.OrderNo;
if (!BllHandler.AddHandle(Handler, transaction))
{
flag = false;
}
}
if (flag)
{
transaction.Commit();
result.ErrMsg = "";
result.Result = true;
return(result);
}
else
{
transaction.Rollback();
result.ErrMsg = "反馈失败";
result.Result = false;
return(result);
}
}
else
{
transaction.Rollback();
result.ErrMsg = "反馈失败";
result.Result = false;
return(result);
}
}
catch (Exception ex)
{
transaction.Rollback();
result.Result = false;
if (ex.Message.Contains("重复键"))
{
result.ErrMsg = "已存在相同的单号，编码不能重复添加";
}
else
{
result.ErrMsg = ex.Message;
}
return(result);
}
}
}
public Object InsertOrder(OrderInfo PostData)
{
ResultData result = new ResultData();//返回数据类型
SqlConnection con = new SqlConnection(conString);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
//验证是否已存在该单号的单据，存在删除，再添加，不存在直接添加
bool Delete = false;//false：不存在，true：存在
string OrderNo = PostData.OrderNo != null? PostData.OrderNo:"";
OrderNo = OrderNo.Trim();
FeedbackBaseService BllBase = new FeedbackBaseService(con);
Guid NewID = BllBase.GetNewID();
FeedbackBase Base = BllBase.GetOrderInfoByWhere(" where OrderNo='" + OrderNo + "'").FirstOrDefault();
if (Base != null)
{
Delete = true;
}
SqlTransaction tran = con.BeginTransaction();
try
{
if (Delete)
{
if (!BllBase.Delete(OrderNo, tran))//删除旧单据
{
result.ErrMsg = "提交失败，原因：删除原始信息异常";
result.Result = false;
return(result);
}
}
//定义保存的数据
string EmployeeID = PostData.EmployeeID;
FeedbackBase Domain = new FeedbackBase();
Domain.ID = NewID;
Domain.OrderNo = OrderNo;//单号，控制表以KZ开头，反馈单已FK开头
Domain.BatchNo = PostData.BatchNo;
Domain.Model = PostData.Model;
Domain.Qty = PostData.Qty;
Domain.Status = "0";//默认T1顺序审批人
Domain.WorkProcedure = PostData.WorkProcedure;
Domain.EquipmentName = PostData.EquipmentName;
Domain.EquipmentNo = PostData.EquipmentNo;
Domain.FeedbackMan = PostData.FeedbackMan;
Domain.ProblemLevel = PostData.ProblemLevel;//审批流程代号
Domain.ImageList = PostData.ImageList;
Domain.ImageHtml = PostData.ImageHtml;
if (PostData.FeedbackTime == null || PostData.FeedbackTime == "")
{
PostData.FeedbackTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
Domain.FeedbackTime = Convert.ToDateTime(PostData.FeedbackTime);
Domain.ProductClass = PostData.ProductClass;
int OrderType = 0;
int FlowTempId = 1;
if (OrderNo.StartsWith("FK"))
{
FlowTempId = 0;
OrderType = 0;
}
else
{
FlowTempId = 1;
OrderType = 1;
}
Domain.OrderType = OrderType;
Domain.Measure = PostData.Measure != null ? PostData.Measure : "";
Domain.Report = PostData.Report != null ? PostData.Report : "";
Domain.EmployeeID = EmployeeID;
List <ProductCard.CardInfo> CardList = PostData.CardList;
List <OrderReason> ReasonData = PostData.ReasonData;
List <OrderProblem> ProblemData = PostData.ProblemData;
#region ======Post请求：录入审批系统=====
//GeneralMethod Method = new GeneralMethod();
string title = "";
if (FlowTempId == 1)
{
title = "质量控制流程(" + OrderNo + ")";
}
else
{
title = "质量反馈流程(" + OrderNo + ")";
}
string urls = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("host.json", optional: true).Build().GetSection("ApprovalPostAddress").Value;
using (HttpClient Client = new HttpClient())
{
var values = new List <KeyValuePair <string, string> >();
values.Add(new KeyValuePair <string, string>("Title", title));
values.Add(new KeyValuePair <string, string>("InstanceID", NewID.ToString()));
values.Add(new KeyValuePair <string, string>("FlowID", "D3BBCCBF-8968-4833-8A0F-CE5B19B718E2"));
values.Add(new KeyValuePair <string, string>("Account", EmployeeID));
values.Add(new KeyValuePair <string, string>("WorkProcedure", PostData.WorkProcedure));
var content = new FormUrlEncodedContent(values);
var response = Client.PostAsync(urls, content);
response.Wait();
HttpResponseMessage resp = response.Result;
var res2 = resp.Content.ReadAsStringAsync();
res2.Wait();
string Message = res2.Result;
JObject Robj = JObject.Parse(Message);
if (Robj["result"].ToString() == "1")
{
Domain.TechnologistMembers = Robj["msg"].ToString();
}
else
{
Exception ex = new Exception(Robj["msg"] + "(远端接入失败)");
throw ex;
}
}
#endregion
if (BllBase.Insert(Domain, tran))
{
FeedbackExProblemService BllProblem = new FeedbackExProblemService(con);
FeedbackExReasonService BllReason = new FeedbackExReasonService(con);
BllProductCard BllCard = new BllProductCard(con);
for (int i = 0; i < ProblemData.Count; i++)
{
FeedbackExProblem Problem = new FeedbackExProblem();
Problem.OrderNo = OrderNo;
Problem.CodeString = ProblemData[i].codeString;
Problem.TopClass = ProblemData[i].topClass;
Problem.RoomName = ProblemData[i].roomName;
Problem.Problem = ProblemData[i].problem;
Problem.TypeName = ProblemData[i].typeName;
Problem.Present = ProblemData[i].present;
Problem.ProblemDetails = ProblemData[i].problemDetails;
Problem.Suggestion = ProblemData[i].suggestion;
Problem.QualityClass = ProblemData[i].qualityClass;
Problem.ProblemLevel = ProblemData[i].problemLevel;
if (ProblemData[i].suggestion != "" && ProblemData[i].suggestion != null && ProblemData[i].suggestion.Contains("suggestion"))
{
JArray JList = JArray.Parse(ProblemData[i].suggestion);
foreach (var node in JList)
{
string suggestion = node["suggestion"].ToString();
if (!BllBase.InsertOrderSuggestion(tran, suggestion, OrderNo, ProblemData[i].codeString))
{
Exception ex = new Exception("提交失败，原因：保存质量问题编码处理意见失败");
throw ex;
}
}
}
if (!BllProblem.AddProblem(Problem, tran))
{
Exception ex = new Exception("提交失败，原因：质量问题提交异常");
throw ex;
}
}
for (int i = 0; i < ReasonData.Count; i++)
{
FeedbackExReason Reason = new FeedbackExReason();
Reason.OrderNo = OrderNo;
Reason.ReasonDetails = ReasonData[i].reasonDetails;
Reason.ReasonType = ReasonData[i].reasonType;
if (!BllReason.AddReason(Reason, tran))
{
Exception ex = new Exception("提交失败，原因：原因分析提交异常");
throw ex;
}
}
foreach (var node in CardList)
{
node.FKOrderNo = OrderNo;
if (!BllCard.InsertCard(node, tran))
{
Exception ex = new Exception("提交失败，原因：客户信息提交异常");
throw ex;
}
}
tran.Commit();
result.Result = true;
result.ErrMsg = "提交成功";
}
else
{
result.Result = false;
result.ErrMsg = "提交失败，原因：基础信息提交异常";
BllBase.DeleteWorkFlowTask(NewID.ToString(), tran);
tran.Commit();
}
return(result);
}
catch (Exception ex)
{
tran.Rollback();
tran.Dispose();
try
{
BllBase.DeleteWorkFlowTask(NewID.ToString());
}
catch (Exception ex2)
{
}
result.Result = false;
result.ErrMsg = ex.Message;
return(result);
}
finally
{
con.Close();
}
}