反射生成SQL语句

public static int Reg(Model ml)
        {
            bool b = true;
            Visit vt = new Visit();
            StringBuilder builder = new StringBuilder("insert into UsersTable (");
            Type type = ml.GetType();
            PropertyInfo[] per = type.GetProperties();
            List<SqlParameter> sqlpar = new List<SqlParameter>();
            for (int i = 0; i < per.Length; i++)
            {
                if (!per[i].Name.Equals("Uid") ||!string.IsNullOrEmpty(per[i].GetValue(ml, null).ToString()))
                {
                    if (i == per.Length - 1)
                    {
                        if (b == true)
                        {
                            builder.Append(per[i].Name + ")values(");
                            sqlpar.Add(new SqlParameter("@" + per[i].Name, per[i].GetValue(ml, null)));
                            i = 0;
                            b = false;
                        }
                        else
                        {
                            builder.Append("@" + per[i].Name + ")");
                        }
                    }
                    else
                    {
                        if (b == true)
                        {
                            builder.Append(per[i].Name + ",");
                            sqlpar.Add(new SqlParameter("@" + per[i].Name, per[i].GetValue(ml, null)));
                        }
                        else
                        {
                            builder.Append("@"+per[i].Name + ",");
                        }
                    }
                }
            }
            return vt.ExecuteNonQuery(builder.ToString(), sqlpar.ToArray());
        }

//查询
        public static DataSet Login(Model ml)
        {
            Visit vt = new Visit();
            Type type = ml.GetType();
            PropertyInfo[] per = type.GetProperties();
            List<SqlParameter> sqlpar = new List<SqlParameter>();
            StringBuilder builder = new StringBuilder("select Uid from UsersTable where ");
            for (int i = 0; i < per.Length; i++)
            {
                if (per[i].GetValue(ml, null)!=null&& !per[i].Name.Equals("Uid"))
                {
                    builder.Append(per[i].Name + "=@" + per[i].Name+" and ");
                    sqlpar.Add(new SqlParameter("@"+per[i].Name,per[i].GetValue(ml,null)));
                }
                
            }
            string sqlStr = builder.ToString().Substring(0, builder.ToString().LastIndexOf("and"));
            return vt.SqlDataAdapter(sqlStr, sqlpar.ToArray());
        }

public static bool upDate(Model ml)
        {
            Visit vt = new Visit();
            StringBuilder sbuilder = new StringBuilder("Update UsersTable set ");
            
            Type ModelType = ml.GetType();
            PropertyInfo[] ProPer = ModelType.GetProperties();
            List<SqlParameter> sqlpara = new List<SqlParameter>();
            
            foreach (PropertyInfo item in ProPer)
            {
                if (!string.IsNullOrEmpty(item.GetValue(ml,null).ToString())&& !item.Name.Equals("Uid"))
                {
                    sbuilder.Append(item.Name + "=@" + item.Name+",");
                    sqlpara.Add(new SqlParameter("@" + item.Name, item.GetValue(ml, null)));
                }
            }
            string str = sbuilder.ToString().Trim(',');
            str += " where Uid=@Uid";
            sqlpara.Add(new SqlParameter("@Uid", ml.Uid));
            return vt.ExecuteNonQuery(str, sqlpara.ToArray()) > 0;
            
        }