public bool Update(Business_DataItemModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" update OPM_Business_DataItem set ");
builder.Append(" CodeID='" + model.CodeId + "',");
builder.Append(" PCode='" + model.PCode + "',");
builder.Append(" PName='" + model.PName + "',");
DateTime designDate = model.DesignDate;
builder.Append(" DesignDate='" + model.DesignDate + "',");
builder.Append(" Remark='" + model.Remark + "'");
builder.Append(" where UID='" + model.UID + "'");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
public bool Add(Business_DataItemModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" insert into OPM_Business_DataItem(UID,CodeID ,PCode ,PName ,FlowState ,DesignDate ,Remark ,AddUser ,AddTime,IsValid)");
builder.Append(" values( ");
builder.Append(" '" + model.UID + "', ");
builder.Append(" '" + model.CodeId + "', ");
builder.Append(" '" + model.PCode + "', ");
builder.Append(" '" + model.PName + "', ");
builder.Append(" " + model.FlowState + ", ");
DateTime designDate = model.DesignDate;
builder.Append(" '" + model.DesignDate + "', ");
builder.Append(" '" + model.Remark + "', ");
builder.Append(" '" + model.AddUser + "', ");
builder.Append(" '" + model.AddTime + "', ");
builder.Append(" '" + model.IsValid + "')");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
