public static bool Insert(ProductAssign model) { string sqlStr = ""; List <string> fileds = new List <string>(); List <string> pFileds = new List <string>(); List <SqlParameter> pms = new List <SqlParameter>(); #region 添加字段 if (model.StudentID != null) { fileds.Add("[StudentID]"); pFileds.Add("@StudentID"); pms.Add(new SqlParameter("StudentID", model.StudentID)); } if (model.StudentPassportID != null) { fileds.Add("[StudentPassportID]"); pFileds.Add("@StudentPassportID"); pms.Add(new SqlParameter("StudentPassportID", model.StudentPassportID)); } if (model.ProductID != null) { fileds.Add("[ProductID]"); pFileds.Add("@ProductID"); pms.Add(new SqlParameter("ProductID", model.ProductID)); } if (model.AssignCount != null) { fileds.Add("[AssignCount]"); pFileds.Add("@AssignCount"); pms.Add(new SqlParameter("AssignCount", model.AssignCount)); } if (model.HostID != null) { fileds.Add("[HostID]"); pFileds.Add("@HostID"); pms.Add(new SqlParameter("HostID", model.HostID)); } #endregion StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO ProductAssign ("); sb.Append(string.Join(",", fileds.ToArray())); sb.Append(") values ("); sb.Append(string.Join(",", pFileds.ToArray())); sb.Append(")"); sqlStr = sb.ToString(); using (DbCommand cmd = db.GetSqlStringCommand(sqlStr)) { cmd.Parameters.AddRange(pms.ToArray()); int i = db.ExecuteNonQuery(cmd); return(i > 0); } }
public static List <ProductAssign> Search(string sqlStr, params SqlParameter[] parameters) { List <ProductAssign> list = new List <ProductAssign>(); using (DbCommand cmd = db.GetSqlStringCommand(sqlStr)) { cmd.Parameters.AddRange(parameters); DataSet ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0) { DataTable table = ds.Tables[0]; foreach (DataRow dr in table.Rows) { ProductAssign model = new ProductAssign(dr); list.Add(model); } } } return(list); }
public static bool Save(ProductAssign model) { string sqlStr = "select count(1) from ProductAssign where 1=1 "; List <SqlParameter> pms = new List <SqlParameter>(); sqlStr += " and ProductAssignID=@ProductAssignID "; pms.Add(new SqlParameter("ProductAssignID", model.ProductAssignID)); using (DbCommand cmd = db.GetSqlStringCommand(sqlStr)) { cmd.Parameters.AddRange(pms.ToArray()); int i = (int)db.ExecuteScalar(cmd); if (i > 0) { return(Update(model)); } else { return(Insert(model)); } } }