/// <summary>
/// 由folder获取附件信息
/// </summary>
/// <param name="folder"></param>
/// <returns></returns>
public ActionResult GetListByFolder(string folder)
{
string sql = "select * from Sys_Attachment where folder ='" + folder + "'";
System.Data.DataTable dt = SxSqlHelperBLL.FindTable(sql);
return(ToJsonResult(dt));
}
/// <summary>
/// 获取实体
/// </summary>
public ActionResult GetFormJsonV(string userID, string iYear)
{
int xYear = iYear.ToInt();
var data = SxSqlHelperBLL.GetIRepository().FindEntity <CreditWriteEntity>(t => t.userID == userID && t.iYear == xYear);
return(ToJsonResult(data));
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetDataGridJsonV(string userID)
{
SplitPage s = new SplitPage()
{
Conditions = new Conditions[]
{
new Conditions()
{
Key = "userID", Value = userID
}
}
};
s.sort = "CreateDate";
s.order = "desc";
int total = 0;
string sqlw = SxSqlHelperBLL.getSqlw(s);
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", s, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetDataGridJsonV(int?typeX)
{
SplitPage splitPage = new SplitPage()
{
Conditions = new Conditions[]
{
new Conditions()
{
Key = "isnull(isOK,-1)", Value = typeX.ToStringV()
}
}
};
splitPage.order = "desc";
splitPage.sort = "createDate";
string sqlw = SxSqlHelperBLL.getSqlw(splitPage);
int total = 0;
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "CR_CreditMoney", splitPage, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
/// <summary>
/// 获取所有供应商
/// </summary>
/// <returns></returns>
public ActionResult getSuppliser()
{
string sql = "select spuCode as supCode,spuName as supName from dbo.Sys_Supplier";
DataTable dt = SxSqlHelperBLL.FindTable(sql);
return(ToJsonResult(dt));
}
/// <summary>
/// 获取原材料信息 合金、状态、配料类型
/// </summary>
/// <returns></returns>
public ActionResult getYuanCaiLiaoInfo()
{
string sql1 = "select cinvCode from dbo.Sys_Materiel where cinvClassCode='YCL002'";
string sql2 = @"select ItemValue from dbo.Base_DataItemDetail
where ItemId in(select itemid from base_dataitem where itemcode = 'YCLState')";
string sql3 = "select cinvCode from dbo.Sys_Materiel where cinvClassCode='PM100'";
DataTable dt1 = SxSqlHelperBLL.FindTable(sql1);
DataTable dt2 = SxSqlHelperBLL.FindTable(sql2);
DataTable dt3 = SxSqlHelperBLL.FindTable(sql3);
var json = new { hejin = dt1, state = dt2, plsort = dt3 };
return(ToJsonResult(json));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="splitPage">分页参数</param>
/// <returns></returns>
public ActionResult GetDataGridJson(SplitPage splitPage)
{
string sqlw = SxSqlHelperBLL.getSqlw(splitPage);
int total = 0;
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", splitPage, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
/// <summary>
/// 打印获取数据信息 测试
/// </summary>
public ActionResult getPrintDataBak(string tplname, string dataid, string datasort)
{
//模板提取
string tpl = "";
DataTable dt = SxSqlHelperBLL.FindTable("select top 1 con from dbo.MES_PrintTpl where name='" + Server.UrlDecode(tplname) + "'");
if (dt.Rows.Count > 0)
{
tpl = dt.Rows[0][0].ToString();
}
//标签提取
DataTable dtImgFlag = SxSqlHelperBLL.FindTable("select name,value from dbo.MES_PrintFlag where sort='图片标签'");
//前台解析json数据格式要求：
// { a:'',b:'',c:[{d:'',e:'',f:''},{d:'',e:'',f:''}]}
// 或者：{DAN:[{}],H:[],G:[]}，DAN只解析为单数据，
//a，b 为单数据调用方式：{{a}}，
//c:行数据，调用第一行数据方式：{{c1.d}},
//
DataTable danData = null; //单数据
DataTable hangData = null; //行数据
//包承重
if (datasort.ToLower() == "baochengzhong")
{
string sql = "select * from print_BaoZhuang_Juan where id='" + dataid + "'";
danData = SxSqlHelperBLL.FindTable(sql);
}
//箱打印
else if (datasort.ToLower() == "xiangbiaoqian")
{
//箱信息 单数据
string sql = "select * from print_BaoZhuang_Xiang where xID='" + dataid + "'";
danData = SxSqlHelperBLL.FindTable(sql);
//卷信息 行数据
string sql1 = "select * from print_BaoZhuang_Juan where xid='" + dataid + "'";
hangData = SxSqlHelperBLL.FindTable(sql1);
}
ReData data = new Controllers.ReData();
data.DAN = danData;
data.H = hangData;
//返回json数据，
var re = new { tpl = tpl, data = data, imgflag = dtImgFlag };
return(ToJsonResult(re));
}
public ActionResult CreditPingSave(string id, int?isOK, string isOKStr)
{
CreditMoneyEntity cur = creditmoneybll.GetEntity(id);
if (cur == null)
{
return(Error("不存在信息[" + id.ToStringV() + "] 不能操作"));
}
cur.isOK = isOK.ToInt();
cur.isOKStr = isOKStr.ToStringV();
cur.pingDate = Time.Now22;
cur.pingUserID = OperatorProvider.Provider.Current().UserId;
cur.pingUserName = OperatorProvider.Provider.Current().UserName;
SxSqlHelperBLL.GetIRepository().Update <CreditMoneyEntity>(cur);
return(Success("评价完成。"));
}
public ActionResult SaveForm(string keyValue, CreditWriteEntity entity)
{
int iyear = entity.iYear.ToInt();
if (iyear <= 0)
{
return(Error("年度录入不正确"));
}
string sql = "select id from CR_CreditWrite where userID='" + entity.userID + "' and iYear='" + iyear + "' ";
if (keyValue.ToStringV() != Str.Empty)
{
sql += " and id!='" + keyValue + "'";
}
DataTable tt = SxSqlHelperBLL.FindTable(sql);
if (TB.CheckTB(tt))
{
return(Error("用户[" + entity.userName + "]年度[" + iyear.ToString() + "]信息已经存在，不能重复录入"));
}
creditwritebll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
public ActionResult CreditSumCount(string userID)
{
//SplitPage sp = new SplitPage();
//List<CreditWriteEntity> list = creditwritebll.GetList(sp).ToList<CreditWriteEntity>()
//if(list==null||list.Count<=0)
//{
//}
string sql = "select * from CR_CreditWrite where userID='" + userID + "'";
DataTable tt = SxSqlHelperBLL.GetIRepository().FindTable(sql);
if (TB.CheckTB(tt))
{
System.Threading.Thread.Sleep(1 * 1000);
return(Success("操作完成"));
}
else
{
return(Error("当前用户没有信用记录"));
}
}
/// <summary>
/// 打印获取数据信息-卷信息
/// </summary>
public ActionResult getPrintData_Juan(string dataids)
{
List <Object> listResult = new List <object>(); //实体结果
List <string> listIDs = Str.FormStringV(dataids, new char[] { ',' }); //ID集合
List <string> listError = new List <string>(); //错误信息
if (listIDs.Count <= 0)
{
return(Error("没有获取重量ID信息."));
}
//图片标签 提取
DataTable dtImgFlag = SxSqlHelperBLL.FindTable("select name,value from MES_PrintFlag where sort='图片标签'");
DataTable danData = null;//单数据
//DataTable hangData = null;//行数据
foreach (var curID in listIDs)
{
//包承重-卷信息数据源
string sql = "select * from print_BaoZhuang_Juan where id='" + curID + "'";
danData = SxSqlHelperBLL.FindTable(sql);
if (danData == null || danData.Rows.Count <= 0)
{
listError.Add("称重信息ID:" + curID + " 不存在，请重试");
}
string biaoQian_Juan = danData.Rows[0]["biaoQian_Juan"].ToStringV();
if (string.IsNullOrEmpty(biaoQian_Juan))
{
listError.Add("称重信息ID:" + curID + " 没有标签信息，请在包装界面维护.");
}
//模板提取 biaoQian_Juan
string tpl = Str.Empty;
DataTable dt = SxSqlHelperBLL.FindTable("select top 1 con from dbo.MES_PrintTpl where name='" + biaoQian_Juan + "'");
if (dt.Rows.Count > 0)
{
tpl = dt.Rows[0][0].ToString();
}
if (string.IsNullOrEmpty(tpl))
{
listError.Add("称重信息ID:" + curID + " 没有标签名称:" + biaoQian_Juan + "，请在标签界面维护.");
}
ReData data = new Controllers.ReData();
data.DAN = danData;
//data.H = hangData;
//返回json数据，
var re = new { type = ResultType.success, message = "OK", tpl = tpl, data = data, imgflag = dtImgFlag };
listResult.Add(re);
}
if (listError.Count > 0)
{
//操作失败信息
string err = string.Empty;
foreach (var strError in listError)
{
err += strError + "\r\n";
}
return(Error(err));
}
else
{
//操作成功返回结果集合
return(ToJsonResult(listResult));
}
}
