/// <summary>
/// 更新一条数据
/// </summary>
public string Update(UFIDA.U8.UAP.CustomApp.ControlForm.Model._OQC_RMDF model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update _OQC_RMDF set ");
if (model.OQCStatus != null)
{
strSql.Append("OQCStatus='" + model.OQCStatus + "',");
}
else
{
strSql.Append("OQCStatus= null ,");
}
if (model.iSOsID != null)
{
strSql.Append("iSOsID=" + model.iSOsID + ",");
}
else
{
strSql.Append("iSOsID= null ,");
}
if (model.LotNo != null)
{
strSql.Append("LotNo='" + model.LotNo + "',");
}
else
{
strSql.Append("LotNo= null ,");
}
if (model.cInvCode != null)
{
strSql.Append("cInvCode='" + model.cInvCode + "',");
}
else
{
strSql.Append("cInvCode= null ,");
}
if (model.cInvName != null)
{
strSql.Append("cInvName='" + model.cInvName + "',");
}
else
{
strSql.Append("cInvName= null ,");
}
if (model.sStatus != null)
{
strSql.Append("sStatus=" + model.sStatus + ",");
}
else
{
strSql.Append("sStatus= null ,");
}
if (model.Action != null)
{
strSql.Append("Action='" + model.Action + "',");
}
else
{
strSql.Append("Action= null ,");
}
if (model.LotQty != null)
{
strSql.Append("LotQty=" + model.LotQty + ",");
}
else
{
strSql.Append("LotQty= null ,");
}
if (model.InsQty != null)
{
strSql.Append("InsQty=" + model.InsQty + ",");
}
else
{
strSql.Append("InsQty= null ,");
}
if (model.SampleSize != null)
{
strSql.Append("SampleSize=" + model.SampleSize + ",");
}
else
{
strSql.Append("SampleSize= null ,");
}
if (model.cCusCode != null)
{
strSql.Append("cCusCode='" + model.cCusCode + "',");
}
else
{
strSql.Append("cCusCode= null ,");
}
if (model.AQLLevel != null)
{
strSql.Append("AQLLevel='" + model.AQLLevel + "',");
}
else
{
strSql.Append("AQLLevel= null ,");
}
if (model.Accept != null)
{
strSql.Append("Accept=" + model.Accept + ",");
}
else
{
strSql.Append("Accept= null ,");
}
if (model.Reject != null)
{
strSql.Append("Reject=" + model.Reject + ",");
}
else
{
strSql.Append("Reject= null ,");
}
if (model.Result != null)
{
strSql.Append("result='" + model.Result + "',");
}
else
{
strSql.Append("result= null ,");
}
if (model.dtmReceived != null)
{
strSql.Append("dtmReceived='" + model.dtmReceived + "',");
}
else
{
strSql.Append("dtmReceived= null ,");
}
if (model.dtmInspected != null)
{
strSql.Append("dtmInspected='" + model.dtmInspected + "',");
}
else
{
strSql.Append("dtmInspected= null ,");
}
if (model.InspectedBy != null)
{
strSql.Append("InspectedBy='" + model.InspectedBy + "',");
}
else
{
strSql.Append("InspectedBy= null ,");
}
if (model.CreateUid != null)
{
strSql.Append("CreateUid='" + model.CreateUid + "',");
}
else
{
strSql.Append("CreateUid= null ,");
}
if (model.dtmCreate != null)
{
strSql.Append("dtmCreate='" + model.dtmCreate + "',");
}
else
{
strSql.Append("dtmCreate= null ,");
}
if (model.UpdateUid != null)
{
strSql.Append("UpdateUid='" + model.UpdateUid + "',");
}
else
{
strSql.Append("UpdateUid= null ,");
}
if (model.dtmUpdate != null)
{
strSql.Append("dtmUpdate='" + model.dtmUpdate + "',");
}
else
{
strSql.Append("dtmUpdate= null ,");
}
if (model.AuditUid != null)
{
strSql.Append("AuditUid='" + model.AuditUid + "',");
}
else
{
strSql.Append("AuditUid= null ,");
}
if (model.dtmAudit != null)
{
strSql.Append("dtmAudit='" + model.dtmAudit + "',");
}
else
{
strSql.Append("dtmAudit= null ,");
}
if (model.SendMailCount != null)
{
strSql.Append("SendMailCount=" + model.SendMailCount + ",");
}
else
{
strSql.Append("SendMailCount= null ,");
}
if (model.SendMailUid != null)
{
strSql.Append("SendMailUid='" + model.SendMailUid + "',");
}
else
{
strSql.Append("SendMailUid= null ,");
}
if (model.dtmSendMail != null)
{
strSql.Append("dtmSendMail='" + model.dtmSendMail + "',");
}
else
{
strSql.Append("dtmSendMail= null ,");
}
if (model.Feedback != null)
{
strSql.Append("Feedback='" + model.Feedback + "',");
}
else
{
strSql.Append("Feedback= null ,");
}
if (model.SaveCount != null)
{
strSql.Append("SaveCount=" + model.SaveCount + ",");
}
else
{
strSql.Append("SaveCount= null ,");
}
if (model.Process != null)
{
strSql.Append("Process='" + model.Process + "',");
}
else
{
strSql.Append("Process= null ,");
}
if (model.ClosedUid != null)
{
strSql.Append("ClosedUid='" + model.ClosedUid + "',");
}
else
{
strSql.Append("ClosedUid= null ,");
}
if (model.dtmClose != null)
{
strSql.Append("dtmClose='" + model.dtmClose + "',");
}
else
{
strSql.Append("dtmClose= null ,");
}
if (model.Plater != null)
{
strSql.Append("Plater='" + model.Plater + "',");
}
if (model.Remark != null)
{
strSql.Append("Remark='" + model.Remark + "',");
}
else
{
strSql.Append("Remark= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where OQCNo='" + model.OQCNo + "'");
return(strSql.ToString());
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model._OQC_RMDF model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.OQCNo != null)
{
strSql1.Append("OQCNo,");
strSql2.Append("'" + model.OQCNo + "',");
}
if (model.OQCStatus != null)
{
strSql1.Append("OQCStatus,");
strSql2.Append("'" + model.OQCStatus + "',");
}
if (model.iSOsID != null)
{
strSql1.Append("iSOsID,");
strSql2.Append("" + model.iSOsID + ",");
}
if (model.LotNo != null)
{
strSql1.Append("LotNo,");
strSql2.Append("'" + model.LotNo + "',");
}
if (model.cInvCode != null)
{
strSql1.Append("cInvCode,");
strSql2.Append("'" + model.cInvCode + "',");
}
if (model.cInvName != null)
{
strSql1.Append("cInvName,");
strSql2.Append("'" + model.cInvName + "',");
}
if (model.sStatus != null)
{
strSql1.Append("sStatus,");
strSql2.Append("" + model.sStatus + ",");
}
if (model.Action != null)
{
strSql1.Append("Action,");
strSql2.Append("'" + model.Action + "',");
}
if (model.LotQty != null)
{
strSql1.Append("LotQty,");
strSql2.Append("" + model.LotQty + ",");
}
if (model.InsQty != null)
{
strSql1.Append("InsQty,");
strSql2.Append("" + model.InsQty + ",");
}
if (model.SampleSize != null)
{
strSql1.Append("SampleSize,");
strSql2.Append("" + model.SampleSize + ",");
}
if (model.cCusCode != null)
{
strSql1.Append("cCusCode,");
strSql2.Append("'" + model.cCusCode + "',");
}
if (model.AQLLevel != null)
{
strSql1.Append("AQLLevel,");
strSql2.Append("'" + model.AQLLevel + "',");
}
if (model.Accept != null)
{
strSql1.Append("Accept,");
strSql2.Append("" + model.Accept + ",");
}
if (model.Reject != null)
{
strSql1.Append("Reject,");
strSql2.Append("" + model.Reject + ",");
}
if (model.Result != null)
{
strSql1.Append("result,");
strSql2.Append("'" + model.Result + "',");
}
if (model.dtmReceived != null)
{
strSql1.Append("dtmReceived,");
strSql2.Append("'" + model.dtmReceived + "',");
}
if (model.dtmInspected != null)
{
strSql1.Append("dtmInspected,");
strSql2.Append("'" + model.dtmInspected + "',");
}
if (model.InspectedBy != null)
{
strSql1.Append("InspectedBy,");
strSql2.Append("'" + model.InspectedBy + "',");
}
if (model.CreateUid != null)
{
strSql1.Append("CreateUid,");
strSql2.Append("'" + model.CreateUid + "',");
}
if (model.dtmCreate != null)
{
strSql1.Append("dtmCreate,");
strSql2.Append("'" + model.dtmCreate + "',");
}
if (model.UpdateUid != null)
{
strSql1.Append("UpdateUid,");
strSql2.Append("'" + model.UpdateUid + "',");
}
if (model.dtmUpdate != null)
{
strSql1.Append("dtmUpdate,");
strSql2.Append("'" + model.dtmUpdate + "',");
}
if (model.AuditUid != null)
{
strSql1.Append("AuditUid,");
strSql2.Append("'" + model.AuditUid + "',");
}
if (model.dtmAudit != null)
{
strSql1.Append("dtmAudit,");
strSql2.Append("'" + model.dtmAudit + "',");
}
if (model.SendMailCount != null)
{
strSql1.Append("SendMailCount,");
strSql2.Append("" + model.SendMailCount + ",");
}
if (model.SendMailUid != null)
{
strSql1.Append("SendMailUid,");
strSql2.Append("'" + model.SendMailUid + "',");
}
if (model.dtmSendMail != null)
{
strSql1.Append("dtmSendMail,");
strSql2.Append("'" + model.dtmSendMail + "',");
}
if (model.Feedback != null)
{
strSql1.Append("Feedback,");
strSql2.Append("'" + model.Feedback + "',");
}
if (model.SaveCount != null)
{
strSql1.Append("SaveCount,");
strSql2.Append("" + model.SaveCount + ",");
}
if (model.Process != null)
{
strSql1.Append("Process,");
strSql2.Append("'" + model.Process + "',");
}
if (model.ClosedUid != null)
{
strSql1.Append("ClosedUid,");
strSql2.Append("'" + model.ClosedUid + "',");
}
if (model.dtmClose != null)
{
strSql1.Append("dtmClose,");
strSql2.Append("'" + model.dtmClose + "',");
}
if (model.Plater != null)
{
strSql1.Append("Plater,");
strSql2.Append("'" + model.Plater + "',");
}
if (model.Remark != null)
{
strSql1.Append("Remark,");
strSql2.Append("'" + model.Remark + "',");
}
strSql.Append("insert into _OQC_RMDF(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
return(strSql.ToString());
}
