public bool Update(BuildBriefModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update opm_epcm_brief set ");
builder.Append("sn='" + model.SN + "',");
builder.Append("type='" + model.Type + "',");
builder.Append("record='" + model.Record + "',");
builder.Append("buildsituation='" + model.BuildSituation + "',");
builder.Append("manasituation='" + model.ManaSituation + "',");
builder.Append("problem='" + model.Problem + "',");
builder.Append("adduser='******',");
builder.Append("addtime='" + model.AddTime + "',");
builder.Append("remark='" + model.Remark + "',");
builder.Append("prjid='" + model.PrjId + "',");
builder.Append("brieftype='" + model.BriefType + "',");
builder.Append("flowstate=" + model.FlowState + " ");
builder.Append("where briefid='" + model.BriefId + "'");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
public bool Add(BuildBriefModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into opm_epcm_brief(briefid,sn,type,record,buildsituation, ");
builder.Append("manasituation,problem,adduser,addtime,remark,prjid,flowstate,briefType) ");
builder.Append("values(");
builder.Append("'" + model.BriefId + "',");
builder.Append("'" + model.SN + "',");
builder.Append("'" + model.Type + "',");
builder.Append("'" + model.Record + "',");
builder.Append("'" + model.BuildSituation + "',");
builder.Append("'" + model.ManaSituation + "',");
builder.Append("'" + model.Problem + "',");
builder.Append("'" + model.AddUser + "',");
builder.Append("'" + model.AddTime + "',");
builder.Append("'" + model.Remark + "',");
builder.Append("'" + model.PrjId + "',");
builder.Append(model.FlowState + ",");
builder.Append("'" + model.BriefType + "')");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
