/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.CRM_Follow model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CRM_Follow set "); strSql.Append("Follow=@Follow,"); strSql.Append("Follow_Type_id=@Follow_Type_id,"); strSql.Append("Follow_Type=@Follow_Type"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@Follow", MySqlDbType.VarChar, -1), new MySqlParameter("@Follow_Type_id", MySqlDbType.Int32, 4), new MySqlParameter("@Follow_Type", MySqlDbType.VarChar, 250), new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters[0].Value = model.Follow; parameters[1].Value = model.Follow_Type_id; parameters[2].Value = model.Follow_Type; parameters[3].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.CRM_Follow model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CRM_Follow set "); strSql.Append("Customer_id=@Customer_id,"); strSql.Append("Customer_name=@Customer_name,"); strSql.Append("Follow=@Follow,"); strSql.Append("Follow_date=@Follow_date,"); strSql.Append("Follow_Type_id=@Follow_Type_id,"); strSql.Append("Follow_Type=@Follow_Type,"); strSql.Append("department_id=@department_id,"); strSql.Append("department_name=@department_name,"); strSql.Append("employee_id=@employee_id,"); strSql.Append("employee_name=@employee_name,"); strSql.Append("isDelete=@isDelete,"); strSql.Append("Delete_time=@Delete_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@Customer_id", SqlDbType.Int, 4), new SqlParameter("@Customer_name", SqlDbType.VarChar, 250), new SqlParameter("@Follow", SqlDbType.VarChar, 4000), new SqlParameter("@Follow_date", SqlDbType.DateTime), new SqlParameter("@Follow_Type_id", SqlDbType.Int, 4), new SqlParameter("@Follow_Type", SqlDbType.VarChar, 250), new SqlParameter("@department_id", SqlDbType.Int, 4), new SqlParameter("@department_name", SqlDbType.VarChar, 250), new SqlParameter("@employee_id", SqlDbType.Int, 4), new SqlParameter("@employee_name", SqlDbType.VarChar, 250), new SqlParameter("@isDelete", SqlDbType.Int, 4), new SqlParameter("@Delete_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.Customer_id; parameters[1].Value = model.Customer_name; parameters[2].Value = model.Follow; parameters[3].Value = model.Follow_date; parameters[4].Value = model.Follow_Type_id; parameters[5].Value = model.Follow_Type; parameters[6].Value = model.department_id; parameters[7].Value = model.department_name; parameters[8].Value = model.employee_id; parameters[9].Value = model.employee_name; parameters[10].Value = model.isDelete; parameters[11].Value = model.Delete_time; parameters[12].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XHD.Model.CRM_Follow model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CRM_Follow("); strSql.Append("Customer_id,Factory_Id,Customer_name,Follow,Follow_date,Follow_Type_id,Follow_Type,department_id,department_name,employee_id,employee_name,isDelete,Delete_time)"); strSql.Append(" values ("); strSql.Append("@Customer_id,@Factory_Id,@Customer_name,@Follow,@Follow_date,@Follow_Type_id,@Follow_Type,@department_id,@department_name,@employee_id,@employee_name,@isDelete,@Delete_time)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@Customer_id", MySqlDbType.Int32, 4), new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@Customer_name", MySqlDbType.VarChar, 250), new MySqlParameter("@Follow", MySqlDbType.VarChar, 4000), new MySqlParameter("@Follow_date", MySqlDbType.DateTime), new MySqlParameter("@Follow_Type_id", MySqlDbType.Int32, 4), new MySqlParameter("@Follow_Type", MySqlDbType.VarChar, 250), new MySqlParameter("@department_id", MySqlDbType.Int32, 4), new MySqlParameter("@department_name", MySqlDbType.VarChar, 250), new MySqlParameter("@employee_id", MySqlDbType.Int32, 4), new MySqlParameter("@employee_name", MySqlDbType.VarChar, 250), new MySqlParameter("@isDelete", MySqlDbType.Int32, 4), new MySqlParameter("@Delete_time", MySqlDbType.DateTime) }; parameters[0].Value = model.Customer_id; parameters[1].Value = model.Factory_Id; parameters[2].Value = model.Customer_name; parameters[3].Value = model.Follow; parameters[4].Value = model.Follow_date; parameters[5].Value = model.Follow_Type_id; parameters[6].Value = model.Follow_Type; parameters[7].Value = model.department_id; parameters[8].Value = model.department_name; parameters[9].Value = model.employee_id; parameters[10].Value = model.employee_name; parameters[11].Value = model.isDelete; parameters[12].Value = model.Delete_time; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public XHD.Model.CRM_Follow GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,Customer_id,Customer_name,Follow,Follow_date,Follow_Type_id,Follow_Type,department_id,department_name,employee_id,employee_name,isDelete,Delete_time from CRM_Follow "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; XHD.Model.CRM_Follow model=new XHD.Model.CRM_Follow(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["id"]!=null && ds.Tables[0].Rows[0]["id"].ToString()!="") { model.id=int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if(ds.Tables[0].Rows[0]["Customer_id"]!=null && ds.Tables[0].Rows[0]["Customer_id"].ToString()!="") { model.Customer_id=int.Parse(ds.Tables[0].Rows[0]["Customer_id"].ToString()); } if(ds.Tables[0].Rows[0]["Customer_name"]!=null && ds.Tables[0].Rows[0]["Customer_name"].ToString()!="") { model.Customer_name=ds.Tables[0].Rows[0]["Customer_name"].ToString(); } if(ds.Tables[0].Rows[0]["Follow"]!=null && ds.Tables[0].Rows[0]["Follow"].ToString()!="") { model.Follow=ds.Tables[0].Rows[0]["Follow"].ToString(); } if(ds.Tables[0].Rows[0]["Follow_date"]!=null && ds.Tables[0].Rows[0]["Follow_date"].ToString()!="") { model.Follow_date=DateTime.Parse(ds.Tables[0].Rows[0]["Follow_date"].ToString()); } if(ds.Tables[0].Rows[0]["Follow_Type_id"]!=null && ds.Tables[0].Rows[0]["Follow_Type_id"].ToString()!="") { model.Follow_Type_id=int.Parse(ds.Tables[0].Rows[0]["Follow_Type_id"].ToString()); } if(ds.Tables[0].Rows[0]["Follow_Type"]!=null && ds.Tables[0].Rows[0]["Follow_Type"].ToString()!="") { model.Follow_Type=ds.Tables[0].Rows[0]["Follow_Type"].ToString(); } if(ds.Tables[0].Rows[0]["department_id"]!=null && ds.Tables[0].Rows[0]["department_id"].ToString()!="") { model.department_id=int.Parse(ds.Tables[0].Rows[0]["department_id"].ToString()); } if(ds.Tables[0].Rows[0]["department_name"]!=null && ds.Tables[0].Rows[0]["department_name"].ToString()!="") { model.department_name=ds.Tables[0].Rows[0]["department_name"].ToString(); } if(ds.Tables[0].Rows[0]["employee_id"]!=null && ds.Tables[0].Rows[0]["employee_id"].ToString()!="") { model.employee_id=int.Parse(ds.Tables[0].Rows[0]["employee_id"].ToString()); } if(ds.Tables[0].Rows[0]["employee_name"]!=null && ds.Tables[0].Rows[0]["employee_name"].ToString()!="") { model.employee_name=ds.Tables[0].Rows[0]["employee_name"].ToString(); } if(ds.Tables[0].Rows[0]["isDelete"]!=null && ds.Tables[0].Rows[0]["isDelete"].ToString()!="") { model.isDelete=int.Parse(ds.Tables[0].Rows[0]["isDelete"].ToString()); } if(ds.Tables[0].Rows[0]["Delete_time"]!=null && ds.Tables[0].Rows[0]["Delete_time"].ToString()!="") { model.Delete_time=DateTime.Parse(ds.Tables[0].Rows[0]["Delete_time"].ToString()); } return model; } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.CRM_Follow GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,Customer_id,Customer_name,Follow,Follow_date,Follow_Type_id,Follow_Type,department_id,department_name,employee_id,employee_name,isDelete,Delete_time from CRM_Follow "); strSql.Append(" where id=@id limit 1"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters[0].Value = id; XHD.Model.CRM_Follow model = new XHD.Model.CRM_Follow(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["Customer_id"] != null && ds.Tables[0].Rows[0]["Customer_id"].ToString() != "") { model.Customer_id = int.Parse(ds.Tables[0].Rows[0]["Customer_id"].ToString()); } if (ds.Tables[0].Rows[0]["Customer_name"] != null && ds.Tables[0].Rows[0]["Customer_name"].ToString() != "") { model.Customer_name = ds.Tables[0].Rows[0]["Customer_name"].ToString(); } if (ds.Tables[0].Rows[0]["Follow"] != null && ds.Tables[0].Rows[0]["Follow"].ToString() != "") { model.Follow = ds.Tables[0].Rows[0]["Follow"].ToString(); } if (ds.Tables[0].Rows[0]["Follow_date"] != null && ds.Tables[0].Rows[0]["Follow_date"].ToString() != "") { model.Follow_date = DateTime.Parse(ds.Tables[0].Rows[0]["Follow_date"].ToString()); } if (ds.Tables[0].Rows[0]["Follow_Type_id"] != null && ds.Tables[0].Rows[0]["Follow_Type_id"].ToString() != "") { model.Follow_Type_id = int.Parse(ds.Tables[0].Rows[0]["Follow_Type_id"].ToString()); } if (ds.Tables[0].Rows[0]["Follow_Type"] != null && ds.Tables[0].Rows[0]["Follow_Type"].ToString() != "") { model.Follow_Type = ds.Tables[0].Rows[0]["Follow_Type"].ToString(); } if (ds.Tables[0].Rows[0]["department_id"] != null && ds.Tables[0].Rows[0]["department_id"].ToString() != "") { model.department_id = int.Parse(ds.Tables[0].Rows[0]["department_id"].ToString()); } if (ds.Tables[0].Rows[0]["department_name"] != null && ds.Tables[0].Rows[0]["department_name"].ToString() != "") { model.department_name = ds.Tables[0].Rows[0]["department_name"].ToString(); } if (ds.Tables[0].Rows[0]["employee_id"] != null && ds.Tables[0].Rows[0]["employee_id"].ToString() != "") { model.employee_id = int.Parse(ds.Tables[0].Rows[0]["employee_id"].ToString()); } if (ds.Tables[0].Rows[0]["employee_name"] != null && ds.Tables[0].Rows[0]["employee_name"].ToString() != "") { model.employee_name = ds.Tables[0].Rows[0]["employee_name"].ToString(); } if (ds.Tables[0].Rows[0]["isDelete"] != null && ds.Tables[0].Rows[0]["isDelete"].ToString() != "") { model.isDelete = int.Parse(ds.Tables[0].Rows[0]["isDelete"].ToString()); } if (ds.Tables[0].Rows[0]["Delete_time"] != null && ds.Tables[0].Rows[0]["Delete_time"].ToString() != "") { model.Delete_time = DateTime.Parse(ds.Tables[0].Rows[0]["Delete_time"].ToString()); } return(model); } else { return(null); } }