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));
}
