/// <summary>
/// 增加一条数据
/// </summary>
public void Add(_Model.SolderPasteDifferRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SolderPasteDifferRecord(");
strSql.Append("LastMaterialsNo,NextMaterialsNo,LastTypeNo,NextTypeNo,LastFileTime,NextFileTime,Status,AduitStatus,LineName,DifferSign,CreateTime");
strSql.Append(") values (");
strSql.Append("'" + model.LastMaterialsNo + "','" + model.NextMaterialsNo + "','" + model.LastTypeNo + "','" + model.NextTypeNo + "','" + model.LastFileTime + "','" + model.NextFileTime + "','" + model.Status + "','" + model.AduitStatus + "','" + model.LineName + "','" + model.DifferSign + "','" + model.CreateTime + "'");
strSql.Append(") ");
DbHelperSql.ExecuteSql(strSql.ToString());
}
public static void InsertToCompareTable(string lastFileTime, string nextFileTime, string lastTypeNo, string nextTypeNo, string lastMaterialsNo, string nextMaterialsNo, string status, string lineName)
{
_Model.SolderPasteDifferRecord model = new _Model.SolderPasteDifferRecord
{
LastTypeNo = lastTypeNo,
NextTypeNo = nextTypeNo,
LastMaterialsNo = lastMaterialsNo,
NextMaterialsNo = nextMaterialsNo,
LastFileTime = lastFileTime,
NextFileTime = nextFileTime,
Status = status,
LineName = lineName,
DifferSign = "plcChangeOverStarted",
AduitStatus = Convert.ToBase64String(UTF8Encoding.Unicode.GetBytes("待确认")),
CreateTime = Convert.ToDateTime(Convert.ToDateTime(nextFileTime).ToString("yyyy-MM-dd HH:mm:ss"))
};
_bllSolderPasteDifferRecord.Add(model);//添加对比结果进对比表中
}
