/// <summary> /// 增加一条数据 /// </summary> public int Add(Matisoft.Model.Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Customer("); strSql.Append("Password,CustomerState,CustomerName,CustomerXiaoxue,CustomerChuzhong,CustomerGaozhong,CustomerDaxue,CustomerXueli,CustomerSex,CustomerBirthday,CustomerWorkplace,CustomerEmail,CustomerQQ)"); strSql.Append(" values ("); strSql.Append("@Password,@CustomerState,@CustomerName,@CustomerXiaoxue,@CustomerChuzhong,@CustomerGaozhong,@CustomerDaxue,@CustomerXueli,@CustomerSex,@CustomerBirthday,@CustomerWorkplace,@CustomerEmail,@CustomerQQ)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Password", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerState", SqlDbType.Int, 4), new SqlParameter("@CustomerName", SqlDbType.NVarChar, 20), new SqlParameter("@CustomerXiaoxue", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerChuzhong", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerGaozhong", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerDaxue", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerXueli", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerSex", SqlDbType.Int, 4), new SqlParameter("@CustomerBirthday", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerWorkplace", SqlDbType.NVarChar, 100), new SqlParameter("@CustomerEmail", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerQQ", SqlDbType.NVarChar, 15) }; parameters[0].Value = model.Password; parameters[1].Value = model.CustomerState; parameters[2].Value = model.CustomerName; parameters[3].Value = model.CustomerXiaoxue; parameters[4].Value = model.CustomerChuzhong; parameters[5].Value = model.CustomerGaozhong; parameters[6].Value = model.CustomerDaxue; parameters[7].Value = model.CustomerXueli; parameters[8].Value = model.CustomerSex; parameters[9].Value = model.CustomerBirthday; parameters[10].Value = model.CustomerWorkplace; parameters[11].Value = model.CustomerEmail; parameters[12].Value = model.CustomerQQ; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Matisoft.Model.Customer GetModel(int CustomerID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CustomerID,Password,CustomerState,CustomerName,CustomerXiaoxue,CustomerChuzhong,CustomerGaozhong,CustomerDaxue,CustomerXueli,CustomerSex,CustomerBirthday,CustomerWorkplace,CustomerEmail,CustomerQQ from Customer "); strSql.Append(" where CustomerID=@CustomerID"); SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.Int, 4) }; parameters[0].Value = CustomerID; Matisoft.Model.Customer model = new Matisoft.Model.Customer(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Matisoft.Model.Customer DataRowToModel(DataRow row) { Matisoft.Model.Customer model=new Matisoft.Model.Customer(); if (row != null) { if(row["CustomerID"]!=null && row["CustomerID"].ToString()!="") { model.CustomerID=int.Parse(row["CustomerID"].ToString()); } if(row["Password"]!=null) { model.Password=row["Password"].ToString(); } if(row["CustomerState"]!=null && row["CustomerState"].ToString()!="") { model.CustomerState=int.Parse(row["CustomerState"].ToString()); } if(row["CustomerName"]!=null) { model.CustomerName=row["CustomerName"].ToString(); } if(row["CustomerXiaoxue"]!=null) { model.CustomerXiaoxue=row["CustomerXiaoxue"].ToString(); } if(row["CustomerChuzhong"]!=null) { model.CustomerChuzhong=row["CustomerChuzhong"].ToString(); } if(row["CustomerGaozhong"]!=null) { model.CustomerGaozhong=row["CustomerGaozhong"].ToString(); } if(row["CustomerDaxue"]!=null) { model.CustomerDaxue=row["CustomerDaxue"].ToString(); } if(row["CustomerXueli"]!=null) { model.CustomerXueli=row["CustomerXueli"].ToString(); } if(row["CustomerSex"]!=null && row["CustomerSex"].ToString()!="") { model.CustomerSex=int.Parse(row["CustomerSex"].ToString()); } if(row["CustomerBirthday"]!=null) { model.CustomerBirthday=row["CustomerBirthday"].ToString(); } if(row["CustomerWorkplace"]!=null) { model.CustomerWorkplace=row["CustomerWorkplace"].ToString(); } if(row["CustomerEmail"]!=null) { model.CustomerEmail=row["CustomerEmail"].ToString(); } if(row["CustomerQQ"]!=null) { model.CustomerQQ=row["CustomerQQ"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Matisoft.Model.Customer GetModel(int CustomerID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 CustomerID,Password,CustomerState,CustomerName,CustomerXiaoxue,CustomerChuzhong,CustomerGaozhong,CustomerDaxue,CustomerXueli,CustomerSex,CustomerBirthday,CustomerWorkplace,CustomerEmail,CustomerQQ from Customer "); strSql.Append(" where CustomerID=@CustomerID"); SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.Int,4) }; parameters[0].Value = CustomerID; Matisoft.Model.Customer model=new Matisoft.Model.Customer(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Matisoft.Model.Customer DataRowToModel(DataRow row) { Matisoft.Model.Customer model = new Matisoft.Model.Customer(); if (row != null) { if (row["CustomerID"] != null && row["CustomerID"].ToString() != "") { model.CustomerID = int.Parse(row["CustomerID"].ToString()); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["CustomerState"] != null && row["CustomerState"].ToString() != "") { model.CustomerState = int.Parse(row["CustomerState"].ToString()); } if (row["CustomerName"] != null) { model.CustomerName = row["CustomerName"].ToString(); } if (row["CustomerXiaoxue"] != null) { model.CustomerXiaoxue = row["CustomerXiaoxue"].ToString(); } if (row["CustomerChuzhong"] != null) { model.CustomerChuzhong = row["CustomerChuzhong"].ToString(); } if (row["CustomerGaozhong"] != null) { model.CustomerGaozhong = row["CustomerGaozhong"].ToString(); } if (row["CustomerDaxue"] != null) { model.CustomerDaxue = row["CustomerDaxue"].ToString(); } if (row["CustomerXueli"] != null) { model.CustomerXueli = row["CustomerXueli"].ToString(); } if (row["CustomerSex"] != null && row["CustomerSex"].ToString() != "") { model.CustomerSex = int.Parse(row["CustomerSex"].ToString()); } if (row["CustomerBirthday"] != null) { model.CustomerBirthday = row["CustomerBirthday"].ToString(); } if (row["CustomerWorkplace"] != null) { model.CustomerWorkplace = row["CustomerWorkplace"].ToString(); } if (row["CustomerEmail"] != null) { model.CustomerEmail = row["CustomerEmail"].ToString(); } if (row["CustomerQQ"] != null) { model.CustomerQQ = row["CustomerQQ"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Matisoft.Model.Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Customer set "); strSql.Append("Password=@Password,"); strSql.Append("CustomerState=@CustomerState,"); strSql.Append("CustomerName=@CustomerName,"); strSql.Append("CustomerXiaoxue=@CustomerXiaoxue,"); strSql.Append("CustomerChuzhong=@CustomerChuzhong,"); strSql.Append("CustomerGaozhong=@CustomerGaozhong,"); strSql.Append("CustomerDaxue=@CustomerDaxue,"); strSql.Append("CustomerXueli=@CustomerXueli,"); strSql.Append("CustomerSex=@CustomerSex,"); strSql.Append("CustomerBirthday=@CustomerBirthday,"); strSql.Append("CustomerWorkplace=@CustomerWorkplace,"); strSql.Append("CustomerEmail=@CustomerEmail,"); strSql.Append("CustomerQQ=@CustomerQQ"); strSql.Append(" where CustomerID=@CustomerID"); SqlParameter[] parameters = { new SqlParameter("@Password", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerState", SqlDbType.Int, 4), new SqlParameter("@CustomerName", SqlDbType.NVarChar, 20), new SqlParameter("@CustomerXiaoxue", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerChuzhong", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerGaozhong", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerDaxue", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerXueli", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerSex", SqlDbType.Int, 4), new SqlParameter("@CustomerBirthday", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerWorkplace", SqlDbType.NVarChar, 100), new SqlParameter("@CustomerEmail", SqlDbType.NVarChar, 50), new SqlParameter("@CustomerQQ", SqlDbType.NVarChar, 15), new SqlParameter("@CustomerID", SqlDbType.Int, 4) }; parameters[0].Value = model.Password; parameters[1].Value = model.CustomerState; parameters[2].Value = model.CustomerName; parameters[3].Value = model.CustomerXiaoxue; parameters[4].Value = model.CustomerChuzhong; parameters[5].Value = model.CustomerGaozhong; parameters[6].Value = model.CustomerDaxue; parameters[7].Value = model.CustomerXueli; parameters[8].Value = model.CustomerSex; parameters[9].Value = model.CustomerBirthday; parameters[10].Value = model.CustomerWorkplace; parameters[11].Value = model.CustomerEmail; parameters[12].Value = model.CustomerQQ; parameters[13].Value = model.CustomerID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }