public producTypeInfo GetInfo(int id) { producTypeInfo info = null; SqlParameter[] param = { new SqlParameter("@id", id) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_producType_GetById", param); if (r != null) { info = new producTypeInfo(); while (r.Read()) { info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); info.sort = Int32.Parse(r["sort"].ToString()); info.description = r["description"].ToString(); info.keyword = r["keyword"].ToString(); } r.Close(); r.Dispose(); } return(info); }
private bool save() { if (string.IsNullOrEmpty(TB_Name.Text)) { MessageBox.Show("Bạn chưa nhập tên nhóm?"); return(false); } int id = UntilityFunction.IntegerForNull(HD_ID.Value); var type = new producTypeInfo(); type.id = id; type.name = TB_Name.Text; type.link = ""; if (id > 0) { ServiceFactory.GetInstanceProducType().Update(type); MessageBox.Show("Cập nhật thành công"); } else { HD_ID.Value = ServiceFactory.GetInstanceProducType().Add(type).ToString(); MessageBox.Show("Thêm mới thành công"); } return(true); }
public int Add(producTypeInfo info) { SqlParameter[] param = { new SqlParameter("@name", info.name), new SqlParameter("@link", info.link) }; return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_producType_Add", param).ToString())); }
public int Update(producTypeInfo info) { SqlParameter[] param = { new SqlParameter("@id", info.id) , new SqlParameter("@name",info.name), new SqlParameter("@link", info.link) }; return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_producType_Update", param)); }
public int Update(producTypeInfo info) { SqlParameter[] param = { new SqlParameter("@id", info.id) , new SqlParameter("@name",info.name), new SqlParameter("@link", info.link), new SqlParameter("@sort", info.sort), new SqlParameter("@description", info.description), new SqlParameter("@keyword", info.keyword) }; return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_producType_Update", param)); }
public List <producTypeInfo> GetList(int pageIndex, int pageSize, out int total) { List <producTypeInfo> list = null; var t = 0; SqlParameter[] param = { new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize), new SqlParameter("@totalrow", DbType.Int32) { Direction = ParameterDirection.Output } }; SqlCommand comx; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_producType_GetList", param, out comx); if (r != null) { list = new List <producTypeInfo>(); while (r.Read()) { var info = new producTypeInfo(); info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); info.sort = Int32.Parse(r["sort"].ToString()); info.description = r["description"].ToString(); info.keyword = r["keyword"].ToString(); list.Add(info); } r.Close(); r.Dispose(); t = int.Parse(comx.Parameters[2].Value.ToString()); } total = t; return(list); }