protected void Databang() { object action = Request.QueryString["action"]; if (action != null) { if (action.ToString().Equals("edit")) { int SubClassID = Int16.Parse(Request.QueryString["SubClassID"].ToString()); UserTypeSubClass s = new UserTypeSubClass(); s = Leyp.SQLServerDAL.Factory.getUserTypeSubClassDAL().getByID(SubClassID); SubTypeName.Text = s.SubClassName; Pageaction.Text = "edit"; editSubClassID.Text = SubClassID.ToString(); UserTypeDropDownList.Visible = false; } else if (action.ToString().Equals("del")) { int SubClassID = Int16.Parse(Request.QueryString["SubClassID"].ToString()); if (Leyp.SQLServerDAL.Factory.getUserTypeSubClassDAL().deleteNode(SubClassID)) { addSystemLog("成功删除用户类型ID" + SubClassID); Jscript.AjaxAlert(this, " 删除成功"); } else { Jscript.AjaxAlert(this, " 用户已经使用!不能删除!"); } } } listDatabang(); userTypeBand(); }
/// <summary> /// 将 List"UserTypeSubClass" List"UserType" 和成 List"UserSubClassView" /// </summary> /// <param name="list0">子级列表</param> /// <param name="list1">父类列表</param> /// <returns>视图列表</returns> public List <UserSubClassView> changeListForViewList(List <UserTypeSubClass> list0, List <UserType> list1) { List <UserSubClassView> al = new List <UserSubClassView>(); for (int i = 0; i < list1.Count; i++) { UserType u = list1[i]; for (int j = 0; j < list0.Count; j++) { UserTypeSubClass us = list0[j]; if (u.TypeID == us.UserTypeID) { UserSubClassView vs = new UserSubClassView(); vs.SubClassID = us.SubClassID; vs.SubClassName = us.SubClassName; vs.State = us.State; vs.UserTypeID = us.UserTypeID; vs.TypeName = u.TypeName; al.Add(vs); } } } return(al); }
/// <summary> /// 显示单据类型 /// </summary> /// <param name="id"></param> protected void setSalesTypeName(int id) { UserTypeSubClass u = new UserTypeSubClass(); u = Leyp.SQLServerDAL.Factory.getUserTypeSubClassDAL().getByID(id); SalesTypeName.Text = u.SubClassName; }
public bool insertNewUserTypeSubClass(UserTypeSubClass u) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserTypeID", SqlDbType.Int), new SqlParameter("@SubClassName", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.NVarChar) }; parameters[0].Value = u.UserTypeID; parameters[1].Value = u.SubClassName; parameters[2].Value = u.State; SQLHelper.RunProcedure("p_UserTypeSubClass_insertNewUserTypeSubClass", parameters, out rowsAffected); List <Products> list = new List <Products>(); list = new ProductsDAL().getAllProducts(); int num2 = -1; SqlDataReader reader = SQLHelper.RunProcedure("p_UserTypeSubClass_getLastRecond", null); while (reader.Read()) { num2 = reader.GetInt32(reader.GetOrdinal("SubClassID")); } for (int i = 0; i < list.Count; i++) { ProductsUserType p = new ProductsUserType(); Products products = list[i]; p.Price = products.Price; p.ProductsID = products.ProductsID; p.SubClassID = num2; new ProductsUserTypeDAL().insertNewRecord(p); } return(1 == rowsAffected); }
public bool updateUserTypeSubClass(UserTypeSubClass u) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SubClassID", SqlDbType.Int), new SqlParameter("@SubClassName", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.NVarChar) }; parameters[0].Value = u.SubClassID; parameters[1].Value = u.SubClassName; parameters[2].Value = u.State; SQLHelper.RunProcedure("p_UserTypeSubClass_updateUserTypeSubClass", parameters, out rowsAffected); return(1 == rowsAffected); }
public bool insertNewProducts(Products pro) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProductsName", SqlDbType.NVarChar), new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@BrandID", SqlDbType.Int), new SqlParameter("@Color", SqlDbType.NVarChar), new SqlParameter("@Weight", SqlDbType.NVarChar), new SqlParameter("@Spec", SqlDbType.NVarChar), new SqlParameter("@Cost", SqlDbType.Money), new SqlParameter("@ProductsUints", SqlDbType.NVarChar), new SqlParameter("@Material", SqlDbType.NVarChar), new SqlParameter("@UpperLimit", SqlDbType.Int), new SqlParameter("@LowerLimit", SqlDbType.Int), new SqlParameter("@BeginEnterDate", SqlDbType.NVarChar), new SqlParameter("@FinalEnterDate", SqlDbType.NVarChar), new SqlParameter("@LatelyOFSDate", SqlDbType.NVarChar), new SqlParameter("@UnshelveDate", SqlDbType.NVarChar), new SqlParameter("@LoadingDate", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@Price", SqlDbType.Float) }; parameters[0].Value = pro.ProductsName; parameters[1].Value = pro.TypeID; parameters[2].Value = pro.BrandID; parameters[3].Value = pro.Color; parameters[4].Value = pro.Weight; parameters[5].Value = pro.Spec; parameters[6].Value = pro.Cost; parameters[7].Value = pro.ProductsUints; parameters[8].Value = pro.Material; parameters[9].Value = pro.UpperLimit; parameters[10].Value = pro.LowerLimit; parameters[11].Value = pro.BeginEnterDate; parameters[12].Value = pro.FinalEnterDate; parameters[13].Value = pro.LatelyOFSDate; parameters[14].Value = pro.UnshelveDate; parameters[15].Value = pro.LoadingDate; parameters[0x10].Value = pro.Description; parameters[0x11].Value = pro.Price; SQLHelper.RunProcedure("p_Products_InsertNew", parameters, out rowsAffected); if (rowsAffected == 1) { List <UserTypeSubClass> list = new List <UserTypeSubClass>(); list = new UserTypeSubClassDAL().getAllUserTypeSubClass(); int num2 = -1; SqlDataReader reader = SQLHelper.RunProcedure("p_Products_GetLastRecond", null); while (reader.Read()) { num2 = reader.GetInt32(reader.GetOrdinal("ProductsID")); } for (int i = 0; i < list.Count; i++) { ProductsUserType p = new ProductsUserType(); UserTypeSubClass class2 = list[i]; p.Price = pro.Price; p.ProductsID = num2; p.SubClassID = class2.SubClassID; new ProductsUserTypeDAL().insertNewRecord(p); } } return(1 == rowsAffected); }
public UserTypeSubClass getByID(int SubClassID) { UserTypeSubClass class2 = new UserTypeSubClass(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SubClassID", SqlDbType.Int, 4) }; parameters[0].Value = SubClassID; SqlDataReader reader = SQLHelper.RunProcedure("p_UserTypeSubClass_getByID", parameters); while (reader.Read()) { class2.SubClassID = reader.GetInt32(reader.GetOrdinal("SubClassID")); class2.SubClassName = reader.GetString(reader.GetOrdinal("SubClassName")); class2.State = reader.GetString(reader.GetOrdinal("State")); class2.UserTypeID = reader.GetInt32(reader.GetOrdinal("UserTypeID")); } return(class2); }
public List <UserTypeSubClass> getAllUserTypeSubClass() { List <UserTypeSubClass> list = new List <UserTypeSubClass>(); SqlDataReader reader = SQLHelper.RunProcedure("p_UserTypeSubClass_getAllUserTypeSubClass", null); while (reader.Read()) { UserTypeSubClass item = new UserTypeSubClass(); item.UserTypeID = reader.GetInt32(reader.GetOrdinal("UserTypeID")); item.SubClassID = reader.GetInt32(reader.GetOrdinal("SubClassID")); item.SubClassName = reader.GetString(reader.GetOrdinal("SubClassName")); item.State = reader.GetString(reader.GetOrdinal("State")); list.Add(item); } reader.Close(); return(list); }
protected void updateButton_Click(object sender, EventArgs e) { string str = SubTypeName.Text.ToString(); string str1 = DropDownList1.SelectedValue.ToString(); int UserTypeID = int.Parse(UserTypeDropDownList.SelectedValue.ToString()); UserTypeSubClass s = new UserTypeSubClass(); s.UserTypeID = UserTypeID; s.SubClassName = str; s.State = str1; if (Pageaction.Text.ToString().Equals("edit")) { s.SubClassID = int.Parse(editSubClassID.Text.ToString()); if (Leyp.SQLServerDAL.Factory.getUserTypeSubClassDAL().updateUserTypeSubClass(s)) { addSystemLog("成功更新用户类型ID" + editSubClassID.Text.ToString()); Panel1.Visible = false; HyperLink1.Visible = true; } else { Panel1.Visible = false; HyperLink1.Text = "操作失败!返回列表"; HyperLink1.Visible = true; } } else { if (Leyp.SQLServerDAL.Factory.getUserTypeSubClassDAL().insertNewUserTypeSubClass(s)) { addSystemLog("成功添加用户类型" + str); Panel1.Visible = false; HyperLink1.Visible = true; } else { Panel1.Visible = false; HyperLink1.Text = "操作失败!可能系信息重复!返回列表"; HyperLink1.Visible = true; } } }
public List <UserTypeSubClass> getSubClassByUserTypeID(int UserTypeID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserTypeID", SqlDbType.Int) }; parameters[0].Value = UserTypeID; List <UserTypeSubClass> list = new List <UserTypeSubClass>(); SqlDataReader reader = SQLHelper.RunProcedure("p_UserTypeSubClass_getByUserTypeID", parameters); while (reader.Read()) { UserTypeSubClass item = new UserTypeSubClass(); item.UserTypeID = reader.GetInt32(reader.GetOrdinal("UserTypeID")); item.SubClassID = reader.GetInt32(reader.GetOrdinal("SubClassID")); item.SubClassName = reader.GetString(reader.GetOrdinal("SubClassName")); item.State = reader.GetString(reader.GetOrdinal("State")); list.Add(item); } reader.Close(); return(list); }
/// <summary> /// 添加一个新的子类 /// </summary> /// <param name="g"></param> /// <returns></returns> public bool insertNewUserTypeSubClass(UserTypeSubClass u) { return(userTypeSubClassDAL.insertNewUserTypeSubClass(u)); }