using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using BLL;
|
using Common;
|
using Model;
|
|
namespace BLL
|
{
|
public class DALPalletBind : IDALPalletBind
|
{
|
public IList<PalBind> GetList(PalBindList ajaxPbl, ref PageInfo page)
|
{
|
try
|
{
|
StringBuilder strSql = new StringBuilder();
|
List<SqlParam> para = new List<SqlParam>();
|
strSql.Append("Select Palno,OrdNo,Statu,StatuName," +
|
"LocationCode from View_IPalletBind where DepartGuid = @DepartGuid ");
|
|
para.Add(new SqlParam("@DepartGuid", ajaxPbl.DepartGuid));
|
if (!string.IsNullOrEmpty(ajaxPbl.OrdNo))
|
{
|
strSql.Append(" and OrdNo like '%' + @OrdNo + '%' ");
|
para.Add(new SqlParam("@OrdNo", ajaxPbl.OrdNo));
|
}
|
if (!string.IsNullOrEmpty(ajaxPbl.Palno))
|
{
|
strSql.Append(" and Palno like '%' + @Palno + '%' ");
|
para.Add(new SqlParam("@Palno", ajaxPbl.Palno));
|
}
|
if (!string.IsNullOrEmpty(ajaxPbl.Statu))
|
{
|
strSql.Append(" and Statu = @Statu ");
|
para.Add(new SqlParam("@Statu", ajaxPbl.Statu));
|
}
|
if (ajaxPbl.BeginTime != DateTime.MinValue && ajaxPbl.BeginTime != null && ajaxPbl.BeginTime != DateTime.MaxValue)
|
{
|
strSql.Append(" and CreateTime >= @CreateTime1 ");
|
para.Add(new SqlParam("@CreateTime1", Convert.ToDateTime(ajaxPbl.BeginTime).ToShortDateString()));
|
}
|
if (ajaxPbl.EndTime != DateTime.MinValue && ajaxPbl.EndTime != null && ajaxPbl.EndTime != DateTime.MaxValue)
|
{
|
strSql.Append("and CreateTime <= @CreateTime2 ");
|
para.Add(new SqlParam("@CreateTime2", Convert.ToDateTime(ajaxPbl.EndTime).ToShortDateString() + " 23:59:59.999"));
|
}
|
strSql.Append(" Group By Palno,OrdNo,Statu,StatuName,LocationCode ");
|
|
SqlParam[] param = null;
|
if (para != null)
|
{
|
param = para.ToArray();
|
}
|
|
DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "OrdNo", "desc", ref page);
|
return ModelConvertHelper<PalBind>.DataTableToModel(dt);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
public bool GetPalletBind(PalBind palBind, ref IList<PalBind> lst)
|
{
|
try
|
{
|
IList<PalletBind> ls = new List<PalletBind>();
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("Select * from View_IPalletBind ");
|
strSql.Append("where Palno = @Palno and OrdNo = @OrdNo ");
|
strSql.Append("and DepartGuid = @DepartGuid ");
|
|
SqlParam[] para = new SqlParam[]
|
{
|
new SqlParam("@Palno", palBind.Palno),
|
new SqlParam("@OrdNo", palBind.OrdNo),
|
new SqlParam("@DepartGuid", palBind.DepartGuid)
|
};
|
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
|
lst = ModelConvertHelper<PalBind>.DataReaderToModel(dt);
|
|
return true;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
public PalBind GetInNoDetail(PalBind models, List<PalBind> lists)
|
{
|
try
|
{
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("select OrdNo,MatNo,LingNo,cast(CurQuant as int) as CurQuant,sum(cast(MatCount as int)) as MatCount,MatGuid ");
|
strSql.Append("from View_GetMatNum where matno = '" + models.MatNo + $"' AND DepartGuid='{models.DepartGuid}' ");
|
if (!string.IsNullOrEmpty(models.OrdNo))
|
{
|
strSql.Append(" and OrdNo = '" + models.OrdNo + "' ");
|
}
|
strSql.Append("group by OrdNo,MatNo,CurQuant,LingNo,MatGuid order by OrdNo;");
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);
|
|
PalBind pallet = new PalBind();
|
foreach (DataRow row in dt.Rows)
|
{
|
if (row["CurQuant"].ToString() == row["MatCount"].ToString())
|
{
|
continue;
|
}
|
|
string ordNo = row["OrdNo"].ToString();
|
pallet.OrdNo = ordNo;
|
pallet.CurQuant = row["CurQuant"].ToString();
|
pallet.MatNo = models.MatNo;
|
pallet.LingNo = row["LingNo"].ToString();
|
int matNoNb = int.Parse(row["CurQuant"].ToString()) - int.Parse(row["MatCount"].ToString());
|
pallet.MatCount = matNoNb.ToString();
|
pallet.MatGuid = row["MatGuid"].ToString();
|
|
// liudl 此处逻辑待确认
|
if (lists != null)
|
{
|
foreach (PalBind palBind in lists)
|
{
|
if (palBind.OrdNo == ordNo && palBind.MatNo == models.MatNo)
|
{
|
matNoNb = matNoNb + int.Parse(palBind.MatCount);
|
//matNoNb = matNoNb - int.Parse(palBind.MatCount);
|
if (matNoNb > 0)
|
{
|
pallet.MatCount = matNoNb.ToString();
|
break;
|
}
|
else
|
{
|
pallet.MatGuid = "";
|
pallet.LingNo = "";
|
pallet.CurQuant = "";
|
pallet.OrdNo = "";
|
pallet.MatCount = "";
|
matNoNb = 0;
|
break;
|
}
|
}
|
}
|
}
|
|
if (matNoNb > 0)
|
{
|
break;
|
}
|
}
|
|
return pallet;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
public bool GetErpinByMatNo(PalBind models, ref IList<PalBind> lstPd)
|
{
|
bool ret = false;
|
//try
|
//{
|
// IList<PalletBind> ls = new List<PalletBind>();
|
// StringBuilder strSql = new StringBuilder();
|
// if (string.IsNullOrEmpty(models.OrdNo))
|
// {
|
// strSql.Append("Select OrdNo, LingNo, TuNo, PageNo, CurQuant As MatCount from View_ErpInMatDetail where ");
|
// strSql.Append("MatNo = '" + models.MatNo + "' and Statu != 'ER03'");
|
// DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSql);
|
// if (dt.Rows.Count > 0)
|
// {
|
|
// for (int i = 0; i < dt.Rows.Count; i++)
|
// {
|
// //循环根据物料单号查询数量是否已经组盘完成，完成则查询此物料的下一个单号
|
// StringBuilder strhql = new StringBuilder();
|
// strhql.Append("select sum(cast(MatCount as int)) as MatCount ,OrdNo from IPalletBind where IsDel=0 and OrdNo='" + dt.Rows[i]["OrdNo"].ToString() + "' and MatNo ='" + models.MatNo + "' group by OrdNo");
|
// DataTable dd = DataFactory.SqlDataBase().GetDataTableBySQL(strhql);
|
// if (dd.Rows.Count > 0)
|
// {
|
// if (dt.Rows[i]["MatCount"].ToInt() > dd.Rows[0]["MatCount"].ToInt())
|
// {
|
// lstPd = ModelConvertHelper<PalletBind>.DataTableToModel(dt);
|
// break;
|
// }
|
// else
|
// {
|
|
// dt.Rows.RemoveAt(i);
|
// i--;
|
|
// }
|
// }
|
// else
|
// {
|
// lstPd = ModelConvertHelper<PalletBind>.DataTableToModel(dt);
|
// break;
|
// }
|
// }
|
// dt.AcceptChanges();
|
// }
|
|
// lstPd = ModelConvertHelper<PalletBind>.DataTableToModel(dt);
|
// }
|
// else
|
// {
|
// strSql.Append("Select OrdNo, LingNo, TuNo, PageNo, CurQuant As MatCount from View_ErpInMatDetail where ");
|
// strSql.Append("MatNo = @MatNo and Statu != @Statu and OrdNo = @OrdNo");
|
// SqlParam[] para = new SqlParam[]
|
// {
|
// new SqlParam("@MatNo", models.MatNo),
|
// new SqlParam("@Statu", "ER03"),
|
// new SqlParam("@OrdNo", models.OrdNo),
|
// };
|
// IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
|
// lstPd = ModelConvertHelper<PalletBind>.DataReaderToModel(dt);
|
// }
|
|
// ret = true;
|
//}
|
//catch
|
//{
|
// ret = false;
|
// throw new NotImplementedException();
|
//}
|
return true;
|
}
|
|
/// <summary>
|
/// 验证物料绑定数量是否超过入库数量
|
/// </summary>
|
/// <param name="OrdNo"></param>
|
/// <param name="MatNo">物料编码guid</param>
|
/// <param name="CurCount"></param>
|
/// <param name="BindCount"></param>
|
/// <param name="remainCount"></param>
|
/// <param name="PalletNo"></param>
|
/// <returns></returns>
|
public bool GetRemainBindCount(string OrdNo, string MatNo, ref int CurCount, ref int BindCount, ref int remainCount, string PalletNo)
|
{
|
bool bR = false;
|
try
|
{
|
//获取该物料在入库单中数量
|
StringBuilder sqlSelOrdCount = new StringBuilder();
|
sqlSelOrdCount.Append("select CurQuant from ErpinDetail where OrdNo = @OrdNo and MatNo = @MatNo");
|
SqlParam[] para = new SqlParam[]
|
{
|
new SqlParam("@OrdNo", OrdNo),
|
new SqlParam("@MatNo", MatNo),
|
};
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(sqlSelOrdCount, para);
|
OrdMatCount omc = ModelConvertHelper<OrdMatCount>.ReaderToModel(dt);
|
if (omc == null)
|
return false;
|
CurCount = int.Parse(omc.CurQuant);
|
|
//获取该物料已经绑定数量
|
StringBuilder sqlBindCount = new StringBuilder();
|
sqlBindCount.Append("select MatCount from IPalletBind where OrdNo = @OrdNo and MatGuid = @MatNo and IsDel = 0 and Palno != @PalletNo");
|
SqlParam[] para1 = new SqlParam[]
|
{
|
new SqlParam("@OrdNo", OrdNo),
|
new SqlParam("@MatNo", MatNo),
|
new SqlParam("@PalletNo", PalletNo),
|
};
|
IDataReader dt1 = DataFactory.SqlDataBase().GetDataReaderBySQL(sqlBindCount, para1);
|
IList<PalBind> lstCount = new List<PalBind>();
|
lstCount = ModelConvertHelper<PalBind>.DataReaderToModel(dt1);
|
for (int i = 0; i < lstCount.Count; i++)
|
{
|
BindCount += int.Parse(lstCount[i].MatCount);
|
|
}
|
//获取当前绑定数量（修改绑定时考虑）
|
remainCount = CurCount - BindCount;
|
|
}
|
catch (Exception ex)
|
{
|
bR = false;
|
throw ex;
|
}
|
return bR;
|
}
|
|
public bool Add(PalBind model, List<PalBind> lst)
|
{
|
bool result = false;
|
try
|
{
|
if (lst.Count > 0)
|
{
|
return false;
|
}
|
|
int _ret = DataFactory.SqlDataBase().DeleteData("IPalletBind", "Palno", lst[0].Palno);
|
if (_ret < 0)
|
{
|
return false;
|
}
|
StringBuilder strSqlTime = new StringBuilder();
|
strSqlTime.Append("SELECT GETDATE() as time");
|
var dtTime = DataFactory.SqlDataBase().GetDataTableBySQL(strSqlTime);
|
model.CreateTime = DateTime.Parse(dtTime.Rows[0][0].ToString());
|
List<SqlParam> para = new List<SqlParam>();
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append(" Insert into IPalletBind (PalletNo,MatNo,MatCount,GoodsPos,Statu,LingNo,TuNo,PageNo,CreateUser,CreateTime,Demo,Addre,IsDel,OrdNo) values ");
|
for (int i = 0; i < lst.Count; i++)
|
{
|
string Statu = "1";
|
if (lst[i].LocationCode != null)
|
{
|
if (lst[i].LocationCode.Length > 10) // 指定货位单据状态为正在执行
|
{
|
Statu = "2";
|
|
DAL.DAL_Pub pub = new DAL.DAL_Pub();
|
StringBuilder sqlStr = new StringBuilder();
|
sqlStr.Append("select count(*) from WH_CMD where palno = '" + lst[i].Palno + "'");
|
sqlStr.Append(" and CMDStatu = '2' and IsDel = '0';");
|
DataTable whdt = DataFactory.SqlDataBase().GetDataTableBySQL(sqlStr);
|
if (whdt.Rows[0][0].ToString() == "0")
|
{
|
// 生成指令
|
sqlStr.Clear();
|
sqlStr.Append("INSERT INTO WH_CMD(TaskID,Palno,Height,CMDType,OldAddre,CMDStatu,CreateUser,IsDel)");
|
sqlStr.Append("VALUES ('" + lst[i].OrdNo + "','" + lst[i].Palno + "','200','in','");
|
sqlStr.Append(lst[i].LocationCode + "','2','" + model.CreatUser + "','0');");
|
DataFactory.SqlDataBase().ExecuteBySql(sqlStr);
|
|
// 更改库位状态
|
pub.UpdateLocationState(lst[i].Palno, "03");
|
}
|
|
// 更改入库单状态
|
sqlStr.Clear();
|
sqlStr.Append("Update Erp_in set Statu = '02' where Ordno='" + lst[i].OrdNo + "';");
|
DataFactory.SqlDataBase().ExecuteBySql(sqlStr);
|
}
|
}
|
|
strSql.Append("(@PalletNo" + i + ",");
|
para.Add(new SqlParam("@PalletNo" + i, lst[i].Palno));
|
strSql.Append("@MatNo" + i + ",");
|
para.Add(new SqlParam("@MatNo" + i, lst[i].MatNo));
|
strSql.Append("@MatCount" + i + ",");
|
para.Add(new SqlParam("@MatCount" + i, lst[i].MatCount));
|
strSql.Append("@Statu" + i + ",");
|
para.Add(new SqlParam("@Statu" + i, Statu));
|
strSql.Append("@LingNo" + i + ",");
|
para.Add(new SqlParam("@LingNo" + i, lst[i].LingNo));
|
strSql.Append("@CreateUser" + i + ",");
|
para.Add(new SqlParam("@CreateUser" + i, model.CreatUser));
|
strSql.Append("@CreateTime" + i + ",");
|
para.Add(new SqlParam("@CreateTime" + i, model.CreateTime));
|
strSql.Append("@Demo" + i + ",");
|
para.Add(new SqlParam("@Demo" + i, model.Demo));
|
strSql.Append("@Addre" + i + ",");
|
para.Add(new SqlParam("@Addre" + i, lst[i].LocationCode));
|
strSql.Append("@IsDel" + i + ",");
|
para.Add(new SqlParam("@IsDel" + i, 0));
|
strSql.Append("@OrdNo" + i + "),");
|
para.Add(new SqlParam("@OrdNo" + i, lst[i].OrdNo));
|
}
|
|
SqlParam[] param = null;
|
if (para != null)
|
{
|
strSql.Remove(strSql.Length - 1, 1);
|
param = para.ToArray();
|
}
|
|
int dt = DataFactory.SqlDataBase().ExecuteBySql(strSql, param);
|
|
if (dt > -1) result = true;
|
|
return result;
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
|
public bool UpdateErpinStatus(string OrderNo, string Statu)
|
{
|
try
|
{
|
bool bl = false;
|
StringBuilder strSQL = new StringBuilder();
|
Hashtable ht = new Hashtable();
|
|
ht["Statu"] = "'" + Statu + "'";
|
int ret = DataFactory.SqlDataBase().UpdateByHashtable("Erp_in", "Ordno", "'" + OrderNo + "'", ht);
|
if (ret > 0)
|
{
|
bl = true;
|
}
|
|
return bl;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
public string SetPalBinds(string uesrCode, string departGuid, List<PalBind> palBinds)
|
{
|
try
|
{
|
string strMessage = "";
|
int rowCount = 0;
|
//StringBuilder strSqlTime = new StringBuilder();
|
//strSqlTime.Append("SELECT GETDATE() as time");
|
//var dtTime = DataFactory.SqlDataBase().GetDataTableBySQL(strSqlTime);
|
//var creatTime = DateTime.Parse(dtTime.Rows[0][0].ToString());
|
foreach (PalBind pal in palBinds)
|
{
|
StringBuilder sqlString = new StringBuilder();
|
if (string.IsNullOrEmpty(pal.Guid))
|
{
|
// 新增编码绑定信息
|
Hashtable htitems = new Hashtable();
|
htitems.Add("OrdNo", "'" + pal.OrdNo + "'");
|
htitems.Add("Palno", "'" + pal.Palno + "'");
|
htitems.Add("MatGuid", "'" + pal.MatGuid + "'");
|
htitems.Add("MatNo", "'" + pal.MatNo + "'");
|
htitems.Add("MatCount", "'" + pal.MatCount + "'");
|
htitems.Add("LocationCode", "'" + pal.LocationCode + "'");
|
htitems.Add("Statu", "'01'");
|
htitems.Add("Demo", "'" + pal.Demo + "'");
|
htitems.Add("DepartGuid", "'" + departGuid + "'");
|
htitems.Add("CreateUser", "'" + uesrCode + "'");
|
htitems.Add("CreateTime", "GETDATE()");
|
int num = DataFactory.SqlDataBase().InsertByHashtableNullParam("IPalletBind", htitems);
|
|
if (pal.LocationCode != null && pal.LocationCode != "")
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["TurnoverDemand"] = "'03'";
|
int ret = DataFactory.SqlDataBase().UpdateByHashtable("DepotsLocation", "LocationCode", "'" + pal.LocationCode + "'", ht);
|
}
|
|
if (num > 0)
|
{
|
rowCount += num;
|
}
|
else
|
{
|
strMessage += pal.MatNo + "物料绑定失败!";
|
}
|
}
|
else
|
{
|
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select * from IPalletBind where IsDel = 0 and Statu = '01' and palno = '"+pal.Palno+"'");
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
|
foreach (DataRow dr in dt.Rows)
|
{
|
Hashtable htitems2 = new Hashtable();
|
if (dr["OrdNo"].ToString() != pal.OrdNo)
|
{
|
htitems2.Clear();
|
htitems2.Add("LocationCode", "'" + pal.LocationCode + "'");
|
string guid2 = "'" + dr["Guid"].ToString() + "'";
|
|
int num2 = DataFactory.SqlDataBase().UpdateByHashtable("IPalletBind", "Guid", guid2, htitems2);
|
|
if (num2 > 0)
|
{
|
// 修改入库单状态
|
this.UpdateErpinStatus(dr["OrdNo"].ToString(), "02");
|
}
|
}
|
|
if (dr["OrdNo"].ToString() == pal.OrdNo)
|
{
|
if (pal.LocationCode != null && pal.LocationCode != "")
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["TurnoverDemand"] = "'03'";
|
int ret = DataFactory.SqlDataBase()
|
.UpdateByHashtable("DepotsLocation", "LocationCode", "'" + pal.LocationCode + "'", ht);
|
|
|
}
|
else
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["TurnoverDemand"] = "'01'";
|
int ret = DataFactory.SqlDataBase()
|
.UpdateByHashtable("DepotsLocation", "LocationCode", "'" + dr["LocationCode"].ToString() + "'", ht);
|
}
|
}
|
}
|
// 维护编码绑定信息
|
Hashtable htitems = new Hashtable();
|
htitems.Add("OrdNo", "'" + pal.OrdNo + "'");
|
htitems.Add("Palno", "'" + pal.Palno + "'");
|
htitems.Add("MatGuid", "'" + pal.MatGuid + "'");
|
htitems.Add("MatNo", "'" + pal.MatNo + "'");
|
htitems.Add("MatCount", "'" + pal.MatCount + "'");
|
htitems.Add("LocationCode", "'" + pal.LocationCode + "'");
|
htitems.Add("Demo", "'" + pal.Demo + "'");
|
htitems.Add("DepartGuid", "'" + departGuid + "'");
|
htitems.Add("UpdateTime", "getdate()");
|
htitems.Add("UpdateUser", "'" + uesrCode + "'");
|
string guid = "'" + pal.Guid + "'";
|
|
int num = DataFactory.SqlDataBase().UpdateByHashtable("IPalletBind", nameof(pal.Guid), guid, htitems);
|
|
if (num > 0)
|
{
|
rowCount += num;
|
}
|
else
|
{
|
strMessage += pal.MatNo + "物料编辑失败!";
|
}
|
}
|
if (rowCount > 0)
|
{
|
// 修改入库单状态
|
this.UpdateErpinStatus(pal.OrdNo, "02");
|
}
|
}
|
return strMessage;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
public string DelPalBind(string userCode, string palno, string ordNo, string LocationCode)
|
{
|
try
|
{
|
string strMessage = "";
|
// 验证组盘单状态
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select isnull(max(statu),'-1') as statu from View_IPalletBind ");
|
stringBuilder.Append("where Palno = '" + palno + "' and OrdNo = '" + ordNo + "';");
|
DataRow row = DataFactory.SqlDataBase().GetDataRowBySQL(stringBuilder);
|
if (row["statu"].ToString() != "01")
|
{
|
strMessage = "单据状态变更，删除失败!";
|
}
|
else
|
{
|
stringBuilder.Clear();
|
stringBuilder.Append("Update IPalletBind set IsDel = '1',UpdateUser ='" + userCode + "',UpdateTime = getDate() ");
|
stringBuilder.Append("where isDel = '0' and statu = '01' and Palno = '" + palno + "' and OrdNo = '" + ordNo + "';");
|
int rowCount = DataFactory.SqlDataBase().ExecuteBySql(stringBuilder);
|
if (rowCount > 0)
|
{
|
stringBuilder.Clear();
|
stringBuilder.Append("select count(*) from IPalletBind where isdel = '0' and OrdNo = '" + ordNo + "';");
|
DataRow rows = DataFactory.SqlDataBase().GetDataRowBySQL(stringBuilder);
|
if (rows != null && rows[0].ToString() == "0")
|
{
|
this.UpdateErpinStatus(ordNo, "01");
|
}
|
|
stringBuilder.Clear();
|
stringBuilder.Append("select * from IPalletBind where IsDel = 0 and Statu = '01' and palno = '" + palno + "'");
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
|
if (dt.Rows.Count <= 0)
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["TurnoverDemand"] = "'01'";
|
int ret = DataFactory.SqlDataBase()
|
.UpdateByHashtable("DepotsLocation", "LocationCode", "'" + LocationCode + "'", ht);
|
}
|
}
|
else
|
{
|
strMessage = "单据状态变更，删除失败!";
|
}
|
}
|
|
return strMessage;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
public void DelPalBindDetail(string userCode, string guid, string ordNo)
|
{
|
try
|
{
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("Update IPalletBind set IsDel = '1',UpdateUser ='" + userCode + "',UpdateTime = getDate() ");
|
stringBuilder.Append("where isDel = '0' and guid = '" + guid + "';");
|
int rowCount = DataFactory.SqlDataBase().ExecuteBySql(stringBuilder);
|
if (rowCount > 0)
|
{
|
stringBuilder.Clear();
|
stringBuilder.Append("select count(*) from IPalletBind where isdel = '0' and OrdNo = '" + ordNo + "';");
|
DataRow rows = DataFactory.SqlDataBase().GetDataRowBySQL(stringBuilder);
|
if (rows != null && rows[0].ToString() == "0")
|
{
|
this.UpdateErpinStatus(ordNo, "01");
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
|
|
|
|
|
|
|
|
public bool GetPalletBind(string PalletNo, ref IList<PalletBind> lst)
|
{
|
bool ret = false;
|
try
|
{
|
IList<PalletBind> ls = new List<PalletBind>();
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("Select * from View_IPalletBindDetail where ");
|
strSql.Append("PalletNo = @PalletNo");
|
|
SqlParam[] para = new SqlParam[]
|
{
|
new SqlParam("@PalletNo", PalletNo),
|
};
|
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
|
|
lst = ModelConvertHelper<PalletBind>.DataReaderToModel(dt);
|
|
ret = true;
|
}
|
catch
|
{
|
ret = false;
|
throw new NotImplementedException();
|
}
|
return ret;
|
}
|
|
public bool GetOrderMatByMatNoAndOrd(string OrdNo, string MatNo, ref ErpInDetail eid)
|
{
|
bool br = true;
|
try
|
{
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.Append("select OrdNo, MatNo, MatName, CurQuant, LingNo, TuNo, PageNo, Demo from View_ErpInDetail where ");
|
if (!string.IsNullOrEmpty(OrdNo))
|
{
|
strSQL.Append("OrdNo = '");
|
strSQL.Append(OrdNo);
|
strSQL.Append("' and MatNo = '");
|
strSQL.Append(MatNo);
|
strSQL.Append("'");
|
}
|
else
|
{
|
strSQL.Append(" MatNo = '");
|
strSQL.Append(MatNo);
|
strSQL.Append("'");
|
}
|
|
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSQL);
|
if (dt != null)
|
{
|
List<ErpInDetail> ls = new List<ErpInDetail>();
|
ls = (List<ErpInDetail>)ModelConvertHelper<ErpInDetail>.DataReaderToModel(dt);
|
eid = ls[0];
|
br = true;
|
}
|
}
|
catch (Exception ex)
|
{
|
br = false;
|
}
|
return br;
|
}
|
|
public bool IsPalletUsing(string PalletNo)
|
{
|
bool br = false;
|
StringBuilder strSQL = new StringBuilder();
|
|
// 判断组盘中是否存在 组盘是否已使用
|
//strSQL.Append("select 1 from IPalletBind where Palno = '");
|
//strSQL.Append(PalletNo);
|
//strSQL.Append("' and IsDel = 0 and Statu <> '03'");
|
|
//DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSQL);
|
//if (dt != null && dt.Rows.Count > 0)
|
//{
|
// br = true;
|
//}
|
|
strSQL.Clear();
|
strSQL.Append("select 1 from IPalletEmptyIn where Palno = '");
|
strSQL.Append(PalletNo);
|
strSQL.Append("' and IsDel = 0 and Statu <> '03' and Statu <> '01'");
|
|
DataTable dt2 = DataFactory.SqlDataBase().GetDataTableBySQL(strSQL);
|
if (dt2 != null && dt2.Rows.Count > 0)
|
{
|
br = true;
|
}
|
|
// 判断库中是否存在 是否已使用
|
strSQL.Clear();
|
strSQL.Append("select TurnoverDemand from DepotsLocation where LocationCode in (");
|
strSQL.Append("select LocationCode from log_Store where Palno = '" + PalletNo + "' AND IsDel=0)");
|
DataTable dtt = DataFactory.SqlDataBase().GetDataTableBySQL(strSQL);
|
if (dtt != null && dtt.Rows.Count > 0)
|
{
|
string tDemand = dtt.Rows[0][0].ToString();
|
if (tDemand == "02" || tDemand == "04")
|
{
|
br = true;
|
}
|
}
|
|
return br;
|
}
|
|
//private bool UpdatePalletBind(string PalletNo)
|
//{
|
// return true;
|
//}
|
|
//private bool UpdateLogStore(string PalletNo)
|
//{
|
// return true;
|
//}
|
|
//private bool UpdateLogDetail(string PalletNo)
|
//{
|
// return true;
|
//}
|
|
public bool UpdateErpinByPalletNo(IList<ErpIn> lst)
|
{
|
bool r = true;
|
|
try
|
{
|
for (int i = 0; i < lst.Count; i++)
|
{
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.Append("select * from IPalletBind where OrdNo = '");
|
strSQL.Append(lst[i].OrdNo);
|
strSQL.Append("' and IsDel = 0");
|
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSQL);
|
if (dt != null)
|
{
|
if (dt.Rows.Count == 0)
|
UpdateErpinStatus(lst[i].OrdNo, "01");
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
return false;
|
}
|
return r;
|
}
|
|
public bool GetPalletBindStatus(string PalletNo, string status)
|
{
|
bool r = false;
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.Append("select * from View_IPalletBind where PalletNo = '");
|
strSQL.Append(PalletNo);
|
strSQL.Append("' and Statu = '");
|
strSQL.Append(status);
|
strSQL.Append("'");
|
|
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(strSQL);
|
if (dt == null)
|
{
|
return false;
|
}
|
if (dt.Rows.Count > 0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
|
//public bool GetIPalletEmptyInCount(string Palno)
|
//{
|
// try
|
// {
|
// IList<PalletBind> ls = new List<PalletBind>();
|
// StringBuilder strSql = new StringBuilder();
|
// strSql.Append("select * from IPalletBind ");
|
// strSql.Append("where Palno = @Palno and OrdNo = @OrdNo ");
|
// strSql.Append("and DepartGuid = @DepartGuid ");
|
|
// SqlParam[] para = new SqlParam[]
|
// {
|
// new SqlParam("@Palno", palBind.Palno),
|
// new SqlParam("@OrdNo", palBind.OrdNo),
|
// new SqlParam("@DepartGuid", palBind.DepartGuid)
|
// };
|
|
// IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
|
// lst = ModelConvertHelper<PalBind>.DataReaderToModel(dt);
|
|
// return true;
|
// }
|
// catch (Exception ex)
|
// {
|
// throw ex;
|
// }
|
//}
|
}
|
}
|
