/// <summary>
/// 增加一条数据
/// </summary>
public void Add(_Model.ResponseDic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ResponseDic(");
strSql.Append("LineName,ProductPartNo,MaterialsPartNo");
strSql.Append(") values (");
strSql.Append("'" + model.LineName + "','" + model.ProductPartNo + "','" + model.MaterialsPartNo + "'");
strSql.Append(") ");
DbHelperSql.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 插入或者更新值 Request 字典表
/// </summary>
/// <param name="model"></param>
private static void InsertOrUpdateResponseDic(_Model.ResponseDic model)
{
var RequestDic = _bllResponseDic.GetResponseDic(string.Format("LineName='{0}' and ProductPartNo='{1}'", model.LineName, model.ProductPartNo));
if (RequestDic != null && RequestDic.Count > 0)
{
//存在此线的ResponseDic的ProductPartNo
//1.更新
_bllResponseDic.UpdateMaterialsToResponseDicByPartNo(model.ProductPartNo, model.LineName, model.MaterialsPartNo);
}
else
{
//字典表中不存在 插入新的
_bllResponseDic.Add(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(_Model.ResponseDic model)
{
dal.Add(model);
}