public ProviderClassModel GetModel(int ClassId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from pm_provider_class ");
builder.Append(" where ClassId=" + ClassId);
ProviderClassModel model = new ProviderClassModel();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
model.ClassId = ClassId;
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
model.ClassName = set.Tables[0].Rows[0]["ClassName"].ToString();
if (set.Tables[0].Rows[0]["ParentId"].ToString() != "")
{
model.ParentId = int.Parse(set.Tables[0].Rows[0]["ParentId"].ToString());
}
model.ClassCode = set.Tables[0].Rows[0]["ClassCode"].ToString();
if (set.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = int.Parse(set.Tables[0].Rows[0]["State"].ToString());
}
model.WDUUser = set.Tables[0].Rows[0]["WDUUser"].ToString();
model.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
model.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
model.Comment = set.Tables[0].Rows[0]["Comment"].ToString();
return(model);
}
public int UpDateDuty(ProviderClassModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update pm_provider_class set ");
builder.Append("WDUUser='******'");
builder.Append(" where ClassId=" + model.ClassId);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int UpdateClass(ProviderClassModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update pm_provider_class set ");
builder.Append("ClassName=" + model.ClassName + ",");
builder.Append("ClassCode='" + model.ClassCode + "',");
builder.Append("Comment=" + model.Comment);
builder.Append(" where ClassId=" + model.ClassId);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Update(ProviderClassModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update pm_provider_class set ");
builder.Append("ClassName='" + model.ClassName + "',");
builder.Append("ParentId=" + model.ParentId + ",");
builder.Append("ClassCode='" + model.ClassCode + "',");
builder.Append("State=" + model.State + ",");
builder.Append("WDUUser='******',");
builder.Append("UserCode='" + model.UserCode + "',");
builder.Append("RecordDate='" + model.RecordDate + "',");
builder.Append("Comment='" + model.Comment + "'");
builder.Append(" where ClassId=" + model.ClassId);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(ProviderClassModel model)
{
int num = int.Parse(publicDbOpClass.QuaryMaxid("pm_provider_class", "ClassId")) + 1;
StringBuilder builder = new StringBuilder();
builder.Append("insert into pm_provider_class(");
builder.Append("ClassId,ClassName,ParentId,ClassCode,State,WDUUser,UserCode,RecordDate,Comment");
builder.Append(")");
builder.Append(" values (");
builder.Append(num.ToString() + ",");
builder.Append(model.ClassName + ",");
builder.Append(model.ParentId + ",");
builder.Append("'" + model.ClassCode + "',");
builder.Append(model.State + ",");
builder.Append("'" + model.WDUUser + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append(model.Comment ?? "");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
