/// <summary> /// 得到一个对象实体 /// </summary> public ClassLibrary.Model.Customers GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, Name, QQ, QQorder, CreatedTime, InUse, QQtype, Phone "); strSql.Append(" from Customers "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; ClassLibrary.Model.Customers model = new ClassLibrary.Model.Customers(); DataTable ds = SQLHelper.Query(strSql.ToString(), parameters); if (ds.Rows.Count > 0) { if (ds.Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Rows[0]["ID"].ToString()); } model.Name = ds.Rows[0]["Name"].ToString(); model.QQ = ds.Rows[0]["QQ"].ToString(); if (ds.Rows[0]["QQorder"].ToString() != "") { model.QQorder = int.Parse(ds.Rows[0]["QQorder"].ToString()); } if (ds.Rows[0]["CreatedTime"].ToString() != "") { model.CreatedTime = DateTime.Parse(ds.Rows[0]["CreatedTime"].ToString()); } if (ds.Rows[0]["InUse"].ToString() != "") { if ((ds.Rows[0]["InUse"].ToString() == "1") || (ds.Rows[0]["InUse"].ToString().ToLower() == "true")) { model.InUse = true; } else { model.InUse = false; } } if (ds.Rows[0]["QQtype"].ToString() != "") { model.QQtype = Convert.ToInt32(ds.Rows[0]["QQtype"].ToString()); } model.Phone = ds.Rows[0]["Phone"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ClassLibrary.Model.Customers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Customers set "); strSql.Append(" Name = @Name , "); strSql.Append(" QQ = @QQ , "); strSql.Append(" QQorder = @QQorder , "); strSql.Append(" CreatedTime = @CreatedTime , "); strSql.Append(" InUse = @InUse , "); strSql.Append(" QQtype = @QQtype , "); strSql.Append(" Phone = @Phone "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 20), new SqlParameter("@QQ", SqlDbType.NVarChar, 20), new SqlParameter("@QQorder", SqlDbType.Int, 4), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@InUse", SqlDbType.Bit, 1), new SqlParameter("@QQtype", SqlDbType.Int, 4), new SqlParameter("@Phone", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.ID; parameters[1].Value = model.Name; parameters[2].Value = model.QQ; parameters[3].Value = model.QQorder; parameters[4].Value = model.CreatedTime; parameters[5].Value = model.InUse; parameters[6].Value = model.QQtype; parameters[7].Value = model.Phone; int rows = SQLHelper.Execute(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ClassLibrary.Model.Customers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Customers("); strSql.Append("Name,QQ,QQorder,CreatedTime,InUse,QQtype,Phone"); strSql.Append(") values ("); strSql.Append("@Name,@QQ,@QQorder,@CreatedTime,@InUse,@QQtype,@Phone"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 20), new SqlParameter("@QQ", SqlDbType.NVarChar, 20), new SqlParameter("@QQorder", SqlDbType.Int, 4), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@InUse", SqlDbType.Bit, 1), new SqlParameter("@QQtype", SqlDbType.Int, 4), new SqlParameter("@Phone", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.Name; parameters[1].Value = model.QQ; parameters[2].Value = model.QQorder; parameters[3].Value = model.CreatedTime; parameters[4].Value = model.InUse; parameters[5].Value = model.QQtype; parameters[6].Value = model.Phone; object obj = SQLHelper.Execute(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void AddCustomer() { ClassLibrary.Model.Customers cModel = new ClassLibrary.Model.Customers(); cModel.Name = Request.Form["CName"]; cModel.QQ = Request.Form["QQNumber"]; cModel.Phone = Request.Form["Phone"]; if (Request.Form["QQorder"] != "") { cModel.QQorder = Convert.ToInt32(Request.Form["QQorder"]); } cModel.InUse = Convert.ToBoolean(Request.Form["InUse"]); cModel.QQtype = Convert.ToInt32(Request.Form["QQtype"]); if (cBll.Add(cModel) > 0) { Function.goMessagePage("添加客服", "操作成功", "Customer/CustomerList.aspx"); } else { Function.goMessagePage("添加客服", "操作失败,请稍后再试", "Customer/CustomerList.aspx"); } }
private void BindCustomer() { cmodel = cBll.GetModel(cid); qqtype = cmodel.QQtype; }