public int UpdateDoc(PrjStageInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("Update OPM_Prj_StageInfo SET");
builder.Append(" InfoCode=");
builder.Append("'" + model.InfoCode + "',");
builder.Append("InfoName=");
builder.Append("'" + model.InfoName + "',");
builder.Append("InfoContent=");
builder.Append("'" + model.InfoContent + "',");
builder.Append("FlowState=");
builder.Append("-1,");
builder.Append("IsValid=");
builder.Append("'" + model.IsValid + "',");
builder.Append("IsFile=");
builder.Append("'" + model.IsFile + "',");
builder.Append("FileType=");
builder.Append(model.FileType + ",");
builder.Append("CorpID=");
builder.Append(model.CorpID + ",");
builder.Append("CodeID=");
builder.Append(model.CodeID + ",");
builder.Append("AddUser="******"'" + model.AddUser + "',");
builder.Append("AddTime=");
builder.Append("'" + model.AddTime + "',");
builder.Append("Remark=");
builder.Append("'" + model.Remark + "'");
builder.Append(" where ");
builder.Append("InfoID=");
builder.Append("'" + model.InfoID + "'");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public bool Add(PrjStageInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OPM_Prj_StageInfo(InfoID, PrjStageID,InfoCode,InfoName,InfoContent,FlowState,IsValid,IsFile,FileType,AddUser,AddTime,PrjID,Remark)");
builder.Append(" values(");
builder.Append("'" + model.InfoID + "',");
builder.Append("'" + model.PrjStageID + "',");
builder.Append("'" + model.InfoCode + "',");
builder.Append("'" + model.InfoName + "',");
builder.Append("'" + model.InfoContent + "',");
builder.Append(model.FlowState + ",");
builder.Append("'" + model.IsValid + "',");
builder.Append("'" + model.IsFile + "',");
builder.Append(model.FileType + ",");
builder.Append("'" + model.AddUser + "',");
builder.Append("'" + model.AddTime + "',");
builder.Append("'" + model.PrjID + "',");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return(publicDbOpClass.NonQuerySqlString(builder.ToString()));
}
