/// <summary>
/// 提交表单
/// </summary>
/// <param name="info">对象</param>
/// <param name="keyValue">主键</param>
/// <returns></returns>
public ActionResult SubmitForm1(Mst_CargoPositionInfo Info, int F_BenginNum, int F_EndNum, string F_Prefix)
{
//拼接编号
List <Mst_CargoPositionInfo> list = new List <Mst_CargoPositionInfo>();
//循环添加
for (int i = F_BenginNum; i <= F_EndNum; i++)
{
Mst_CargoPositionInfo info = new Mst_CargoPositionInfo();
info.F_FullName = Info.F_FullName;
info.F_WarehouseId = Info.F_WarehouseId;
info.F_Unit = Info.F_Unit;
info.F_Description = Info.F_Description;
string Num = i + "";
while (Num.Length < 4)
{
Num = "0" + Num;
}
info.F_EnCode = F_Prefix + Num;
//info.F_FullName += Num;
list.Add(info);
}
try
{
BLLFactory <Mst_CargoPosition> .Instance.InsertRange(list);
return(Success(JsonAppHelper.ToJson(list)));
}
catch (Exception ex)
{
return(Error("货位编码已存在，请重新输入"));
}
}
/// <summary>
/// 禁用启用仓库，货位配置
/// </summary>
/// <param name="Id">仓库ID</param>
/// <param name="Type">更改类型</param>
/// <returns></returns>
public ActionResult UpEnMark(string Id, int Type)
{
//获取当前仓库状态
Mst_WarehouseInfo warehouseInfo = BLLFactory <Mst_Warehouse> .Instance.FindByID(Id);
ResultModel result = new ResultModel();
if (Type == 0)//如果是对仓库进行操作
{
result.bSuccess = BLLFactory <Mst_Warehouse> .Instance.UpEnMask(Id);
}
if (Type == 1)//对货位配置进行操作
{
if (warehouseInfo.F_PositionManagement == true)
{
warehouseInfo.F_PositionManagement = false;
}
else
{
warehouseInfo.F_PositionManagement = true;
}
result.bSuccess = BLLFactory <Mst_Warehouse> .Instance.Update(warehouseInfo, Id);
}
result.message = result.bSuccess ? "操作成功" : "操作失败,请刷新后重试";
return(Content(JsonAppHelper.ToJson(result)));
}
protected virtual AdvSearchCondtion SetExportConditionToObj(string condition)
{
AdvSearchCondtion cond = new AdvSearchCondtion();
if (string.IsNullOrEmpty(condition) || condition.Equals("null"))
{
cond.Condition = new SearchCondition();
return(cond);
}
ExportDataConditionModel model = JsonAppHelper.ToObject <ExportDataConditionModel>(condition);
AdvSearchCondtionEntity condv = JsonAppHelper.ToObject <AdvSearchCondtionEntity>(model.data);
cond.KeyValueList = condv.KeyValueList;
switch (model.type)
{
case 0:
var keyword = JsonAppHelper.ToObject <KeywordValueModel>(condv.Condition);
if (keyword == null)
{
cond.Condition = new SearchCondition();
}
else
{
cond.Condition = GetKeywordConditionObj(keyword.keyword, keyword.searchFiled);
}
break;
case 1:
cond.Condition = GetAdvConditionObj(JsonAppHelper.ToObject <List <AdvSearchEntity> >(condv.Condition));
break;
}
return(cond);
}
public virtual ActionResult GetGridJson(string keyword, string searchFiled, string sortFiled = " F_SortCode ")
{
SearchCondition condition = new SearchCondition();
var data = baseBLL.Find(GetKeywordCondition(keyword, searchFiled), " ORDER BY " + sortFiled);
return(Content(JsonAppHelper.ToJson(data)));
}
// 根据托盘号 获取托盘表头信息
public async Task <ActionResult> GetTrayInfo(string trayNo, bool bGetHead, bool bGetBody, string U8DatabaseName)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetTrayInfo(trayNo, bGetHead, bGetBody, U8DatabaseName)));
}));
}
public override ActionResult GetTreeGridJson(string keyword, string searchFiled, string list, string orderBy = " ORDER BY F_SortCode ")
{
string[] classnameList = typeof(Mst_PositionInfo).ToString().Split('.');
string condition = "";
if (string.IsNullOrEmpty(list))
{
condition = GetKeywordCondition(keyword, searchFiled);
}
else
{
condition = GetAdvCondition(JsonConvert.DeserializeObject <List <AdvSearchEntity> >(list));
}
TreeInfoEntity entity = new TreeInfoEntity();
entity.F_Condition = string.IsNullOrEmpty(condition) ? string.Empty : " AND " + condition;
entity.F_CType = 1;
entity.F_KeyFiled = "F_Id";
entity.F_ParentFiled = "F_ParentId";
entity.F_SortCode = orderBy;
entity.F_TableName = classnameList[classnameList.Length - 1].Replace("Info", string.Empty);
var dt = BLLFactory <AppCommon> .Instance.GetTreeInfo(entity); //baseBLL.Find(condition, orderBy);
string dataStr = JsonAppHelper.ToJson(dt);
var data = JsonAppHelper.ToList <Mst_PositionInfo>(dataStr);
foreach (var item in data)
{
string name = BLLFactory <Mst_Warehouse> .Instance.FindByID(item.F_WarehouseId).F_FullName;
item.F_WarehouseName = string.IsNullOrEmpty(name) ? "" : name;
}
return(Content(GetTreeGridJsonStr(data)));
}
//判断是否存在更新
public async Task <ActionResult> GetUIUpdate(string myVersion)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetUIUpdate(myVersion)));
}));
}
//读取单表信息
public async Task <ActionResult> GetSingleTableInfo(string tableName, string valueMember, string displayMember, string filedName, string where, string dbName, bool bDistinct, string sortFiled)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetSingleTableInfo(tableName, valueMember, displayMember, filedName, where, dbName, bDistinct, sortFiled)));
}));
}
//获取登录用户权限
public async Task <ActionResult> GetLoginUserModule(string userid, string ADMINNAME, string userpwd, string ADMINPWD)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetLoginUserModule(userid, ADMINNAME, userpwd, ADMINPWD)));
}));
}
//获取系统时间
public async Task <ActionResult> GetServerTime()
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetServerTime()));
}));
}
//获取临时扫描记录
public async Task <ActionResult> ScanFinish(string operOrder, string baseName)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.ScanFinish(operOrder, baseName)));
}));
}
//获取grid行信息
public async Task <ActionResult> GetGridRow(string formName, string gridName, string orderType, string cVouchID)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetGridRow(formName, gridName, orderType, cVouchID)));
}));
}
//获取业务模块
public async Task <ActionResult> GetVouchModel(string condition)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetVouchModel(condition)));
}));
}
/// <summary>
/// 获取分页对象
/// </summary>
/// <typeparam name="E">需要返回的集合泛型</typeparam>
/// <param name="ds">使用SQL Server分页存储过程后返回的对象</param>
/// <param name="pager">分页对象 为空时，不分页返回</param>
/// <returns></returns>
protected virtual Task <PagerDataEntity <E> > GetPagerDataAsync <E>(DataSet ds, PagerInfo pager)
{
return(Task.Run(() =>
{
int dataIndex = 0; //数据Index
int total = 0; //总页数
int recordCount = 0; //总记录数
if (pager == null)
{
//不分页处理
total = -1;
recordCount = ds.Tables[0].Rows.Count;
}
else
{
//分页处理
dataIndex = 1;
total = Convert.ToInt32(ds.Tables[2].Rows[0]["pagecount"]);
recordCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordcount"]);
}
var data = new PagerDataEntity <E>
{
rows = JsonAppHelper.ToList <E>(ds.Tables[dataIndex]),
total = total,
page = -1,
records = recordCount
};
return data;
}));
}
public ActionResult Copys(string F_Id, string F_FullName, string F_EnCode, string F_Page, string F_GridId)
{
//组织主表数据
Sys_GridColumnSettingInfo info = new Sys_GridColumnSettingInfo();
info.F_CreatorTime = DateTime.Now;
info.F_CreatorUserId = CurrentUser.F_Account;
info.F_Id = Guid.NewGuid().ToString();
info.F_FullName = F_FullName;
info.F_EnCode = F_EnCode;
info.F_Page = F_Page;
info.F_GridId = F_GridId;
info.F_ParentId = "0";
//组织详细表信息
List <Sys_GridColumnSettingInfo> list = new List <Sys_GridColumnSettingInfo>();
SearchCondition condition = new SearchCondition();
condition.AddCondition("F_ParentId", F_Id, SqlOperator.Equal);
var data = BLLFactory <Sys_GridColumnSetting> .Instance.Find(condition.BuildConditionSql().Replace("Where (1=1) AND ", string.Empty));
foreach (Sys_GridColumnSettingInfo model in data)
{
model.F_Id = Guid.NewGuid().ToString();
model.F_CreatorTime = DateTime.Now;
model.F_CreatorUserId = info.F_CreatorUserId;
model.F_ParentId = info.F_Id;
model.F_Page = info.F_Page;
model.F_GridId = info.F_GridId;
list.Add(model);
}
BLLFactory <Sys_GridColumnSetting> .Instance.Copys(info, list);
return(Content(JsonAppHelper.ToJson(true)));
}
/// <summary>
/// 批量添加
/// </summary>
/// <param name="F_BenginNum"></param>
/// <param name="F_EndNum"></param>
/// <param name="F_Prefix"></param>
/// <param name="Info"></param>
/// <returns></returns>
public ActionResult SubmitForm1(int F_BenginNum, int F_EndNum, string F_Prefix, Mst_PositionInfo Info)
{
ResultModel result = new ResultModel();
//拼接编号
List <Mst_PositionInfo> list = new List <Mst_PositionInfo>();
List <Mst_PositionInfo> infoList = BLLFactory <Mst_Position> .Instance.GetAll();
//循环添加
for (int i = F_BenginNum; i <= F_EndNum; i++)
{
Mst_PositionInfo info = new Mst_PositionInfo();
info.F_WarehouseId = Info.F_WarehouseId;
info.F_Property = Info.F_Property;
info.F_Type = Info.F_Type;
info.F_EnabledMark = Info.F_EnabledMark;
info.F_ParentId = Info.F_ParentId;
info.F_Description = Info.F_Description;
info.F_EnCode = F_Prefix + i.ToString().PadLeft(F_EndNum.ToString().Length, '0');
info.F_FullName = Info.F_FullName;
list.Add(info);
if (infoList.FindAll(u => u.F_EnCode == info.F_EnCode).Count > 0)
{
result.bSuccess = false;
result.message = info.F_EnCode + "已存在，请输入合适序号";
return(Content(JsonAppHelper.ToJson(result)));
}
}
result.bSuccess = BLLFactory <Mst_Position> .Instance.InsertRange(list);
result.message = result.bSuccess == true ? "添加成功" : "添加失败，请刷新后重试";
return(Content(JsonAppHelper.ToJson(result)));
}
//获取临时扫描记录
public async Task <ActionResult> GetScanInfo(string operOrder)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetScanInfo(operOrder)));
}));
}
//获取扫描列表信息
public async Task <ActionResult> SaveTempScanHead(DataRow dr, string userid)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.SaveTempScanHead(dr, userid)));
}));
}
//获取扫描列表信息
public async Task <ActionResult> SaveTempScanBody(DataRow dr, bool bDel, string OPERORDER, string CVOUCHID, string CWHCODE, string userid, string baseName)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.SaveTempScanBody(dr, bDel, OPERORDER, CVOUCHID, CWHCODE, userid, baseName)));
}));
}
//条码解析
public async Task <ActionResult> GetFeedingTips(string orderNo)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetFeedingTips(orderNo)));
}));
}
//获取扫描列表信息
public async Task <ActionResult> GetTempScanHead(string condition)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.GetTempScanHead(condition)));
}));
}
//获取临时扫描记录
public async Task <ActionResult> bFIFO(string BARCODE, string operOrder, string baseName, string CWHCODE)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.bFIFO(BARCODE, operOrder, baseName, CWHCODE)));
}));
}
//条码解析
public async Task <ActionResult> BarcodeAnalyze(string OPERORDER, string BARCODE, string DBNAME)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.BarcodeAnalyze(OPERORDER, BARCODE, DBNAME)));
}));
}
// 保存托盘表体信息
public async Task <ActionResult> SaveTrayBody(string trayNo, string barcode, string qty, string iNum, bool bInTray, DataRow dr, string BarcodeDatabaseName, string BarcodeDatabaseConnString)
{
return(await Task.Run(() =>
{
return Content(JsonAppHelper.ToJson(api.SaveTrayBody(trayNo, barcode, qty, iNum, bInTray, dr, BarcodeDatabaseName, BarcodeDatabaseConnString)));
}));
}
/// <summary>
/// 获取分页对象
/// </summary>
/// <typeparam name="E">需要返回的集合泛型</typeparam>
/// <param name="dt">数据集合datatable</param>
/// <param name="recordcount">记录总数</param>
/// <param name="pager">分页对象 为空时，不分页返回</param>
/// <returns></returns>
protected virtual Task <PagerDataEntity <E> > GetPagerDataAysnc <E>(DataTable dt, int recordcount, PagerInfo pager)
{
return(Task.Run(() =>
{
int total = 0; //总页数
int recordCount = 0; //总记录数
if (pager == null)
{
//不分页处理
total = -1;
recordCount = dt.Rows.Count;
}
else
{
//分页处理
total = recordcount / pager.PageSize == 0 ? 1 : (recordcount % pager.PageSize == 0 ? recordcount / pager.PageSize : recordcount / pager.PageSize + 1);
recordCount = recordcount;
}
var data = new PagerDataEntity <E>
{
rows = JsonAppHelper.ToList <E>(dt),
total = total,
page = -1,
records = recordCount
};
return data;
}));
}
public ActionResult GetListGridJsonPagination(string filterStr, Pagination pagination, string sidx = " F_EnCode ", string sord = "desc")
{
if (string.IsNullOrEmpty(sidx))
{
sidx = " F_EnCode ";
}
PagerInfo pager = GetPageInfo(pagination);
List <AdvSearchEntity> advSearchList = new List <AdvSearchEntity>();
List <Mst_CustomerInfo> lista;
if (string.IsNullOrEmpty(filterStr))
{
lista = baseBLL.FindWithPager(GetKeywordCondition("", filterStr), pager, sidx, sord.ToLower() == "desc");
//advSearchList.Add(new AdvSearchEntity
//{
// F_condition = "And",
// F_fvalue = DateTime.Now.ToString("yyyy-MM") + "-01",
// F_searchFiled = "F_Id",
// F_type = "2"
//});
//advSearchList.Add(new AdvSearchEntity
//{
// F_condition = "And",
// F_fvalue = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"),
// F_searchFiled = "F_Id",
// F_type = "2"
//});
}
else
{
CustomerFilter filter = JsonAppHelper.ToObject <CustomerFilter>(filterStr);
if (!string.IsNullOrEmpty(filter.F_EnCode))
{
advSearchList.Add(new AdvSearchEntity
{
F_condition = "And",
F_fvalue = filter.F_EnCode,
F_searchFiled = "F_EnCode",
F_type = "2"
});
}
if (!string.IsNullOrEmpty(filter.F_FullName))
{
advSearchList.Add(new AdvSearchEntity
{
F_condition = "And",
F_fvalue = filter.F_FullName,
F_searchFiled = "F_FullName",
F_type = "2"
});
}
lista = BLLFactory <Mst_Customer> .Instance.FindWithPager(GetAdvCondition(advSearchList), pager, sidx, sord.ToLower().Equals("desc"));
}
return(GetPagerContent <Mst_CustomerInfo>(lista, pager));
}
public ActionResult GetListGridJson(string keyValue, string sidx = " F_EnCode ", string sord = "desc")
{
//此处需要新建一张表体视图,暂时使用表代替
SearchCondition condition = new SearchCondition();
condition.AddCondition("F_HeadId", keyValue, SqlOperator.Equal);
return(Content(JsonAppHelper.ToJson(BLLFactory <InStock_Body> .Instance.Find(GetConditionStr(condition)))));
}
//获取登录用户权限
public async Task <ActionResult> Login(string userID, string userPwd, string DatabaseConnString)
{
return(await Task.Run(() =>
{
string errorInfo = string.Empty;
return Content(JsonAppHelper.ToJson(api.Login(userID, userPwd, out errorInfo, DatabaseConnString)));
}));
}
public ActionResult GetEnCodeList()
{
SearchCondition search = new SearchCondition();
search.AddCondition("F_Status", 1, SqlOperator.Equal);
List <PI_HeadInfo> list = BLLFactory <PI_Head> .Instance.Find(GetConditionStr(search));
return(Content(JsonAppHelper.ToJson(list)));
}
/// <summary>
/// 获取表体
/// </summary>
/// <param name="keyValue"></param>
/// <returns></returns>
public ActionResult GetFormJson1(string keyValue)
{
SearchCondition condition = new SearchCondition();
condition.AddCondition("F_HId", keyValue, SqlOperator.Equal);
List <SO_BodyInfo> list = BLLFactory <SO_Body> .Instance.Find(condition.BuildConditionSql().Replace("Where (1=1) AND ", string.Empty));
return(Content(JsonAppHelper.ToJson(list)));
}
