public PrvdAccessoryModel GetModel(int AccessoryId) { StringBuilder builder = new StringBuilder(); builder.Append("select * from pm_prvd_accessory "); builder.Append(" where AccessoryId=" + AccessoryId); PrvdAccessoryModel model = new PrvdAccessoryModel(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); model.AccessoryId = AccessoryId; if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["ProviderId"].ToString() != "") { model.ProviderId = int.Parse(set.Tables[0].Rows[0]["ProviderId"].ToString()); } model.AccessoryName = set.Tables[0].Rows[0]["AccessoryName"].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 Update(PrvdAccessoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update pm_prvd_accessory set "); builder.Append("ProviderId=" + model.ProviderId + ","); builder.Append("AccessoryName='" + model.AccessoryName + "',"); builder.Append("Comment='" + model.Comment + "'"); builder.Append(" where AccessoryId=" + model.AccessoryId); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(PrvdAccessoryModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into pm_prvd_accessory("); builder.Append("AccessoryId,ProviderId,AccessoryName,UserCode,OriginalName,FilePath,RecordDate,Comment"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.AccessoryId + ","); builder.Append(model.ProviderId + ","); builder.Append("'" + model.AccessoryName + "',"); builder.Append("'" + model.UserCode + "',"); builder.Append("'" + model.OriginalName + "',"); builder.Append("'" + model.FilePath + "',"); builder.Append("'" + model.RecordDate + "',"); builder.Append("'" + model.Comment + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }