using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Mvc;
using DataTransfersLibs;
using GSMarketSys.Models.Dto;
using Newtonsoft.Json;
using SysBaseLibs;
using SysDataLibs;
using SysDataLibs.TableClass;
namespace GSMarketSys.Controllers
{
[CheckPowerFilter]
public class MarketSystemController : BaseController
{
#region 市场基础信息（Market）
///
/// 市场信息录入页面
///
///
public ActionResult MarketsList()
{
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
Tn.MarketType, "MarketTypeID<>'6'", UserSessionInfo.DBConn);
ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
return View();
}
///
/// 市场（超市）信息录入操作
///
///
[HttpPost]
public ActionResult MarketsListOper()
{
#region Request + new Markets_Info
string type = Request["Type"] ?? "";
string marketId = GetRequest("MarketID");
string regionId = GetRequest("RegionId");
string licenseNo = GetRequest("LicenseNo");
string licenseName = GetRequest("LicenseName");
string cardIndex = GetRequest("CardIndex");
string practiseTime = GetRequest("PractiseTime");
string area = GetRequest("Area","INT");
string marketSellerNum = GetRequest("MarketSellerNum","INT");
string principal = GetRequest("Principal");
string linkMan = GetRequest("LinkMan");
string frontForUnit = GetRequest("FrontForUnit");
string address = GetRequest("Address");
string name = GetRequest("Name");
string marketTypeId = GetRequest("MarketTypeID");
string upgrade = GetRequest("Upgrade");
string turnover = GetRequest("Turnover","INT");
string auditFlag = GetRequest("AuditFlag","INT");
string telephone = GetRequest("Telephone");
string linkTel = GetRequest("LinkTel");
string manageUnit = GetRequest("ManageUnit");
string remark = GetRequest("Remark");
Markets_info marketInfo = new Markets_info
{
MarketID = marketId,
RegionID = regionId,
LicenseNo = licenseNo,
LicenseName = licenseName,
CardIndex = cardIndex,
PractiseTime = practiseTime,
Area = area,
MarketSellerNum = marketSellerNum,
Principal = principal,
LinkMan = linkMan,
FrontForUnit = frontForUnit,
Address = address,
Names = name,
MarketTypeID = marketTypeId,
Upgrade = upgrade,
Turnover = turnover,
AuditFlag = auditFlag,
Telephone = telephone,
LinkTel = linkTel,
ManageUnit = manageUnit,
Remark = remark,
IsLock = "0"
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
if (SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
}
lcSql = marketInfo.InsertSql();
break;
case "Edit":
if (!SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_NoExistKeyError"));
}
lcSql = marketInfo.UpdateSql();
break;
case "Del":
if (!SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_NoExistKeyError"));
}
lcSql = "UPDATE Markets SET IsLock=1 WHERE MarketID='" + marketId + "'";
break;
case "ReDel":
if (!SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_NoExistKeyError"));
}
lcSql = "UPDATE Markets SET IsLock=0 WHERE MarketID='" + marketId + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 市场信息查询页面
///
///
public ActionResult MarketQry()
{
ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
Tn.MarketType, "MarketTypeID<>'6'", UserSessionInfo.DBConn);
ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
return View();
}
///
/// 市场信用评级页面
///
///
public ActionResult MarketEvaluationQry()
{
ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "Y" : "N";
ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
Tn.MarketType, "MarketTypeID<>'6'", UserSessionInfo.DBConn);
ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
return View();
}
///
/// 市场（超市）信用评级操作
///
///
[HttpPost]
public ActionResult MarketEvaluationOper()
{
string type = Request["CurdType"] ?? "",
marketId = GetRequest("MarketID"),
year = GetRequest("Year"),
month = GetRequest("Month"),
postValue = GetRequest("PostValue"),
lcReturnValue = postValue.Replace("txtNum_", "");
Array loList = UtilStr.StrToArray(lcReturnValue);
string lcSql = "";
switch (type)
{
case "Add":
if (loList != null && loList.Length > 0)
{
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(" SELECT * FROM " + Tn.MarketEvalGrade + " WHERE " + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND " + MarketEvalGrade_info.cYear + "='" + year + "' AND " + MarketEvalGrade_info.cMonth + "='" + month + "' ");
if (loQuery.RecCount > 0)
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsOperError"));
}
for (int i = 0; i < loList.Length; i++)
{
string lcValue = loList.GetValue(i) + "";
string[] loStrs = lcValue.Split(',');
string[] loIDs = loStrs[0].Split('_');
MarketEvalGrade_info loMarketEvalGrade = new MarketEvalGrade_info
{
EvaluationID = loIDs[0],
EvaluationItemID = loIDs[1],
MarketID = marketId,
Year = year,
Month = month,
Score = loStrs[1],
ScoreDate = DateTime.Now.ToShortDateString(),
ScoreUser = UserSessionInfo.UserInfo.Names,
TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
IsSelf = UserSessionInfo.IsMarketSysAccount ? "Y" : "N"
};
lcSql += loMarketEvalGrade.InsertSql();
}
}
break;
case "Edit":
if (loList != null && loList.Length > 0)
{
lcSql += " DELETE " + Tn.MarketEvalGrade + " WHERE " + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND " + MarketEvalGrade_info.cYear + "='" + year + "' AND " + MarketEvalGrade_info.cMonth + "='" + month + "' ";
for (int i = 0; i < loList.Length; i++)
{
string lcValue = loList.GetValue(i) + "";
string[] loStrs = lcValue.Split(',');
string[] loIDs = loStrs[0].Split('_');
MarketEvalGrade_info loMarketEvalGrade = new MarketEvalGrade_info
{
EvaluationID = loIDs[0],
EvaluationItemID = loIDs[1],
MarketID = marketId,
Year = year,
Month = month,
Score = loStrs[1],
ScoreDate = DateTime.Now.ToShortDateString(),
ScoreUser = UserSessionInfo.UserInfo.Names,
TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
IsSelf = UserSessionInfo.IsMarketSysAccount ? "Y" : "N"
};
lcSql += loMarketEvalGrade.InsertSql();
}
}
break;
case "Del":
lcSql += " DELETE " + Tn.MarketEvalGrade + " WHERE " + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND " + MarketEvalGrade_info.cYear + "='" + year + "' AND " + MarketEvalGrade_info.cMonth + "='" + month + "' ";
break;
}
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 超市信息录入页面
///
///
public ActionResult MarketsListCs()
{
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
Tn.MarketType, "MarketTypeID='6'", UserSessionInfo.DBConn);
ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
return View();
}
///
/// 超市信息查询页面
///
///
public ActionResult MarketQryCs()
{
ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
Tn.MarketType, "MarketTypeID='6'", UserSessionInfo.DBConn);
ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
return View();
}
///
/// 超市信用评级页面
///
///
public ActionResult MarketEvaluationQryCs()
{
ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "Y" : "N";
ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
Tn.MarketType, "MarketTypeID='6'", UserSessionInfo.DBConn);
ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
return View();
}
#endregion
#region 经营户基础信息（MarketSeller）
///
/// 经营户信息录入页面
///
///
public ActionResult MarketSellersList()
{
ViewBag.SelTradeTypeInfo = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName,
Tn.TradeType, UserSessionInfo.DBConn, false);
ViewBag.SelRunningWayTypeInfo = GetData.Instance.GetSelStr(ApparatusType_info.cApparatusTypeID, ApparatusType_info.cName, Tn.ApparatusType, UserSessionInfo.DBConn, false);
ViewBag.SelApparatusTypeInfo = GetData.Instance.GetSelStr(RunningWayType_info.cRunningWayTypeID, RunningWayType_info.cName, Tn.RunningWayType, UserSessionInfo.DBConn, false);
ViewBag.SelWarrantType = GetData.Instance.GetSelStr("WarrantTypeID", "Name",
Tn.WarrantType, "IsLock=0 AND Flag=1", UserSessionInfo.DBConn);
ViewBag.SelWarrantStyle =
GetData.Instance.GetSelStr("WarrantStyle", "SellerHasWarrant", UserSessionInfo.DBConn);
ViewBag.SelStallInfo = GetData.Instance.GetSelStr(Stalls_info.cStallID, Stalls_info.cName, Tn.Stalls, UserSessionInfo.MarketDataSql(false), UserSessionInfo.DBConn);
return View();
}
///
/// 经营户信息录入操作
///
///
public ActionResult MarketSellersListOper()
{
#region Request + new MarketSellers_Info
string type = GetRequest("Type"),
sellerId = GetRequest("SellerID"),
marketSellerName = GetRequest("MarketSellerName"),
licenseNo = GetRequest("LicenseNo"),
licenseName = GetRequest("LicenseName"),
cardIndex = GetRequest("CardIndex"),
gender = GetRequest("Gender"),
age = GetRequest("Age"),
idCard = GetRequest("IdCard"),
tel = GetRequest("Tel"),
enterMarketDate = GetRequest("EnterMarketDate"),
residenceAddress = GetRequest("ResidenceAddress"),
tempAddress = GetRequest("TempAddress"),
tradeTypeId = GetRequest("TradeTypeID"),
runningWayTypeId = GetRequest("RunningWayTypeID"),
annualStallFee = GetRequest("AnnualStallFee", "INT"),
facia = GetRequest("Facia"),
apparatusTypeId = GetRequest("ApparatusTypeID", "INT"),
remark = GetRequest("Remark"),
staff1Name = GetRequest("Staff1Name"),
staff1Gender = GetRequest("Staff1Gender"),
staff1Age = GetRequest("Staff1Age"),
staff1Residence = GetRequest("Staff1Residence"),
staff1CurrentAddr = GetRequest("Staff1CurrentAddr"),
staff2Name = GetRequest("Staff2Name"),
staff2Gender = GetRequest("Staff2Gender"),
staff2Age = GetRequest("Staff2Age"),
staff2Residence = GetRequest("Staff2Residence"),
staff2CurrentAddr = GetRequest("Staff2CurrentAddr"),
staff3Name = GetRequest("Staff3Name"),
staff3Gender = GetRequest("Staff3Gender"),
staff3Age = GetRequest("Staff3Age"),
staff3Residence = GetRequest("Staff3Residence"),
staff3CurrentAddr = GetRequest("Staff3CurrentAddr"),
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
MarketSellers_info marketSellerInfo = new MarketSellers_info(sellerId,UserSessionInfo.DBConn)
{
MarketID = marketId,
LicenseNo = licenseNo,
LicenseName = licenseName,
CardIndex = cardIndex,
Name = Utils.AreaToSQL(marketSellerName),
Gender = gender,
Age = Utils.AreaToSQL(age),
IdCard = Utils.AreaToSQL(idCard),
Tel = Utils.AreaToSQL(tel),
EnterMarketDate = enterMarketDate,
ResidenceAddress = residenceAddress,
TempAddress = Utils.AreaToSQL(tempAddress),
TradeTypeID = tradeTypeId,
RunningWayTypeID = runningWayTypeId,
AnnualStallFee = Utils.AreaToSQL(annualStallFee),
AnnualManageFee = "0",
Score = "0",
Facia = Utils.AreaToSQL(facia),
ApparatusTypeID = apparatusTypeId,
Remark = Utils.AreaToSQL(remark),
Staff1Name = Utils.AreaToSQL(staff1Name),
Staff1Gender = Utils.AreaToSQL(staff1Gender),
Staff1Age = Utils.AreaToSQL(staff1Age)==""?"0": Utils.AreaToSQL(staff1Age),
Staff1Residence = Utils.AreaToSQL(staff1Residence),
Staff1CurrentAddress = Utils.AreaToSQL(staff1CurrentAddr),
Staff2Name = Utils.AreaToSQL(staff2Name),
Staff2Gender = Utils.AreaToSQL(staff2Gender),
Staff2Age = Utils.AreaToSQL(staff2Age)==""?"0": Utils.AreaToSQL(staff2Age),
Staff2Residence = Utils.AreaToSQL(staff2Residence),
Staff2CurrentAddress = Utils.AreaToSQL(staff2CurrentAddr),
Staff3Name = Utils.AreaToSQL(staff3Name),
Staff3Gender = Utils.AreaToSQL(staff3Gender),
Staff3Age = Utils.AreaToSQL(staff3Age)==""?"0": Utils.AreaToSQL(staff3Age),
Staff3Residence = Utils.AreaToSQL(staff3Residence),
Staff3CurrentAddress = Utils.AreaToSQL(staff3CurrentAddr),
IsLock = "N"
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
if (CheckSellerIdCodeIsExist(marketSellerInfo.MarketID, marketSellerInfo.IdCard))
return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，身份证号(" +
marketSellerInfo.IdCard + ")在市场中已存在！\"}");
if (!string.IsNullOrEmpty(marketSellerInfo.LicenseNo)&&CheckSellerLicenseNoIsExist(marketSellerInfo.MarketID, marketSellerInfo.LicenseNo))
return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，社会信用统一编码(" +
marketSellerInfo.LicenseNo + ")在市场中已存在！\"}");
lcSql = marketSellerInfo.InsertSql();
//lcSql += " SELECT @@IDENTITY AS ident ";
break;
case "Edit":
if (CheckSellerIdCodeIsExist(marketSellerInfo.MarketID, marketSellerInfo.IdCard,
marketSellerInfo.SellerID))
return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，身份证号(" +
marketSellerInfo.IdCard + ")在市场中已存在！\"}");
if (!string.IsNullOrEmpty(marketSellerInfo.LicenseNo)&&CheckSellerLicenseNoIsExist(marketSellerInfo.MarketID, marketSellerInfo.LicenseNo,
marketSellerInfo.SellerID))
return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，社会信用统一编码(" +
marketSellerInfo.LicenseNo + ")在市场中已存在！\"}");
lcSql = marketSellerInfo.UpdateSql();
break;
case "Del":
lcSql = "UPDATE MarketSellers SET IsLock='Y' WHERE SellerID='" + sellerId + "'";
break;
case "ReDel":
lcSql = "UPDATE MarketSellers SET IsLock='N' WHERE SellerID='" + sellerId + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
}
// if (type == "Add")
// {
// try
// {
// rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
// string identity = loQuery.GetString("ident");
// ResultJson temp =
// SysBaseLibs.JsonHelper.Instance.Deserialize(
// SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
// temp.ErrorInfo = identity + "|" + temp.ErrorInfo;
// return Content(temp.ToJson());
// }
// catch
// {
// return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
// }
//}
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
private bool CheckSellerIdCodeIsExist(string marketId, string identityCode,string sellerId=null)
{
bool lbRetval = false;
string lcSql = "SELECT top 1 * FROM MarketSellers WHERE "+MarketSellers_info.cMarketID+" = '" + marketId + "' AND "+ MarketSellers_info.cIdCard + "='" + identityCode + "'";
if (!string.IsNullOrEmpty(sellerId))
{
lcSql += " AND SellerID !='" + sellerId + "'";
}
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
if (loQuery.IsOpened && loQuery.RecCount > 0)
{
lbRetval = true;
}
return lbRetval;
}
private bool CheckSellerLicenseNoIsExist(string marketId, string licenseNo, string sellerId=null)
{
bool lbRetval = false;
string lcSql = "SELECT top 1 * FROM MarketSellers WHERE "+MarketSellers_info.cMarketID+" = '" + marketId + "' AND "+ MarketSellers_info.cLicenseNo + "='" + licenseNo + "'";
if (!string.IsNullOrEmpty(sellerId))
{
lcSql += " AND SellerID !='" + sellerId + "'";
}
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
if (loQuery.IsOpened && loQuery.RecCount > 0)
{
lbRetval = true;
}
return lbRetval;
}
///
/// 经营户执照信息操作
///
///
public ActionResult MarketSellerWarrantOper()
{
string type = Request["Type"] ?? "",
sellerId = GetRequest("SellerID"),
id = GetRequest("ID"),
warrantTypeId = GetRequest("WarrantTypeID"),
warrantStyle = GetRequest("WarrantStyle"),
warrantNumber = GetRequest("WarrantNumber"),
validStartTime = GetRequest("ValidStartTime"),
validEndTime = GetRequest("ValidEndTime"),
fileTitle = GetRequest("FileTitle"),
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
string lcSql ;
SellerHasWarrant_info sellerHasWarrant = new SellerHasWarrant_info(sellerId,UserSessionInfo.DBConn)
{
SellerID = Utils.AreaToSQL(sellerId),
WarrantTypeID = Utils.AreaToSQL(warrantTypeId),
WarrantStyle = Utils.AreaToSQL(warrantStyle),
WarrantNumber = Utils.AreaToSQL(warrantNumber),
ValidStartTime = Utils.AreaToSQL(validStartTime),
ValidEndTime = Utils.AreaToSQL(validEndTime)
};
Sys_AttachFiles_info loAttacthFile;
HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
switch (type)
{
case "Add":
try
{
lcSql = sellerHasWarrant.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile = new Sys_AttachFiles_info
{
TableId = Tn.SellerHasWarrant,
ColumnId = SellerHasWarrant_info.cID,
SourceKey = identity,
FileTitle = fileTitle,
TimeCreated = DateTime.Now.ToShortDateString(),
TimeLastMod = DateTime.Now.ToShortDateString(),
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
if (loAttacthFile.UpdateFile(attachFile, UserSessionInfo))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error_NoAttach"));
}
catch (Exception ex)
{
ThreadLog.LogException(ex);
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
case "Edit":
sellerHasWarrant.ID = id;
lcSql = sellerHasWarrant.UpdateSql();
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
loAttacthFile = new Sys_AttachFiles_info(Tn.SellerHasWarrant, SellerHasWarrant_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.SellerHasWarrant,
ColumnId = SellerHasWarrant_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeCreated = DateTime.Now.ToShortDateString(),
TimeLastMod = DateTime.Now.ToShortDateString(),
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
string oldPath = HttpContext.Request.PhysicalApplicationPath + loAttacthFile.FilePath + "/" + loAttacthFile.FileName;
if (loAttacthFile.UpdateFile(attachFile, UserSessionInfo,false))
{
try
{
if (!string.IsNullOrEmpty(oldPath))
System.IO.File.Delete( oldPath);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
}
else
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
break;
case "Del":
lcSql = "DELETE " + Tn.SellerHasWarrant + " WHERE " + SellerHasWarrant_info.cID + " IN(" + id + ") ";
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
loAttacthFile = new Sys_AttachFiles_info(Tn.SellerHasWarrant, SellerHasWarrant_info.cID, id,
UserSessionInfo.DBConn);
string oldPath = HttpContext.Request.PhysicalApplicationPath + loAttacthFile.FilePath + "/" + loAttacthFile.FileName;
if (UserSessionInfo.DBConn.ExcuteSqlTran(loAttacthFile.DeleteSql()))
{
try
{
if (!string.IsNullOrEmpty(oldPath))
System.IO.File.Delete(oldPath);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
else
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
}
///
/// 经营户摊位信息操作
///
///
public ActionResult MarketSellerStallOper()
{
string sellerId = GetRequest("SellerID"),
stallNo = GetRequest("StallNo");
return Content(SellerHasStall_info.UpdateStallBySellerId(sellerId, stallNo, UserSessionInfo.DBConn) ? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success") : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
}
///
/// 经营户信息查询页面
///
///
public ActionResult MarketSellersQry()
{
ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelTradeTypeInfo = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName,
Tn.TradeType, UserSessionInfo.DBConn, false);
ViewBag.SelRunningWayTypeInfo = GetData.Instance.GetSelStr(ApparatusType_info.cApparatusTypeID, ApparatusType_info.cName, Tn.ApparatusType, UserSessionInfo.DBConn, false);
ViewBag.SelApparatusTypeInfo = GetData.Instance.GetSelStr(RunningWayType_info.cRunningWayTypeID, RunningWayType_info.cName, Tn.RunningWayType, UserSessionInfo.DBConn, false);
return View();
}
///
/// 经营户信用评级页面
///
///
public ActionResult MarketSellersEvaQry()
{
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelTradeTypeInfo = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName,
Tn.TradeType, UserSessionInfo.DBConn, false);
ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "Y" : "N";
ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
return View();
}
///
/// 经营户信用评级操作
///
///
[HttpPost]
public ActionResult MarketSellersEvaluationOper()
{
string type = Request["CurdType"] ?? "",
marketId = GetRequest("MarketID"),
sellerId = GetRequest("SellerID"),
year = GetRequest("Year"),
month = GetRequest("Month"),
postValue = GetRequest("PostValue"),
lcReturnValue = postValue.Replace("txtNum_", "");
Array loList = UtilStr.StrToArray(lcReturnValue);
string lcSql = "";
switch (type)
{
case "Add":
if (loList != null && loList.Length > 0)
{
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(" SELECT * FROM " + Tn.SellerEvalGrade + " WHERE " + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND " + SellerEvalGrade_info.cYear + "='" + year + "' AND " + SellerEvalGrade_info.cMonth + "='" + month + "' ");
if (loQuery.RecCount > 0)
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsOperError"));
}
for (int i = 0; i < loList.Length; i++)
{
string lcValue = loList.GetValue(i) + "";
string[] loStrs = lcValue.Split(',');
string[] loIDs = loStrs[0].Split('_');
SellerEvalGrade_info loSellerEvalGrade = new SellerEvalGrade_info
{
EvaluationID = loIDs[0],
EvaluationItemID = loIDs[1],
MarketID = marketId,
SellerID=sellerId,
Year = year,
Month = month,
Score = loStrs[1],
ScoreDate = DateTime.Now.ToShortDateString(),
ScoreUser = UserSessionInfo.UserInfo.Names,
TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
};
lcSql += loSellerEvalGrade.InsertSql();
}
}
break;
case "Edit":
if (loList != null && loList.Length > 0)
{
lcSql += " DELETE " + Tn.SellerEvalGrade + " WHERE " + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND " + SellerEvalGrade_info.cYear + "='" + year + "' AND " + SellerEvalGrade_info.cMonth + "='" + month + "' ";
for (int i = 0; i < loList.Length; i++)
{
string lcValue = loList.GetValue(i) + "";
string[] loStrs = lcValue.Split(',');
string[] loIDs = loStrs[0].Split('_');
SellerEvalGrade_info loSellerEvalGrade = new SellerEvalGrade_info
{
EvaluationID = loIDs[0],
EvaluationItemID = loIDs[1],
MarketID = marketId,
SellerID = sellerId,
Year = year,
Month = month,
Score = loStrs[1],
ScoreDate = DateTime.Now.ToShortDateString(),
ScoreUser = UserSessionInfo.UserInfo.Names,
TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
};
lcSql += loSellerEvalGrade.InsertSql();
}
}
break;
case "Del":
lcSql += " DELETE " + Tn.SellerEvalGrade + " WHERE " + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND " + SellerEvalGrade_info.cYear + "='" + year + "' AND " + SellerEvalGrade_info.cMonth + "='" + month + "' ";
break;
}
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
#endregion
#region 市场日常管理
///
/// 品牌管理页面
///
///
public ActionResult NameBrandList()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 品牌管理操作
///
///
[HttpPost]
public ActionResult NameBrandOper()
{
#region Request + new NameBrands_info
string type = Request["Type"] ?? "",
nameBrandId = GetRequest("NameBrandID"),
nameBrandName = GetRequest("NameBrandName")??"",
nbByPerson = GetRequest("NBByPerson"),
marketManager = GetRequest("MarketManager"),
yjzhizhao = GetRequest("yjzhizhao"),
foodName = GetRequest("FoodName"),
nbByPersonLinks = GetRequest("NBByPersonLinks"),
marketId = GetRequest("MarketId"),
pinpaizhengshu = GetRequest("pinpaizhengshu"),
description = GetRequest("Description"),
greenFood = GetRequest("GreenFood") ?? "N",
organicFood = GetRequest("OrganicFood") ?? "N",
innocuityFood = GetRequest("InnocuityFood") ?? "N",
weishengxuke = GetRequest("weishengxuke");
NameBrands_info nameBrandInfo = new NameBrands_info(nameBrandId, UserSessionInfo.DBConn)
{
NameBrandName = nameBrandName,
TradeTypeID = "1",
MarketId = marketId,
FoodName = foodName,
NBByPerson = nbByPerson,
NBByPersonLinks=nbByPersonLinks,
MarketManager = marketManager,
GreenFood = greenFood,
OrganicFood = organicFood,
InnocuityFood = innocuityFood,
yjzhizhao = yjzhizhao,
weishengxuke = weishengxuke,
pinpaizhengshu = pinpaizhengshu,
Description = description,
TimeLastMod = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserIDLastMod = UserSessionInfo.UserInfo.UserID,
IsLock = "N"
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
nameBrandInfo.TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lcSql = nameBrandInfo.InsertSql();
break;
case "Edit":
if (!string.IsNullOrEmpty(nameBrandId))
{
nameBrandInfo.NameBrandID = nameBrandId;
lcSql = nameBrandInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(nameBrandId))
lcSql = "UPDATE " + Tn.NameBrands + " SET IsLock='Y' WHERE NameBrandID='" + nameBrandId + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 主要商品价格页面
///
///
public ActionResult MarketMajorQuoteList()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelMajorGoodsNameInfo = GetData.Instance.GetSelStr(VarietyCategory_info.cVarietyCategoryNo,
VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
VarietyCategory_info.cIsMajorCost + "='Y' AND " + VarietyCategory_info.cVarietyCategoryNo +
"!='10000'", UserSessionInfo.DBConn);
//var result= GetData.Instance.GetSelectList(VarietyCategory_info.cVarietyCategoryNo,
//VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
// VarietyCategory_info.cIsCanChecked + "='Y' AND "+ VarietyCategory_info.cVarietyCategoryNo +"!='10000'", UserSessionInfo.DBConn);
//ViewBag.SelMajorGoodsNameInfo =result;
ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(MarketMajorQuote_info.cUnitID, Tn.MarketMajorQuote, UserSessionInfo.DBConn);
return View();
}
///
/// 主要商品价格操作
///
///
[HttpPost]
public ActionResult MarketMajorQuoteOper()
{
#region Request + new MarketMajorQuote_info
string type = Request["Type"] ?? "",
marketMajorQuoteId = GetRequest("MarketMajorQuoteID"),
marketId = GetRequest("MarketID"),
majorGoodsName = GetRequest("MajorGoodsName"),
varietyCategoryNo = GetRequest("VarietyCategoryNo"),
quoteDate = GetRequest("QuoteDate"),
amount = GetRequest("Amount"),
unitId = GetRequest("UnitID"),
quoteHigh = GetRequest("QuoteHigh"),
quoteLow = GetRequest("QuoteLow"),
quoteAverage = GetRequest("QuoteAverage");
MarketMajorQuote_info majorQuoteInfo = new MarketMajorQuote_info
{
MajorGoodsName = majorGoodsName,
VarietyCategoryNo = varietyCategoryNo,
QuoteDate = quoteDate,
MarketID = marketId,
Amount = amount,
UnitID = unitId,
QuoteHigh = quoteHigh,
QuoteLow = quoteLow,
QuoteAverage = quoteAverage,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
majorQuoteInfo.UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lcSql = majorQuoteInfo.InsertSql();
break;
case "Edit":
if (!string.IsNullOrEmpty(marketMajorQuoteId))
{
majorQuoteInfo.MarketMajorQuoteID = marketMajorQuoteId;
lcSql = majorQuoteInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(marketMajorQuoteId))
{
majorQuoteInfo.MarketMajorQuoteID = marketMajorQuoteId;
lcSql = majorQuoteInfo.DeleteSql();
}
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 主要商品价格查询页面
///
///
public ActionResult MarketMajorQuoteQry()
{
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
//ViewBag.SelMajorGoodsNameInfo = GetData.Instance.GetSelStr(MajorSpecials_info.cMajorSpecialName, MajorSpecials_info.cMajorSpecialName, Tn.MajorSpecials, MajorSpecials_info.cIsLock + "='N' ", UserSessionInfo.DBConn);
ViewBag.SelMajorGoodsNameInfo = GetData.Instance.GetSelStr(VarietyCategory_info.cVarietyCategoryNo,
VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
VarietyCategory_info.cIsMajorCost + "='Y' AND " + VarietyCategory_info.cVarietyCategoryNo + "!='10000'", UserSessionInfo.DBConn);
ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(MarketMajorQuote_info.cUnitID, Tn.MarketMajorQuote, UserSessionInfo.DBConn);
return View();
}
///
/// 复称情况记录页面
///
///
public ActionResult WeightCheckLogList()
{
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 复称情况记录操作
///
///
[HttpPost]
public ActionResult WeightCheckLogOper()
{
#region Request + new WeightCheckLog_info + new Sys_AttachFiles
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
totalCount = GetRequest("TotalCount"),
accurateCount = GetRequest("AccurateCount"),
sellerId = GetRequest("SellerID"),
foodName = GetRequest("FoodName"),
result = GetRequest("Result"),
executor = GetRequest("Executor"),
logDate = GetRequest("LogDate"),
fileTitle = GetRequest("FileTitle"),
marketId= UserSessionInfo.MarketId;
string fileInfo = Request["FileInfo"];
string fileName = Request["FileName"];
string fileExt = Request["FileExt"];
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
WeightCheckLog_info weightCheckLogInfo = new WeightCheckLog_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
TotalCount = totalCount,
AccurateCount = accurateCount,
SellerID = sellerId,
FoodName = foodName,
Result = result,
Executor = executor,
LogDate = logDate,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID=UserSessionInfo.UserInfo.UserID
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.WeightCheckLog, WeightCheckLog_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.WeightCheckLog,
ColumnId = WeightCheckLog_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID,
FileName = fileName,
FileExt = fileExt
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
lcSql = weightCheckLogInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
}
case "Edit":
if (!string.IsNullOrEmpty(id))
{
weightCheckLogInfo.ID = id;
lcSql = weightCheckLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.WeightCheckLog + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type!="Add"&&UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 复称情况查询页面
///
///
public ActionResult WeightCheckLogQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
///
/// 消防检查记录页面
///
///
public ActionResult FireProtectInspectLogList()
{
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 消防检查记录操作
///
///
[HttpPost]
public ActionResult FireProtectInspectLogOper()
{
#region Request + new FireProtect_InspectLog_info + new Sys_AttachFiles
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
marketId = GetRequest("MarketID"),
content = GetRequest("Content"),
problem = GetRequest("Problem"),
inspector = GetRequest("Inspector"),
result = GetRequest("Result"),
logDate = GetRequest("LogDate"),
fileTitle = GetRequest("FileTitle");
string fileInfo = Request["FileInfo"];
string fileName = Request["FileName"];
string fileExt = Request["FileExt"];
//if (string.IsNullOrEmpty(marketId))
// return Content("操作失败！，【当前用户不能进行相关操作！】");
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
FireProtect_InspectLog_info fireProtectInspectLogInfo =
new FireProtect_InspectLog_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
Content = content,
Problem = problem,
Inspector = inspector,
Result = result,
LogDate = logDate,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.FireProtect_InspectLog, FireProtect_InspectLog_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.FireProtect_InspectLog,
ColumnId = FireProtect_InspectLog_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID,
FileName = fileName,
FileExt = fileExt
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
lcSql = fireProtectInspectLogInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
}
case "Edit":
if (!string.IsNullOrEmpty(id))
{
fireProtectInspectLogInfo.ID = id;
lcSql = fireProtectInspectLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.FireProtect_InspectLog + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 消防检查查询页面
///
///
public ActionResult FireProtectInspectLogQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
///
/// 市场卫生记录页面
///
///
public ActionResult CleansingCheckLogList()
{
ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
Tn.AssessLevel, UserSessionInfo.DBConn,false);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 市场卫生记录操作
///
///
[HttpPost]
public ActionResult CleansingCheckLogOper()
{
#region Request + new CleansingCheckLog_info + new Sys_AttachFiles
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
marketId = GetRequest("MarketID"),
assessLevelId = GetRequest("AssessLevelID"),
executor = GetRequest("Executor"),
selfCheckFlag = GetRequest("SelfCheckFlag"),
reason = GetRequest("Reason"),
logDate = GetRequest("LogDate"),
fileTitle = GetRequest("FileTitle");
string fileInfo = Request["FileInfo"];
string fileName = Request["FileName"];
string fileExt = Request["FileExt"];
//if (string.IsNullOrEmpty(marketId))
// return Content("操作失败！，【当前用户不能进行相关操作！】");
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
CleansingCheckLog_info cleansingCheckLogInfo =
new CleansingCheckLog_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
AssessLevelID = assessLevelId,
Executor = executor,
SelfCheckFlag = selfCheckFlag,
Reason = reason,
LogDate = logDate,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.CleansingCheckLog, CleansingCheckLog_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.CleansingCheckLog,
ColumnId = CleansingCheckLog_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID,
FileName = fileName,
FileExt = fileExt
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
lcSql = cleansingCheckLogInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
case "Edit":
if (!string.IsNullOrEmpty(id))
{
cleansingCheckLogInfo.ID = id;
lcSql = cleansingCheckLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.CleansingCheckLog + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate2(type, fileInfo, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 市场卫生查询页面
///
///
public ActionResult CleansingCheckLogQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
Tn.AssessLevel, UserSessionInfo.DBConn,false);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
///
/// 市场值班记录页面
///
///
public ActionResult DutyLogList()
{
ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
Tn.AssessLevel, UserSessionInfo.DBConn, false);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 市场值班记录操作
///
///
[HttpPost]
public ActionResult DutyLogOper()
{
#region Request + new DutyLog_info
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
watchers = GetRequest("Watchers"),
notes = GetRequest("Notes"),
content = GetRequest("Content"),
logDate = GetRequest("LogDate"),
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
DutyLog_info dutyLogInfo =
new DutyLog_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
Watchers=watchers,
Content=content,
Notes=notes,
LogDate = logDate,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
lcSql = dutyLogInfo.InsertSql();
break;
case "Edit":
if (!string.IsNullOrEmpty(id))
{
dutyLogInfo.ID = id;
lcSql = dutyLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.DutyLog + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 市场值班查询页面
///
///
public ActionResult DutyLogQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
Tn.AssessLevel, UserSessionInfo.DBConn, false);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
///
/// 市场制度记录页面
///
///
public ActionResult MarketStatuteList()
{
ViewBag.SelStatuteTypeInfo = GetData.Instance.GetSelStr(MarketStatute_info.cStatuteType, Tn.MarketStatute, UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 市场制度记录操作
///
///
[ValidateInput(false)]
[HttpPost]
public ActionResult MarketStatuteOper()
{
#region Request + new MarketStatute_info
string type = Request["Type"] ?? "",
statuteId = GetRequest("StatuteID"),
statuteType = GetRequest("StatuteType"),
statuteTitle = GetRequest("StatuteTitle"),
statuteContent = GetRequest("StatuteContent"),
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
MarketStatute_info dutyLogInfo =
new MarketStatute_info(statuteId, UserSessionInfo.DBConn)
{
StatuteID = statuteId,
StatuteType = statuteType,
StatuteTitle = statuteTitle,
StatuteContent = statuteContent,
MarketID = marketId,
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
lcSql = dutyLogInfo.InsertSql();
break;
case "Edit":
if (!string.IsNullOrEmpty(statuteId))
{
dutyLogInfo.StatuteID = statuteId;
lcSql = dutyLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(statuteId))
lcSql = "DELETE " + Tn.MarketStatute + " WHERE StatuteID='" + statuteId + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 市场制度查询页面
///
///
public ActionResult MarketStatuteQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelStatuteTypeInfo = GetData.Instance.GetSelStr(MarketStatute_info.cStatuteType, Tn.MarketStatute, UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
///
/// 市场分布和管理人员示意图页面
///
///
public ActionResult MarketChartList()
{
ViewBag.SelChartTypeInfo = GetData.Instance.GetSelStr("ChartTypeID", "MarketChart", UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 市场分布和管理人员示意图上传
///
///
[HttpPost]
public ActionResult MarketChartOper()
{
#region Request + new MarketChart_info
string type = Request["CurdType"],
id = GetRequest("ID"),
chartTypeId = GetRequest("ChartTypeID"),
fileTitle = chartTypeId == "1" ? "市场分布示意图" : "市场管理人员网络图",
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
MarketChart_info marketChartInfo =
new MarketChart_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
ChartTypeID = chartTypeId,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
#endregion
string msg = "";
switch (type)
{
case "Add":
string lcSql = "SELECT ID FROM MarketChart WHERE MarketID='" + marketId + "' AND ChartTypeID='" + chartTypeId +
"'";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
if (loQuery.IsOpened && loQuery.RecCount > 0)
id = loQuery.CurrentTable.Rows[0]["ID"] + "";
Sys_AttachFiles_info loAttacthFile;
if (string.IsNullOrEmpty(id))
{
try
{
lcSql = marketChartInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile = new Sys_AttachFiles_info(Tn.MarketChart, MarketChart_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.MarketChart,
ColumnId = MarketChart_info.cID,
SourceKey = identity,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
TimeCreated = DateTime.Now.ToShortDateString(),
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
}
else
{
marketChartInfo.ID = id;
lcSql = marketChartInfo.UpdateSql();
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
loAttacthFile = new Sys_AttachFiles_info(Tn.MarketChart, MarketChart_info.cID, id,
UserSessionInfo.DBConn)
{
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
if (!string.IsNullOrEmpty(loAttacthFile.AttachID))
type = "Edit";
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
}
break;
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 附件相关操作
///
///
///
///
///
///
///
///
public ActionResult AttachFileUpdate(string type, string tableId, string columnId, string sourceKey, string fileTitle, string description)
{
//string oldPath;
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(tableId, columnId, sourceKey,
UserSessionInfo.DBConn)
{
TableId = tableId,
ColumnId = columnId,
SourceKey = sourceKey,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
string msg = "";
GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg);
//return Content();
string lcRetval = msg.Contains("成功")
? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success")
: SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error");
ResultJson msgJson = SysBaseLibs.JsonHelper.Instance.Deserialize(lcRetval);
msgJson.ErrorInfo = msg;
return Content(msgJson.ToJson());
}
#endregion
#region 商品质量管理
///
/// 重要商品来源录入页面
///
///
public ActionResult MajorGoodsLogList()
{
ViewBag.SelSuppliersInfo = GetData.Instance.GetSelStr(Suppliers_info.cSupplierID, Suppliers_info.cName, Tn.Suppliers, UserSessionInfo.DBConn, false);
//ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelVarietyCategoryNameInfo = GetData.Instance.GetSelStr(VarietyCategory_info.cVarietyCategoryNo,
VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
VarietyCategory_info.cIsMajorSrc + "='Y' AND " + VarietyCategory_info.cVarietyCategoryNo +
"!='10000'", UserSessionInfo.DBConn);
ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(MajorGoodsLog_info.cUnitID, Tn.MajorGoodsLog, UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 " , UserSessionInfo.DBConn);
return View();
}
///
/// 重要商品来源录入操作
///
///
[HttpPost]
public ActionResult MajorGoodsLogOper()
{
#region Request + new MajorGoodsLog_info
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
//majorGoodsTypeId = GetRequest("MajorGoodsTypeID"),
varietyCategoryNo = GetRequest("VarietyCategoryNo"),
varietyCategoryName = GetRequest("VarietyCategoryName"),
sellerId = GetRequest("SellerID"),
totalCount = GetRequest("TotalCount"),
supplierId = GetRequest("SupplierID"),
quarantineUnit = GetRequest("QuarantineUnit"),
unitId = GetRequest("UnitID"),
stockTime = GetRequest("StockTime"),
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
MajorGoodsLog_info majorGoodsLogInfo =
new MajorGoodsLog_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
MajorGoodsTypeID = "0",
VarietyCategoryNo = varietyCategoryNo,
VarietyCategoryName= varietyCategoryName,
SellerID = sellerId,
SupplierID = supplierId,
StockTime = stockTime,
TotalCount = totalCount,
UnitID = unitId,
QuarantineUnit = quarantineUnit,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
//majorGoodsLogInfo.ID=
lcSql = majorGoodsLogInfo.InsertSql();
break;
case "Edit":
if (!string.IsNullOrEmpty(id))
{
majorGoodsLogInfo.ID = id;
lcSql = majorGoodsLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.MajorGoodsLog + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 重要商品来源查询页面
///
///
public ActionResult MajorGoodsLogQry()
{
//ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
UserSessionInfo.DBConn);
return View();
}
///
/// 不合格商品退市录入页面
///
///
public ActionResult GoodsRecallLogList()
{
ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(GoodsRecallLog_info.cUnitID, Tn.GoodsRecallLog, UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 ", UserSessionInfo.DBConn);
return View();
}
///
/// 不合格商品退市录入操作
///
///
[HttpPost]
public ActionResult GoodsRecallLogOper()
{
#region Request + new GoodsRecallLog_info + new Sys_AttachFiles_info
string type = Request["Type"] ?? "" ,
id = GetRequest("ID"),
goodsName = GetRequest("GoodsName"),
supplier = GetRequest("Supplier"),
sellerId = GetRequest("SellerID"),
saleCount = GetRequest("SaleCount"),
unitId = GetRequest("UnitID"),
produceBatch = GetRequest("ProduceBatch"),
tradeMark = GetRequest("TradeMark"),
saleTime = GetRequest("SaleTime"),
executor = GetRequest("Executor"),
result = GetRequest("Result"),
recallReason = GetRequest("RecallReason"),
fileTitle = GetRequest("FileTitle"),
marketId = UserSessionInfo.MarketId;
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
GoodsRecallLog_info goodsRecallLogInfo =
new GoodsRecallLog_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
GoodsName=goodsName,
Supplier=supplier,
SellerID=sellerId,
SaleCount=saleCount,
UnitID=unitId,
TradeMark=tradeMark,
ProduceBatch=produceBatch,
SaleTime=saleTime,
Executor=executor,
RecallReason=recallReason,
Result=result,
ModelType="",
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.GoodsRecallLog, GoodsRecallLog_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.GoodsRecallLog,
ColumnId = GoodsRecallLog_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
lcSql = goodsRecallLogInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
if (string.IsNullOrEmpty(identity))
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
case "Edit":
if (!string.IsNullOrEmpty(id))
{
goodsRecallLogInfo.ID = id;
lcSql = goodsRecallLogInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.GoodsRecallLog + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 不合格商品退市查询页面
///
///
public ActionResult GoodsRecallLogQry()
{
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 检测数据录入页面
///
///
public ActionResult CheckDataList()
{
if (UserSessionInfo.IsMarketSysAccount)
{
ViewBag.IsMarketSysAccount = "0";
ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
"IsLock=0 AND IsSystem=1", UserSessionInfo.DBConn);
}
else
{
ViewBag.IsMarketSysAccount = "1";
ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
"IsLock=0 AND IsSystem=1 AND SeriesType='1' ", UserSessionInfo.DBConn);
}
ViewBag.IsSystem = UserSessionInfo.IsSystem ? "0" : "1";
ViewBag.MarketID = UserSessionInfo.MarketId;
ViewBag.RegionID = UserSessionInfo.UserInfo.RegionID;
ViewBag.CheckUser = UserSessionInfo.UserInfo.UserCode;
ViewBag.CheckUnit = SysDataLibs.AppEnv.GetTextByID("FarmID", UserSessionInfo.UserInfo.FarmID, "ShortNames", "Farms",
UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
UserSessionInfo.DBConn);
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT [RegionID],[Names],[FatherRegionID],[Depth] From Regions WHERE IsLock='0'");
var regionResult = GetData.Instance.GetComboTree(loQuery, "RegionID", "FatherRegionID", "Names", "RegionID=861111",pcDepthVal:"2");
ViewBag.SelRegionInfo = JsonConvert.SerializeObject(regionResult);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelCheckMethodInfo = GetData.Instance.GetSelStrDistinct("CheckMethodId", "CheckMethodName", "CheckMethod", "IsLock='N'", UserSessionInfo.DBConn);
//ViewBag.SelCheckProjectTypeInfo = GetData.Instance.GetSelStr("CheckProjectTypeID", "Name", "CheckProjectType", "IsLock=0", UserSessionInfo.DBConn);
ViewBag.SelLittleKindInfo = GetData.Instance.GetSelStr("VarietyCategoryNo", "VarietyCategoryName", "VarietyCategory", "IsLock='N' AND Depth=1 ORDER by VarietyCategoryNo", UserSessionInfo.DBConn);
//ViewBag.SelSampleNameInfo = GetData.Instance.GetSelStr("SpecialsID", "Name", "Specials", "IsLock=0 ORDER by Name,SortNumber", UserSessionInfo.DBConn);
ViewBag.SelCorpKindInfo = GetData.Instance.GetSelStr("Names", "Names", "CorporationType", UserSessionInfo.DBConn);
ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 ", UserSessionInfo.DBConn);
return View();
}
///
/// 检测数据录入操作
///
///
[HttpPost]
public ActionResult CheckDataOper()
{
#region Request + new CheckData_info
string type = GetRequest("CurdType"),
id = GetRequest("ID"),
checkUnit = GetRequest("CheckUnit"),
memo = GetRequest("Memo"),
isSelf = GetRequest("IsSelf"),
marketId = GetRequest("MarketID"),
sendDate = GetRequest("SendDate"),
machineMaker = GetRequest("MachineMaker"),
corpKind = GetRequest("CorpKind"),
//corpName = GetRequest("CorpName"),
corpName = GetRequest("StallNo"), //被检对象和摊位号合并
produceUnit = GetRequest("ProduceUnit"),
produceDate = GetRequest("ProduceDate"),
clientIndexId = GetRequest("ClientIndexID"),
machineId = GetRequest("MachineID"),
checkTime = GetRequest("CheckTime"),
checkTotal = GetRequest("CheckTotal"),
checkResult = GetRequest("CheckResult"),
checkValue = GetRequest("CheckValue"),
standardValue = GetRequest("StandardValue"),
sampleId = GetRequest("SampleId"),
sampleName = GetRequest("SampleName"),
//littleKindName = GetRequest("LittleKindName"),
checkProjectTypeId = GetRequest("CheckProjectTypeID"),
habitatId = GetRequest("HabitatID"),
checkUser = GetRequest("CheckUser"),
stallNo = GetRequest("StallNo"),
licenseNo = GetRequest("LicenseNo"),
licenseName = GetRequest("LicenseName"),
idCode = GetRequest("IdCode"),
cardIndex = GetRequest("CardIndex");
//if (string.IsNullOrEmpty(marketId))
// return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
CheckData_info checkDataInfo = new CheckData_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
CorpName = corpName,
CheckUnit = checkUnit,
CheckProjectTypeID = checkProjectTypeId,
CheckValue = checkValue,
CheckTotal = checkTotal,
CheckResult = checkResult,
CheckTime = checkTime,
CheckUser = checkUser,
SampleId = sampleId,
SampleName = sampleName,
IsSelf = isSelf,
SendDate = sendDate,
ClientIndexID = clientIndexId,
MachineID = machineId,
MachineMaker = machineMaker,
ProduceDate = produceDate,
ProduceUnit = produceUnit,
HabitatID = habitatId,
Memo = memo,
CheckLimit = standardValue,
CorpKind = corpKind,
UploadTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
StallNo = corpName,
LicenseNo = licenseNo,
LicenseName = licenseName,
IdCode = idCode,
CardIndex = cardIndex
};
#endregion
string lcSql = "";
switch (type)
{
case "Add":
lcSql = checkDataInfo.InsertSql();
lcSql+= " UPDATE VarietyCategory SET [CheckCount]=[CheckCount]+1 WHERE [VarietyCategoryNo]='"+ sampleId + "'";
break;
case "Edit":
if (!string.IsNullOrEmpty(id))
{
checkDataInfo.ID = id;
lcSql = checkDataInfo.UpdateSql();
}
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
//添加上传接口 --- add by zhangwy --update by Yue 2018.06.15
if (type== "Add")
{
//CheckDataTransfersLibs.ytCheckDataUpload loytCheckDataUpload = new CheckDataTransfersLibs.ytCheckDataUpload();
//loytCheckDataUpload.ExcuteUploadYTThread(checkDataInfo);
new List {checkDataInfo}.DataPush();
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
//[HttpPost]
//public ActionResult UploadCheckData()
//{
// string path = "/Upload/CheckDataFile/";
// UploadResult uploadResult = UploadFileHelper.Instance.UploadFiles(path, "xlsx", Request, Server);
// string virtualPath = uploadResult.VirtualPathUrls[0].ToString();
// ThreadLog.LogInfo("1:"+virtualPath+"");
// string errorMsg = "";
// var dataUploadDtos = ExcelHelper2.ExcelToEntityList(new Dictionary() { { "CheckUnit", "被检测单位" }, { "MarketID", "市场编号" }, { "StallNo", "摊位号" }, { "CheckProjectTypeID", "检测项目编号" }, { "SampleId", "品种编号" }, { "SampleName", "品种名称" }, { "CheckResult", "检测结果（合格/不合格）" }, { "UploadTime", "检测日期" }, { "CheckUser", "检测员" }, { "Memo", "备注" } },
// virtualPath, out errorMsg);//, { "StandardValue", "检测标准值" }, { "StandardUnit", "单位" }, { "IsSelf", "是否自检（1:是,0:否）" }, { "CheckTime", "送检日期" }, { "CheckValue", "检测值" }
// rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("select * from "+Tn.CheckProjectType+" where IsLock=0;");
// List typeList = new List();
// if (loQuery != null && loQuery.IsOpened)
// {
// loQuery.MoveFirst();
// for (int i = 0; i < loQuery.RecCount; i++)
// {
// CheckProjectType_info loInfo = new CheckProjectType_info()
// {
// CheckProjectTypeID = loQuery.GetString("CheckProjectTypeID"),
// StandardValue = loQuery.GetString("StandardValue"),
// };
// typeList.Add(loInfo);
// loQuery.MoveNext();
// }
// }
// StringBuilder sb = new StringBuilder();
// int indexTmp = 1;
// string msg="",errormsg = "";
// foreach (var dto in dataUploadDtos)
// {
// if (string.IsNullOrEmpty(dto.CheckUnit) || string.IsNullOrEmpty(dto.MarketID))
// {
// errormsg = "被检单位或市场编号输入有误！";
// }
// if (dto.CheckProjectTypeID == 0||dto.UploadTime==null)
// {
// errormsg = "检测项目编号或者检测时间输入有误！";
// }
// if (string.IsNullOrEmpty(dto.SampleName) || string.IsNullOrEmpty(dto.SampleId))
// {
// errormsg = "品种编号或名称输入有误！";
// }
// if (string.IsNullOrEmpty(dto.CheckResult) || string.IsNullOrEmpty(dto.StallNo))
// {
// errormsg = "检测结果或摊位号输入有误！";
// }
// if (!string.IsNullOrEmpty(errorMsg))
// {
// msg += $"第{indexTmp}行，" + errormsg + ".\r\n";
// indexTmp++;
// continue;
// }
// var pt = dto.CheckProjectTypeID+"";
// CheckProjectType_info loProjectTypeInfo = typeList.FirstOrDefault(i => i.CheckProjectTypeID == pt);
// sb.Append(
// $"insert into CheckData(MarketID,CheckUnit,CheckUser,CheckProjectTypeID,SampleId,SampleName,CheckLimit,CheckValue,CheckResult,UploadTime,CheckTime,CorpName,IsSelf,CheckTotal,UserID,Memo) VALUES ('{dto?.MarketID}','{dto?.CheckUnit}','{dto?.CheckUser}',{dto?.CheckProjectTypeID},'{dto?.SampleId}','{dto?.SampleName}',{loProjectTypeInfo?.StandardValue},{loProjectTypeInfo?.StandardValue??"0"},'{dto?.CheckResult}','{dto?.UploadTime}','{dto?.UploadTime}','{dto?.StallNo}',1,1,'{UserSessionInfo.UserInfo.UserID}','{dto?.Memo}');\r\n");
// indexTmp++;
// }
// bool lbRetval = false;
// if (!string.IsNullOrEmpty(sb.ToString()))
// {
// if (UserSessionInfo.DBConn.ExcuteSqlTran(sb.ToString()))
// {
// lbRetval = true;
// }
// else
// {
// msg += UserSessionInfo.DBConn.ErrorMsg;
// }
// }
// return Json(new { Success = lbRetval,Msg = msg });
//}
[HttpPost]
public ActionResult UploadCheckData()
{
string path = "/Upload/CheckDataFile/";
UploadResult uploadResult = UploadFileHelper.Instance.UploadFiles(path, "xls", Request, Server);
string virtualPath = uploadResult.VirtualPathUrls[0].ToString();
ThreadLog.LogInfo("1:" + virtualPath + "");
string errorMsg = "";
var dataUploadDtos = ExcelHelper2.ExcelToEntityList(new Dictionary() { { "CheckTime", "检测日期" }, { "CheckedMarketName", "被检市场名称" }, { "CheckedUnitName", "被检单位名称" }, { "StallNumber", "摊位号" }, { "CheckedMan", "被检人姓名" }, { "CheckBigItem", "检测项目大类" }, { "CheckLittleItem", "检测项目小类" }, { "CheckBigVariety", "检测品种大类" }, { "CheckLittleVariety", "检测品种小类" }, { "CheckResult", "检测结果" } , { "CheckValue", "检测值" }, { "CheckLimit", "检测值参考范围" }, { "CheckRecord", "检测依据" }, { "CheckManufacturer", "检测厂商" }, { "CheckDevice", "检测设备" }, { "CheckMan", "检测人" }, { "CheckUnitName", "检测单位名称" } },
virtualPath, out errorMsg);
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("select * from SysMarketToYtMapping;");
Dictionary mDic = new Dictionary();
if (loQuery != null && loQuery.IsOpened)
{
loQuery.MoveFirst();
for (int i = 0; i < loQuery.RecCount; i++)
{
string lcMarketName = loQuery.GetString("MarketNameCheck");
string lcMarketId = loQuery.GetString("SysMarketId");
mDic.Add(lcMarketName,lcMarketId);
loQuery.MoveNext();
}
}
rsQuery loVarQuery = UserSessionInfo.DBConn.OpenQuery("select * from VarietyCategory;");
Dictionary varDic = new Dictionary();
if (loVarQuery != null && loVarQuery.IsOpened)
{
loVarQuery.MoveFirst();
for (int i = 0; i < loVarQuery.RecCount; i++)
{
string lcVarietyCategoryNo = loVarQuery.GetString("VarietyCategoryNo");
string lcVarietyCategoryName = loVarQuery.GetString("VarietyCategoryName");
varDic.Add(lcVarietyCategoryNo, lcVarietyCategoryName);
loVarQuery.MoveNext();
}
}
StringBuilder sb = new StringBuilder();
int indexTmp = 0;
string msg = "", errormsg = "";
foreach (var dto in dataUploadDtos)
{
errormsg = ""; indexTmp++;
var littleVarKeyValue = varDic.FirstOrDefault(i => i.Value == dto.CheckLittleVariety);
if (string.IsNullOrEmpty(littleVarKeyValue.Key))
{
errormsg = "品种编号或名称输入有误！";
}
var marketKeyValue = mDic.FirstOrDefault(i => i.Key == dto.CheckedMarketName);
if (string.IsNullOrEmpty(marketKeyValue.Value))
{
errormsg = "被检单位或市场编号输入有误！";
}
if (!string.IsNullOrEmpty(errormsg))
{
msg += $"第{indexTmp}行，" + errormsg + ".\r\n";
continue;
}
string checkValue = string.IsNullOrEmpty(dto.CheckValue) ? "0" : dto.CheckValue.Replace("%","").Replace("mg/kg","");
string checkRsult = dto.CheckResult == "阴性(未检出)" ? "合格" : "不合格";
sb.Append(
$"insert into CheckData(MarketID,CheckUnit,CheckUser,CheckProjectTypeID,SampleId,SampleName,CheckLimit,CheckValue,CheckResult,UploadTime,CheckTime,CorpName,IsSelf,CheckTotal,UserID,Memo,MachineID,MachineMaker) VALUES ('{marketKeyValue.Value}','{dto.CheckUnitName}','{dto?.CheckMan}',{6},'{littleVarKeyValue.Key}','{littleVarKeyValue.Value}',{70.00},{checkValue},'{checkRsult}','{dto?.CheckTime}','{dto?.CheckTime}','{dto?.StallNumber}',1,1,'{UserSessionInfo.UserInfo.UserID}','{"t070201"}','{dto.CheckDevice}','{dto.CheckManufacturer}');\r\n");
indexTmp++;
}
bool lbRetval = false;
if (!string.IsNullOrEmpty(sb.ToString()))
{
if (UserSessionInfo.DBConn.ExcuteSqlTran(sb.ToString()))
{
this.LogInfo(sb.ToString());
lbRetval = true;
}
else
{
msg += UserSessionInfo.DBConn.ErrorMsg;
}
}
return Json(new { Success = lbRetval, Msg = msg });
}
///
/// 检测数据查询页面
///
///
public ActionResult CheckDataQry()
{
if (UserSessionInfo.IsMarketSysAccount)
{
ViewBag.IsMarketSysAccount = "0";
ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
"IsLock=0 AND IsSystem=1", UserSessionInfo.DBConn);
}
else
{
ViewBag.IsMarketSysAccount = "1";
ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
"IsLock=0 AND IsSystem=1 AND SeriesType='1' ", UserSessionInfo.DBConn);
}
//ViewBag.IsSystem = UserSessionInfo.IsSystem ? "0" : "1";
ViewBag.MarketID = UserSessionInfo.MarketId;
ViewBag.RegionID = UserSessionInfo.UserInfo.RegionID;
//ViewBag.CheckUser = UserSessionInfo.UserInfo.UserCode;
ViewBag.CheckUnit = SysDataLibs.AppEnv.GetTextByID("FarmID", UserSessionInfo.UserInfo.FarmID, "ShortNames", "Farms",
UserSessionInfo.DBConn);
//ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
// Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
// UserSessionInfo.DBConn);
//ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT [RegionID],[Names],[FatherRegionID],[Depth] From Regions WHERE IsLock='0'");
var regionResult = GetData.Instance.GetComboTree(loQuery, "RegionID", "FatherRegionID", "Names", "RegionID=861111", pcDepthVal: "2");
ViewBag.SelRegionInfo = JsonConvert.SerializeObject(regionResult);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
//ViewBag.SelCheckMethodInfo = GetData.Instance.GetSelStrDistinct("CheckMethod", "CheckMethod", "CheckProjectType", "IsLock=0", UserSessionInfo.DBConn);
ViewBag.SelCheckMethodInfo = GetData.Instance.GetSelStrDistinct("CheckMethodId", "CheckMethodName", "CheckMethod", "IsLock='N'", UserSessionInfo.DBConn);
ViewBag.SelCheckProjectTypeInfo = GetData.Instance.GetSelStr("CheckProjectTypeID", "Name", "CheckProjectType", "IsLock=0", UserSessionInfo.DBConn);
//ViewBag.SelLittleKindInfo = GetData.Instance.GetSelStr("LittleKindID", "Name", "LittleKind", "IsLock=0 ORDER by Name", UserSessionInfo.DBConn);
ViewBag.SelLittleKindInfo = GetData.Instance.GetSelStr("VarietyCategoryNo", "VarietyCategoryName", "VarietyCategory", "IsLock='N' AND Depth=1 ORDER by VarietyCategoryNo", UserSessionInfo.DBConn);
ViewBag.SelSampleNameInfo = GetData.Instance.GetSelStr("SpecialsID", "Name", "Specials", "IsLock=0 ORDER by Name,SortNumber", UserSessionInfo.DBConn);
ViewBag.SelCorpKindInfo = GetData.Instance.GetSelStr("Names", "Names", "CorporationType", UserSessionInfo.DBConn);
ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 ", UserSessionInfo.DBConn);
return View();
}
#endregion
#region 消费维权及信用管理
///
/// 市场违规行为记录页面
///
///
public ActionResult MarketViolationsList()
{
ViewBag.SelLogTypeInfo = GetData.Instance.GetSelStr(MarketViolations_info.cLogType, Tn.MarketViolations,
UserSessionInfo.DBConn);
ViewBag.SelResultInfo = GetData.Instance.GetSelStr(MarketViolations_info.cResult, Tn.MarketViolations,
UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 市场违规行为记录操作
///
///
[HttpPost]
public ActionResult MarketViolationsOper()
{
#region Request + new MarketViolations_info + new Sys_AttachFiles
string type = Request["Type"] ?? "",
violationsNo = GetRequest("ViolationsNo"),
logType = GetRequest("LogType"),
result = GetRequest("Result"),
marketId = GetRequest("MarketID"),
logContent = GetRequest("LogContent"),
checher = GetRequest("Checher"),
logDate = GetRequest("LogDate"),
fileTitle = GetRequest("FileTitle");
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
MarketViolations_info marketViolationsInfo = new MarketViolations_info(violationsNo, UserSessionInfo.DBConn)
{
MarketID = marketId,
LogType = logType,
LogContent = logContent,
Checher = checher,
Result = result,
LogDate = logDate,
TimeLastMod = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserIDLastMod = UserSessionInfo.UserInfo.UserID,
IsRead = "N"
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.MarketViolations, MarketViolations_info.cViolationsNo, violationsNo,
UserSessionInfo.DBConn)
{
TableId = Tn.MarketViolations,
ColumnId = MarketViolations_info.cViolationsNo,
SourceKey = violationsNo,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
marketViolationsInfo.TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
marketViolationsInfo.ViolationsNo = RandomUtil.GetGUID();
lcSql = marketViolationsInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
}
case "Edit":
if (!string.IsNullOrEmpty(violationsNo))
{
//marketViolationsInfo.ViolationsNo = violationsNo;
lcSql = marketViolationsInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(violationsNo))
lcSql = "DELETE " + Tn.MarketViolations + " WHERE ViolationsNo='" + violationsNo + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 市场违规行为查询页面
///
///
public ActionResult MarketViolationsQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelResultInfo = GetData.Instance.GetSelStr(MarketViolations_info.cResult, Tn.MarketViolations,
UserSessionInfo.DBConn);
ViewBag.SelLogTypeInfo = GetData.Instance.GetSelStr(MarketViolations_info.cLogType, Tn.MarketViolations,
UserSessionInfo.DBConn);
return View();
}
///
/// 经营户违规行为记录页面
///
///
public ActionResult MarketSellerViolationsList()
{
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelViolationTypeInfo = GetData.Instance.GetSelStr(SellerViolationType_info.cViolationTypeID,
SellerViolationType_info.cName, Tn.SellerViolationType,"IsLock=0", UserSessionInfo.DBConn);
ViewBag.SelSellerRewardTypeInfo = GetData.Instance.GetSelStr(SellerRewardType_info.cSellerRewardTypeID,
SellerRewardType_info.cName, Tn.SellerRewardType, "IsLock=0", UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 经营户违规行为记录操作
///
///
[HttpPost]
public ActionResult MarketSellerViolationsOper()
{
#region Request + new SellerViolations_info + new Sys_AttachFiles
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
violationTypeId = GetRequest("ViolationTypeID"),
sellerRewardTypeId = GetRequest("SellerRewardTypeID"),
marketId = GetRequest("MarketID"),
logContent = GetRequest("LogContent"),
logDate = GetRequest("LogDate"),
sellerId = GetRequest("MarketSellerID"),
fileTitle = GetRequest("FileTitle");
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
SellerViolations_info sellerViolationsInfo = new SellerViolations_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
ViolationTypeID = violationTypeId,
LogContent = logContent,
SellerRewardTypeID = sellerRewardTypeId,
SellerID=sellerId,
LogDate = logDate,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID,
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.SellerViolations, SellerViolations_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.SellerViolations,
ColumnId = SellerViolations_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
lcSql = sellerViolationsInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
}
case "Edit":
if (!string.IsNullOrEmpty(id))
{
sellerViolationsInfo.ID = id;
lcSql = sellerViolationsInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.SellerViolations + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
/// 经营户违规行为查询页面
///
///
public ActionResult MarketSellerViolationsQry()
{
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelViolationTypeInfo = GetData.Instance.GetSelStr(SellerViolationType_info.cViolationTypeID,
SellerViolationType_info.cName, Tn.SellerViolationType, UserSessionInfo.DBConn);
ViewBag.SelSellerRewardTypeInfo = GetData.Instance.GetSelStr(SellerRewardType_info.cSellerRewardTypeID,
SellerRewardType_info.cName, Tn.SellerRewardType, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets,
UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
///
/// 投诉信息违规行为记录页面
///
///
public ActionResult ConsumerComplainList()
{
ViewBag.SelStallInfo= GetData.Instance.GetSelStr(Stalls_info.cStallID, Stalls_info.cName, Tn.Stalls, UserSessionInfo.MarketDataSql(false), UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
return View();
}
///
/// 投诉信息违规行为记录操作
///
///
[HttpPost]
public ActionResult ConsumerComplainOper()
{
#region Request + new ConsumerComplain_info + new Sys_AttachFiles
string type = Request["Type"] ?? "",
id = GetRequest("ID"),
stallId = GetRequest("StallID"),
consumer = GetRequest("Consumer"),
marketId = GetRequest("MarketID"),
sellerId = GetRequest("MarketSellerID"),
content = GetRequest("Content"),
logDate = GetRequest("LogDate"),
updateTime = GetRequest("UpdateTime"),
executor = GetRequest("Executor"),
result = GetRequest("Result"),
fileTitle = GetRequest("FileTitle");
if (string.IsNullOrEmpty(marketId))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
ConsumerComplain_info consumerComplainInfo = new ConsumerComplain_info(id, UserSessionInfo.DBConn)
{
MarketID = marketId,
StallID=stallId,
Consumer=consumer,
Content=content,
SellerID = sellerId,
Result = result,
Executor = executor,
LogDate = logDate,
UpdateTime = updateTime,// DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
UserID = UserSessionInfo.UserInfo.UserID
};
Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.ConsumerComplain, ConsumerComplain_info.cID, id,
UserSessionInfo.DBConn)
{
TableId = Tn.ConsumerComplain,
ColumnId = ConsumerComplain_info.cID,
SourceKey = id,
FileTitle = fileTitle,
TimeLastMod = DateTime.Now.ToShortDateString(),
//Description = description,
UserIDLastMod = UserSessionInfo.UserInfo.UserID
};
#endregion
string lcSql = "", msg = "";
switch (type)
{
case "Add":
try
{
lcSql = consumerComplainInfo.InsertSql();
lcSql += " SELECT @@IDENTITY AS ident ";
rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
string identity = loQuery.GetString("ident");
loAttacthFile.SourceKey = identity;
loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
catch
{
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
}
case "Edit":
if (!string.IsNullOrEmpty(id))
{
consumerComplainInfo.ID = id;
lcSql = consumerComplainInfo.UpdateSql();
}
break;
case "Del":
if (!string.IsNullOrEmpty(id))
lcSql = "DELETE " + Tn.ConsumerComplain + " WHERE ID='" + id + "'";
break;
}
if (string.IsNullOrEmpty(lcSql))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
{
if (string.IsNullOrEmpty(loAttacthFile.AttachID))
{
if (type == "Edit")
type = "Add";
if (type == "Del")
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
}
if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
}
return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
}
///
///投诉信息违规行为查询页面
///
///
public ActionResult ConsumerComplainQry()
{
ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
return View();
}
#endregion
///
/// 获取Requset[key]值，并ToSQL处理
///
///
///
///
private string GetRequest(string key, string type = "string")
{
string lcRetval = Request[key];
if (type.ToLower() == "int")
lcRetval = GetData.Instance.SetIntDefault(lcRetval);
return Utils.AreaToSQLcs(lcRetval);
}
}
}