/// <summary>
/// 插入信息(单表)
/// </summary>
/// <param name="">信息</param>
/// <returns>插入行数</returns>
public DataResult <int> Insert(QualityCheckInfo model)
{
DataResult <int> result = new DataResult <int>();
try
{
//基本信息
model.ID = Guid.NewGuid().ToString();
model.CREATEUSER = this.LoginUser.UserID;
model.CREATETIME = DateTime.Now;
model.UPDATEUSER = model.CREATEUSER;
model.UPDATETIME = model.CREATETIME;
if (ExistsBillNO(model))
{
result.Msg = "质检单号已存在";
result.Result = -1;
return(result);
}
result.Result = new QualityCheckDAL().Insert(model);
result.IsSuccess = true;
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name=""></param>
/// <returns>更新行数</returns>
public int Update(QualityCheckInfo model)
{
int count = 0;
string sql = "delete from T_FP_QUALITYCHECKRESULT where CheckID = @CheckID";
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
session.OpenTs();
count = session.Update <QualityCheckInfo>(model);
session.ExecuteSql(sql, new DataParameter("CheckID", model.ID));
foreach (QualityCheckResult detail in model.QualityCheckResults)
{
detail.ID = Guid.NewGuid().ToString();
detail.CheckID = model.ID;
session.Insert <QualityCheckResult>(detail);
}
session.CommitTs();
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入信息(单表)
/// </summary>
/// <param name="">信息</param>
/// <returns>插入行数</returns>
public int Insert(QualityCheckInfo model)
{
int count = 0;
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
session.OpenTs();
//插入基本信息
count = session.Insert <QualityCheckInfo>(model);
foreach (QualityCheckResult detail in model.QualityCheckResults)
{
detail.ID = Guid.NewGuid().ToString();
detail.CheckID = model.ID;
session.Insert <QualityCheckResult>(detail);
}
session.CommitTs();
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断单号是否存在
/// </summary>
/// <param name="info"></param>
/// <returns>true:已存在；fasel:不存在。</returns>
public bool ExistsBillNO(QualityCheckInfo model)
{
try
{
return(new QualityCheckDAL().ExistsBillNO(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>信息</returns>
public QualityCheckInfo Get(QualityCheckInfo model)
{
try
{
return(new QualityCheckDAL().Get(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除信息
/// </summary>
/// <param name="">主键串</param>
/// <returns>删除个数</returns>
public int Delete(QualityCheckInfo model)
{
try
{
return(new QualityCheckDAL().Delete(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="">条件</param>
/// <returns>*信息</returns>
public QualityCheckInfo Get(QualityCheckInfo model)
{
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取信息
model = session.Get <QualityCheckInfo>(model);
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除信息
/// </summary>
/// <param name=""></param>
/// <returns>删除个数</returns>
public int Delete(QualityCheckInfo model)
{
int count = 0;
try
{
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//删除BOM信息
count = session.Delete <QualityCheckInfo>(model);
//删除BOM明细信息
string sql = "DELETE FROM T_FP_QUALITYCHECKRESULT WHERE CheckID = @CheckID";
session.ExecuteSql(sql, new DataParameter("CheckID", model.ID));
}
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="">信息</param>
/// <returns>更新行数</returns>
public DataResult <int> Update(QualityCheckInfo model)
{
DataResult <int> result = new DataResult <int>();
try
{
if (ExistsBillNO(model))
{
result.Msg = "质检单号已存在";
result.Result = -1;
return(result);
}
model.UPDATEUSER = this.LoginUser.UserID;
result.Result = new QualityCheckDAL().Update(model);
result.IsSuccess = true;
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btSave_Click(object sender, EventArgs e)
{
QualityCheckInfo info = new QualityCheckInfo();
QualityCheckBLL bll = null;
try
{
UIBindHelper.BindModelByControls(this.Page, info);
info.QualityCheckResults = LAF.Common.Serialization.JsonConvertHelper.DeserializeObject <List <QualityCheckResult> >(this.hiPList.Value);
bll = BLLFactory.CreateBLL <QualityCheckBLL>();
if (RB1.Checked)
{
info.CheckResult = "0";
}
else
{
info.CheckResult = "1";
}
if (this.hiID.Value == "")
{
bll.Insert(info);
}
else
{
info.CREATEUSER = this.HiCREATEUSER.Value;
info.CREATETIME = DateTime.Parse(this.HiCREATETIME.Value);
info.ID = this.hiID.Value;
bll.Update(info);
}
ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断单号是否存在
/// </summary>
/// <param name="info"></param>
/// <returns>true:已存在；fasel:不存在。</returns>
public bool ExistsBillNO(QualityCheckInfo model)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder whereBuilder = new StringBuilder();
List <DataParameter> parameters = new List <DataParameter>();
int count = 0;
try
{
sqlBuilder.Append("SELECT COUNT(0) FROM T_FP_QUALITYCHECK");
whereBuilder.Append(" AND ID <> @ID ");
parameters.Add(new DataParameter {
ParameterName = "ID", DataType = DbType.String, Value = model.ID
});
if (!string.IsNullOrEmpty(model.BillNO))
{
whereBuilder.Append(" AND BillNO = @BillNO ");
parameters.Add(new DataParameter {
ParameterName = "BillNO", DataType = DbType.String, Value = model.BillNO
});
}
if (whereBuilder.Length > 0)
{
sqlBuilder.Append(" WHERE " + whereBuilder.ToString().Substring(4));
}
using (IDataSession session = AppDataFactory.CreateMainSession())
{
count = Convert.ToInt32(session.ExecuteSqlScalar(sqlBuilder.ToString(), parameters.ToArray()));
}
return(count > 0);
}
catch (Exception ex)
{
throw ex;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentEncoding = Encoding.UTF8;
context.Response.ContentType = "application/json";
string type = context.Request.QueryString["Type"];
string code = context.Request.QueryString["Code"];
string batchNumber = "";
switch (type)
{
case "CP":
ProducePlanBLL bll = BLLFactory.CreateBLL <ProducePlanBLL>();
ProductInfo result = bll.GetPNameByIDBatchNumber(code);
if (result == null)
{
result = new ProductInfo();
if (result != null)
{
result.PID = "none";
}
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(result));
break;
case "CP2":
ProducePlanBLL bllGoodInfo = BLLFactory.CreateBLL <ProducePlanBLL>();
GoodInfo resultGoodInfo = bllGoodInfo.GetGoodInfoByBatchNumber(code);
if (resultGoodInfo == null)
{
resultGoodInfo = new GoodInfo();
if (resultGoodInfo != null)
{
resultGoodInfo.PID = "none";
}
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(resultGoodInfo));
break;
case "CB":
EquipmentBLL bll2 = BLLFactory.CreateBLL <EquipmentBLL>();
EquipmentInfo result2 = bll2.GetInfoByBarCode(code);
if (result2 == null)
{
result2 = new EquipmentInfo();
if (result2 != null)
{
result2.PID = "none";
}
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(result2));
break;
case "GX": //根据工位条码获取加工工序
ProcessInfoBLL bll3 = BLLFactory.CreateBLL <ProcessInfoBLL>();
Manage.Entity.MES.ProcessInfo result3 = bll3.GetInfoByWS(code);
if (result3 == null)
{
result3 = new Manage.Entity.MES.ProcessInfo();
if (result3 != null)
{
result3.PID = "none";
}
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(result3));
break;
case "GX2":
ProcessInfoBLL bll4 = BLLFactory.CreateBLL <ProcessInfoBLL>();
batchNumber = context.Request.QueryString["BatchNumber"];
Manage.Entity.MES.ProcessInfo result4 = bll4.GetInfoByBarCodeAndBatchNumber(code, batchNumber);
if (result4 == null)
{
result4 = new Manage.Entity.MES.ProcessInfo();
if (result4 != null)
{
result4.PID = "none";
}
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(result4));
break;
case "PP":
ProducePlanBLL ppbll = BLLFactory.CreateBLL <ProducePlanBLL>();
SupplyInfoBLL sibll = BLLFactory.CreateBLL <SupplyInfoBLL>();
string id = context.Request.QueryString["id"];
SupplyInfo siresult = ppbll.GetProducePlanInfoByID(id);
if (siresult == null)
{
siresult = new SupplyInfo();
if (siresult != null)
{
siresult.PID = "none";
}
}
else
{
siresult.Details = sibll.GetMaterialListByBOM(siresult.ProductionID);
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(siresult));
break;
case "ZJ":
QualityCheckBLL qcBll = BLLFactory.CreateBLL <QualityCheckBLL>();
batchNumber = context.Request.QueryString["BatchNumber"];
QualityCheckInfo qualityCheckInfo = qcBll.GetPDInfo(batchNumber);
if (qualityCheckInfo == null)
{
qualityCheckInfo = new QualityCheckInfo();
qualityCheckInfo.ID = "none";
}
context.Response.Write(LAF.Common.Serialization.JsonConvertHelper.GetSerializes(qualityCheckInfo));
break;
default:
break;
}
}
private void BindData()
{
string id = Request.QueryString["id"];
QualityCheckBLL bll = null;
QualityCheckInfo info = new QualityCheckInfo();
DataGridResult <QualityCheckResult> pList = new DataGridResult <QualityCheckResult>();
try
{
bll = BLLFactory.CreateBLL <QualityCheckBLL>();
int seq = 0;
if (string.IsNullOrEmpty(id) == false)
{
info.ID = id;
info = bll.Get(info);
if (!string.IsNullOrEmpty(info.BatchNumber))
{
QualityCheckBLL qcBll = BLLFactory.CreateBLL <QualityCheckBLL>();
QualityCheckInfo qualityCheckInfo = qcBll.GetPDInfo(info.BatchNumber);
if (qualityCheckInfo != null)
{
info.PDDATE = qualityCheckInfo.PDDATE;
info.PDCODE = qualityCheckInfo.PDCODE;
info.PDNAME = qualityCheckInfo.PDNAME;
}
}
UIBindHelper.BindForm(this.Page, info);
if (info.CheckResult == "0")
{
RB1.Checked = true;
}
else
{
RB2.Checked = true;
}
this.BatchNumber.Enabled = false;
this.hiID.Value = info.ID;
this.HiCREATEUSER.Value = info.CREATEUSER;
this.HiCREATETIME.Value = info.CREATETIME.ToString();
List <QualityCheckResult> list = bll.GetResultList(id);
foreach (QualityCheckResult detail in list)
{
detail.DeleteAction = "deleteF(\'" + detail.FileName + "\')";
detail.DetailAction = "viewF(\'" + detail.FileName + "\')";
detail.SEQ = seq++;
}
pList.Total = list.Count;
pList.Rows = list;
}
else
{
info = new QualityCheckInfo();
info.CheckPerson = GetLoginInfo().UserName;
pList.Total = 0;
pList.Rows = new List <QualityCheckResult>();
UIBindHelper.BindForm(this.Page, info);
}
this.hiPList.Value = pList.GetJsonSource();
}
catch (Exception ex)
{
throw ex;
}
}
