public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
User user = new User()
{
Email = model.Email, Password = model.Password
};
user =
user = Repositorys.GetUserDetails(user);
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
var authTicket = new FormsAuthenticationTicket(1, user.Email, DateTime.Now, DateTime.Now.AddMinutes(20), false, user.Roles);
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
HttpContext.Response.Cookies.Add(authCookie);
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
}
static void Main(string[] args)
{
var nodes = findOpenData();
Repositorys aa = new Repositorys();
var makeconn = aa.Connection();
var select = aa.select(makeconn);
ShowOpenData(select);
Console.ReadKey();
}
public JsonResult SaveRepository([CustomizeValidator] WarehouseDto m)
{
var q = new Repositorys()
{
Id = m.Id,
Name = m.Name,
Address = m.Address
};
return(Json <string>(_warehouseRepository.Add(q), "保存成功!"));
}
/// <summary>
/// 获取数据列表(厂家，炉批号，质检报告)
/// </summary>
public PageModel GetDataListForPage(InOrderRequest request)
{
#region 搜索条件
List <Parameter> parameter = new List <Parameter>();
string where = " where 1=1 and Factory IS NOT NULL and BatchNumber IS NOT NULL and (a.UseCount+isnull(d.LockCount,0))>0 and a.ChackState=1";
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where += " and c.CompanyFullName like @keyword";
parameter.Add(new Parameter("@keyword", '%' + request.keyword + '%', DbType.String, null));
}
if (!string.IsNullOrWhiteSpace(request.MaterialCode))
{
where += " and a.MaterialCode=@MaterialCode";
parameter.Add(new Parameter("@MaterialCode", request.MaterialCode, DbType.String, null));
}
if (!string.IsNullOrEmpty(request.ProjectId))
{
where += " and a.ProjectId=@ProjectId";
parameter.Add(new Parameter("@ProjectId", request.ProjectId, DbType.String, null));
}
if (!string.IsNullOrWhiteSpace(request.WorkAreaCode))
{
where += " and a.WorkAreaCode=@WorkAreaCode";
parameter.Add(new Parameter("@WorkAreaCode", request.WorkAreaCode, DbType.String, null));
}
if (!string.IsNullOrWhiteSpace(request.CollarCode))
{
parameter.Add(new Parameter("@CollarCode", request.CollarCode, DbType.String, null));
}
parameter.Add(new Parameter("@WorkOrderItemId", request.WorkOrderItemId, DbType.Int32, null));
#endregion
var sql = @"select
c.CompanyFullName as InOrderSiteName,
a.InsertTime as InOrderTime,
a.ID as InOrderItemId,
a.Factory,
a.BatchNumber,
a.TestReportNo,
a.Count,
(a.UseCount+isnull(d.LockCount,0)) as PassCount
from TbRawMaterialStockRecord a
left join TbCompany c on a.SiteCode=c.CompanyCode
LEFT JOIN (
SELECT StockRecordId,SUM(LockCount) AS LockCount FROM TbRMProductionMaterialLockCount
WHERE SourceType=1 AND CollarCode=@CollarCode AND WorkOrderItemId=@WorkOrderItemId
GROUP BY StockRecordId
) AS d ON a.ID=d.StockRecordId";
try
{
var data = Repositorys <RawMaterialStockRecordResponse> .FromSqlToPage(sql + where, parameter, request.rows, request.page, "InOrderTime");
if (data.total == 0)
{
//查找最近的炉批号
var RawMaterial = GetLastRecordForRawMaterial(request);
if (RawMaterial != null)
{
var a = new RawMaterialStockRecordResponse()
{
InOrderTime = RawMaterial.InsertTime,
InOrderItemId = RawMaterial.ID,
Factory = RawMaterial.Factory,
BatchNumber = RawMaterial.BatchNumber,
TestReportNo = RawMaterial.TestReportNo,
Count = RawMaterial.Count,
PassCount = RawMaterial.UseCountS.Value
};
var b = Repository <TbCompany> .First(p => p.CompanyCode == RawMaterial.SiteCode);
if (b != null)
{
a.InOrderSiteName = b.ParentCompanyName;
}
data.rows = new List <RawMaterialStockRecordResponse>()
{
a
};
}
}
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取数据列表(明细)
/// </summary>
public PageModel GetDataDetialForPage(RawMaterialStockRequest request)
{
#region 模糊搜索条件
string where = " where 1=1 ";
where += " and a.MaterialCode='" + request.MaterialCode + "'";
if (!string.IsNullOrWhiteSpace(request.SiteCode))
{
where += " and a.SiteCode='" + request.SiteCode + "'";
}
else
{
where += " and a.SiteCode=''";
}
where += " and a.WorkAreaCode='" + request.WorkAreaCode + "'";
if (!string.IsNullOrEmpty(request.ProjectId))
{
where += " and a.ProjectId='" + request.ProjectId + "'";
}
if (!string.IsNullOrEmpty(request.ProcessFactoryCode))
{
where += " and s.ProcessFactoryCode='" + request.ProcessFactoryCode + "'";
}
if (request.IsOld)
{
where += " and ((a.LockCount+a.UseCount=0 and a.LockCount!=0) or a.ChackState>1)";
}
else
{
where += " and ((a.LockCount+a.UseCount!=0 or a.LockCount=0) and a.ChackState<=1)";
}
#endregion
try
{
var sql = @"select
a.ID,
a.Factory,
a.BatchNumber,
a.InsertTime,
a.Count,
a.LockCount,
a.UseCount,
a.HistoryCount,
a.ChackState,
tsoi.Enclosure,
tsoi.TestReportNo
from
TbRawMaterialStockRecord a
left join TbStorage s on a.StorageCode=s.StorageCode
LEFT JOIN TbSampleOrderItem tsoi ON tsoi.InOrderItemId=a.InOrderitemId";
//参数化
List <Dos.ORM.Parameter> para = new List <Dos.ORM.Parameter>();
var data = Repositorys <RawMaterialStockItemResponse> .FromSqlToPage(sql + where, para, request.rows, request.page, "ID", "desc");
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(RawMaterialStockRequest request)
{
#region 模糊搜索条件
string where = " where 1=1 ";
if (!string.IsNullOrWhiteSpace(request.MaterialName))
{
where += (" and b.MaterialName like '%" + request.MaterialName + "%'");
}
if (!string.IsNullOrWhiteSpace(request.SpecificationModel))
{
where += (" and b.SpecificationModel like '%" + request.SpecificationModel + "%'");
}
if (!string.IsNullOrWhiteSpace(request.SiteCode))
{
List <string> SiteList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 5); //站点
List <string> WorkAreaList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 4); //工区
string siteStr = string.Join("','", SiteList);
string workAreaStr = string.Join("','", WorkAreaList);
where += (" and (rms.SiteCode in('" + siteStr + "') or rms.WorkAreaCode in('" + workAreaStr + "'))");
}
if (!string.IsNullOrEmpty(request.ProjectId))
{
where += (" and rms.ProjectId='" + request.ProjectId + "'");
}
if (!string.IsNullOrEmpty(request.ProcessFactoryCode))
{
where += (" and c.ProcessFactoryCode='" + request.ProcessFactoryCode + "'");
}
if (!string.IsNullOrEmpty(request.RebarType))
{
where += (" and b.RebarType='" + request.RebarType + "'");
}
if (!string.IsNullOrWhiteSpace(request.IsQkl))
{
if (request.IsQkl == "是")
{
where += "and -1*((isnull(rms.LockCount,0)+isnull(rms.UseCount,0))-isnull(tbwork.WeightSmallPlan,0))>0";
}
else
{
where += "and (isnull(rms.LockCount,0)+isnull(rms.UseCount,0))-isnull(tbwork.WeightSmallPlan,0)>=0";
}
}
#endregion
try
{
var sql = @"select
rms.*,
b.MaterialName,
b.SpecificationModel,
c.ProcessFactoryCode,
c.StorageName,
cp1.CompanyFullName as SiteName,
cp2.CompanyFullName as WorkAreaName,
cp3.CompanyFullName as BranchName,
sdd2.DictionaryText as RebarTypeText,
sdd3.DictionaryText as MeasurementUnitText,
case when (isnull(rms.LockCount,0)+isnull(rms.UseCount,0))-isnull(tbwork.WeightSmallPlan,0)>=0 then 0 else -1*((isnull(rms.LockCount,0)+isnull(rms.UseCount,0))-isnull(tbwork.WeightSmallPlan,0)) end as QKl
from (
select
MaterialCode,
ProjectId,
SiteCode,
StorageCode,
WorkAreaCode,
SUM(COUNT) as COUNT,
SUM(LockCount) as LockCount,
SUM(UseCount) as UseCount
FROM TbRawMaterialStockRecord
group by MaterialCode,SiteCode,WorkAreaCode,StorageCode,ProjectId
)as rms
left join TbCompany cp1 on rms.SiteCode=cp1.CompanyCode
left join TbCompany cp2 on rms.WorkAreaCode=cp2.CompanyCode
left join TbCompany cp3 on cp2.ParentCompanyCode=cp3.CompanyCode
left join TbStorage c on c.StorageCode=rms.StorageCode
left join TbRawMaterialArchives b on b.MaterialCode=rms.MaterialCode
left join TbSysDictionaryData sdd2 on b.RebarType=sdd2.DictionaryCode
left join TbSysDictionaryData sdd3 on b.MeasurementUnit=sdd3.DictionaryCode
left join(select od.MaterialCode,od.MaterialName,od.SpecificationModel,isnull(sum(od.WeightSmallPlan),0) as WeightSmallPlan,wo.ProjectId,cp1.ParentCompanyCode as WorkAreaCode,cp2.ParentCompanyCode as BranchCode,wo.ProcessFactoryCode from TbWorkOrder wo
left join TbWorkOrderDetail od on wo.OrderCode=od.OrderCode
left join TbCompany cp1 on wo.SiteCode=cp1.CompanyCode
left join TbCompany cp2 on cp1.ParentCompanyCode=cp2.CompanyCode
where wo.Examinestatus='审核完成' and wo.ProcessingState='Received'
group by od.MaterialCode,od.MaterialName,od.SpecificationModel,wo.ProjectId,cp1.ParentCompanyCode,cp2.ParentCompanyCode,wo.ProcessFactoryCode) tbwork on rms.MaterialCode=tbwork.MaterialCode and b.MaterialName=tbwork.MaterialName and b.SpecificationModel=tbwork.SpecificationModel and rms.WorkAreaCode=tbwork.WorkAreaCode
and c.ProcessFactoryCode=tbwork.ProcessFactoryCode " ;
//参数化
List <Dos.ORM.Parameter> para = new List <Dos.ORM.Parameter>();
var data = Repositorys <RawMaterialStockResponse> .FromSqlToPage(sql + where, para, request.rows, request.page, "MaterialCode", "desc");
string sqljzgj = @"select
rms.SurplusNumber
from (
select
MaterialCode,
ProjectId,
SiteCode,
StorageCode,
WorkAreaCode,
SUM(COUNT) as COUNT,
SUM(LockCount) as LockCount,
SUM(UseCount) as UseCount,
case when SUM(LockCount)+SUM(UseCount)<0 then 0 else SUM(LockCount)+SUM(UseCount) end as SurplusNumber
FROM TbRawMaterialStockRecord
group by MaterialCode,SiteCode,WorkAreaCode,StorageCode,ProjectId
)as rms
left join TbCompany cp1 on rms.SiteCode=cp1.CompanyCode
left join TbCompany cp2 on rms.WorkAreaCode=cp2.CompanyCode
left join TbCompany cp3 on cp2.ParentCompanyCode=cp3.CompanyCode
left join TbStorage c on c.StorageCode=rms.StorageCode
left join TbRawMaterialArchives b on b.MaterialCode=rms.MaterialCode
left join TbSysDictionaryData sdd2 on b.RebarType=sdd2.DictionaryCode
left join TbSysDictionaryData sdd3 on b.MeasurementUnit=sdd3.DictionaryCode
left join(select od.MaterialCode,od.MaterialName,od.SpecificationModel,isnull(sum(od.WeightSmallPlan),0) as WeightSmallPlan,wo.ProjectId,cp1.ParentCompanyCode as WorkAreaCode,cp2.ParentCompanyCode as BranchCode,wo.ProcessFactoryCode from TbWorkOrder wo
left join TbWorkOrderDetail od on wo.OrderCode=od.OrderCode
left join TbCompany cp1 on wo.SiteCode=cp1.CompanyCode
left join TbCompany cp2 on cp1.ParentCompanyCode=cp2.CompanyCode
where wo.Examinestatus='审核完成' and wo.ProcessingState='Received'
group by od.MaterialCode,od.MaterialName,od.SpecificationModel,wo.ProjectId,cp1.ParentCompanyCode,cp2.ParentCompanyCode,wo.ProcessFactoryCode) tbwork on rms.MaterialCode=tbwork.MaterialCode and b.MaterialName=tbwork.MaterialName and b.SpecificationModel=tbwork.SpecificationModel and rms.WorkAreaCode=tbwork.WorkAreaCode
and c.ProcessFactoryCode=tbwork.ProcessFactoryCode " + where + @" and b.RebarType='BuildingSteel'";
decimal BuildingSteelSum = 0;
DataTable dtjzgj = Db.Context.FromSql(sqljzgj).ToDataTable();
if (dtjzgj.Rows.Count > 0)
{
BuildingSteelSum = Convert.ToDecimal(dtjzgj.Compute("sum(SurplusNumber)", ""));
}
string sqlxg = @"select
rms.SurplusNumber
from (
select
MaterialCode,
ProjectId,
SiteCode,
StorageCode,
WorkAreaCode,
SUM(COUNT) as COUNT,
SUM(LockCount) as LockCount,
SUM(UseCount) as UseCount,
case when SUM(LockCount)+SUM(UseCount)<0 then 0 else SUM(LockCount)+SUM(UseCount) end as SurplusNumber
FROM TbRawMaterialStockRecord
group by MaterialCode,SiteCode,WorkAreaCode,StorageCode,ProjectId
)as rms
left join TbCompany cp1 on rms.SiteCode=cp1.CompanyCode
left join TbCompany cp2 on rms.WorkAreaCode=cp2.CompanyCode
left join TbCompany cp3 on cp2.ParentCompanyCode=cp3.CompanyCode
left join TbStorage c on c.StorageCode=rms.StorageCode
left join TbRawMaterialArchives b on b.MaterialCode=rms.MaterialCode
left join TbSysDictionaryData sdd2 on b.RebarType=sdd2.DictionaryCode
left join TbSysDictionaryData sdd3 on b.MeasurementUnit=sdd3.DictionaryCode
left join(select od.MaterialCode,od.MaterialName,od.SpecificationModel,isnull(sum(od.WeightSmallPlan),0) as WeightSmallPlan,wo.ProjectId,cp1.ParentCompanyCode as WorkAreaCode,cp2.ParentCompanyCode as BranchCode,wo.ProcessFactoryCode from TbWorkOrder wo
left join TbWorkOrderDetail od on wo.OrderCode=od.OrderCode
left join TbCompany cp1 on wo.SiteCode=cp1.CompanyCode
left join TbCompany cp2 on cp1.ParentCompanyCode=cp2.CompanyCode
where wo.Examinestatus='审核完成' and wo.ProcessingState='Received'
group by od.MaterialCode,od.MaterialName,od.SpecificationModel,wo.ProjectId,cp1.ParentCompanyCode,cp2.ParentCompanyCode,wo.ProcessFactoryCode) tbwork on rms.MaterialCode=tbwork.MaterialCode and b.MaterialName=tbwork.MaterialName and b.SpecificationModel=tbwork.SpecificationModel and rms.WorkAreaCode=tbwork.WorkAreaCode
and c.ProcessFactoryCode=tbwork.ProcessFactoryCode " + where + @" and b.RebarType='SectionSteel'";
decimal SectionSteelSum = 0;
DataTable dtxg = Db.Context.FromSql(sqlxg).ToDataTable();
if (dtxg.Rows.Count > 0)
{
SectionSteelSum = Convert.ToDecimal(dtxg.Compute("sum(SurplusNumber)", ""));
}
data.userdata = new { BuildingSteel = BuildingSteelSum, SectionSteel = SectionSteelSum };
return(data);
}
catch (Exception)
{
throw;
}
}
