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())); }