private void PublishUnpublish(long id, AvrTreeElementType type, bool isPublish)
{
switch (type)
{
case AvrTreeElementType.Query:
using (var service = new Query_DB())
{
service.PublishUnpublish(id, isPublish);
}
break;
case AvrTreeElementType.Layout:
using (var service = new WebLayoutDB())
{
service.PublishUnpublish(id, isPublish);
}
break;
case AvrTreeElementType.Folder:
using (var service = new Folder_DB())
{
service.PublishUnpublish(id, isPublish);
}
break;
default:
throw new AvrException("Unsupported AvrTreeElementType " + type);
}
}
private QueryFilterControl CreateFilterControl(string lang = "en")
{
DbManagerFactory.SetSqlFactory(Config.GetSetting("EidssConnectionString"));
ConnectionManager.DefaultInstance.SetCredentials(Config.GetSetting("EidssConnectionString"));
EidssUserContext.Init();
context = ModelUserContext.Instance as EidssUserContext;
Security = new EidssSecurityManager();
int result = Security.LogIn(Organizaton, Admin, AdminPassword);
Assert.AreEqual(0, result);
EIDSS_LookupCacheHelper.Init();
EidssUserContext.CurrentLanguage = lang;
var queryDb = new Query_DB();
var querySearchObjectDb = new QuerySearchObject_DB();
var queryDs = queryDb.LoadDetailData(QueryId);
DataRow row = queryDs.Tables[Query_DB.TasQueryObjectTree].Rows[0];
var searchObjectsDs = querySearchObjectDb.LoadDetailData(row["idfQuerySearchObject"]);
var form = new Form();
var filter = new QueryFilterControl {
Parent = form, Dock = DockStyle.Fill
};
filter.Init();
filter.Bind((long)queryDs.Tables[1].Rows[0]["idfQuerySearchObject"], searchObjectsDs);
return(filter);
}
private QueryFilterControl CreateFilterControl(string lang = "en")
{
var queryDb = new Query_DB();
var querySearchObjectDb = new QuerySearchObject_DB();
DataSet queryDs = queryDb.LoadDetailData(QueryId);
DataRow row = queryDs.Tables[Query_DB.TasQueryObjectTree].Rows[0];
DataSet searchObjectsDs = querySearchObjectDb.LoadDetailData(row["idfQuerySearchObject"]);
var form = new Form();
var filter = new QueryFilterControl {
Parent = form, Dock = DockStyle.Fill
};
filter.Init();
filter.Bind((long)queryDs.Tables[1].Rows[0]["idfQuerySearchObject"], searchObjectsDs);
return(filter);
}
//保存盘点单
public JsonResult SaveCheck(T_StockInfoEX model)
{
try
{
if (string.IsNullOrEmpty(model.WarehouseNo))
{
return(Json(new { state = false }, JsonRequestBehavior.AllowGet));
}
T_WareHouse_DB TWareHouseDB = new T_WareHouse_DB();
string StrongHoldCode = "";
string StrongHoldCodeName = "";
TWareHouseDB.GetStrongholdcode(model.WarehouseNo, ref StrongHoldCode, ref StrongHoldCodeName);
Check_DB checkdb = new Check_DB();
string ErrorMsg = "";
if (!checkdb.CheckIsSvae(model.MaterialNo, model.WarehouseNo, ref ErrorMsg))
{
return(Json(new { state = false, ErrMsg = "待发或者待收库区有该物料不能生成盘点单！【" + ErrorMsg + "】" }, JsonRequestBehavior.AllowGet));
}
string strErrMsg = string.Empty;
List <T_StockInfoEX> lsttask = new List <T_StockInfoEX>();
Query_DB db = new Query_DB();
if (!db.GetStockCombineInfo2(model, ref lsttask, ref strErrMsg))
{
return(Json(new { Result = 0, ErrMsg = strErrMsg }, JsonRequestBehavior.AllowGet));
}
if (model.Check == "0")
{
//检验WMS库存和U9是否一致
T_Material_Batch_Func FUNC = new T_Material_Batch_Func();
List <U9Stock> erp_stock = FUNC.GetStockInfo(model.WarehouseNo, StrongHoldCode, model.MaterialNo);
bool isOk = true;
lsttask.ForEach(itemWMS =>
{
if (erp_stock.FindAll(itemerp => { return(itemerp.MaterialNo == itemWMS.MaterialNo && itemerp.BatchNo == itemWMS.BatchNo && itemerp.Qty == itemWMS.Qty); }).Count != 1)
{
isOk = false;
}
});
if (!isOk)
{
return(Json(new { state = false, ErrMsg = "WMS库存和U9不匹配不能生成盘点单！" }, JsonRequestBehavior.AllowGet));
}
}
Check_Model cm = new Check_Model();
//cm.REMARKS = strremark + txt_remarkD.Text + txt_remark.Text;
cm.CHECKSTATUS = "新建";
cm.CREATER = currentUser.UserNo;
cm.CHECKDESC = "明盘";
string ErrMsg = "";
if (checkdb.SaveCheck2(cm, lsttask, ref ErrMsg))
{
return(Json(new { state = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { state = false }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = false, ErrMsg = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
// 获取盘点库存信息
public JsonResult GetCheckStock(DividPage page, T_StockInfoEX model)
{
try
{
if (string.IsNullOrEmpty(model.WarehouseNo))
{
return(Json(new { Result = 0, ResultValue = "仓库不能为空！" }, JsonRequestBehavior.AllowGet));
}
T_WareHouse_DB TWareHouseDB = new T_WareHouse_DB();
string StrongHoldCode = "";
string StrongHoldCodeName = "";
TWareHouseDB.GetStrongholdcode(model.WarehouseNo, ref StrongHoldCode, ref StrongHoldCodeName);
string strErrMsg = string.Empty;
List <T_StockInfoEX> wms_stock = new List <T_StockInfoEX>();
Query_DB db = new Query_DB();
if (db.GetStockCombineInfo2(model, ref wms_stock, ref strErrMsg))
{
if (wms_stock == null || wms_stock.Count == 0)
{
return(Json(new { Result = 0, ResultValue = "查询库存为空！" }, JsonRequestBehavior.AllowGet));
}
T_Material_Batch_Func FUNC = new T_Material_Batch_Func();
List <U9Stock> erp_stock = FUNC.GetStockInfo(model.WarehouseNo, StrongHoldCode, model.MaterialNo);
//wms数据和erp数据对账
for (int i = 0; i < wms_stock.Count; i++)
{
if (erp_stock != null && erp_stock.Count > 0)
{
for (int j = 0; j < erp_stock.Count; j++)
{
if (wms_stock[i].MaterialNo == erp_stock[j].MaterialNo && wms_stock[i].BatchNo == erp_stock[j].BatchNo)
{
wms_stock[i].U9MaterialNo = erp_stock[i].MaterialNo;
wms_stock[i].U9BatchNo = erp_stock[i].BatchNo;
wms_stock[i].U9Qty = erp_stock[j].Qty;
erp_stock[j].IsAmount = 1;
}
}
}
}
if (erp_stock != null && erp_stock.Count > 0)
{
//没匹配的u9数据
for (int i = 0; i < erp_stock.Count; i++)
{
if (erp_stock[i].IsAmount != 1)
{
wms_stock.Add(new T_StockInfoEX()
{
U9MaterialNo = erp_stock[i].MaterialNo,
U9BatchNo = erp_stock[i].BatchNo,
U9Qty = erp_stock[i].Qty,
Qty = 0
});
}
}
}
return(Json(new { Result = 1, Data = wms_stock }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Result = 0, ResultValue = strErrMsg }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = 0, ResultValue = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
