protected void Page_Load(object sender, EventArgs e)
{
VerfiyAdmin.CheckAdminLogin(this);
if (!IsPostBack)
{
var idx = Request["Id"];
if (string.IsNullOrEmpty(idx))
{
Response.End(); return;
}
var et = new Tab_QA_SubType();
et = et.Get(idx);
if (null == et)
{
Response.End(); return;
}
var etm = new Tab_QA_Type().Get(et.QaTypeIdx_Fx.ToString());
if (null == etm)
{
txtName.Text = "所属的QA大类不存在";
}
else
{
txtName.Text = etm.QaTypeName;
}
txtTitle.Text = et.QaSubTypeName;
}
}
/// <summary>
/// 获取所有QA大类
/// </summary>
/// <returns></returns>
public List <Tab_QA_Type> GetQAMainType()
{
var ets = new Tab_QA_Type().ListAll("select * from Tab_QA_Type order by SortNumb");
if (null == ets)
{
return(null);
}
return(ets.ToList());
}
protected void QATtype_SelectedIndexChanged(object sender, EventArgs e)
{
var et = new Tab_QA_Type().Get(QATtype.SelectedValue);
if (null != et)
{
txtQAMType.Text = et.QaTypeName;
txtMSort.Text = et.SortNumb.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerfiyAdmin.CheckAdminLogin(this);
if (!IsPostBack)
{
var idx = Request["Id"];
if (string.IsNullOrEmpty(idx))
{
Response.End(); return;
}
var et = new Tab_QA_Type().Get(idx);
if (null == et)
{
Response.End(); return;
}
txtName.Text = et.QaTypeName;
txtTitle.Text = et.SortNumb.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int stn = 1;
var idx = Request["Id"];
if (string.IsNullOrEmpty(idx))
{
Response.End(); return;
}
var et = new Tab_QA_Type().Get(idx);
if (null == et)
{
Response.End(); return;
}
if (Int32.TryParse(txtTitle.Text, out stn))
{
et.SortNumb = stn;
}
et.QaTypeName = txtName.Text;
et.Update(et);
Cmn.Js.ExeScriptBlock("alert('操作成功');window.location.href='QATypeManage.aspx';");
}
/// <summary>
/// 保存大类
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button4_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(QATtype.SelectedValue))
{
return;
}
var ent = new Tab_QA_Type().Get(QATtype.SelectedValue);
if (null == ent)
{
return;
}
ent.QaTypeName = txtQAMType.Text.Trim();
var sort = 0;
if (Int32.TryParse(txtMSort.Text, out sort))
{
ent.SortNumb = sort;
}
ent.Update(ent);
Response.Redirect("QATypeEdit.aspx");
}
/// <summary>
/// 按页或类型名获取QA主类别名称信息
/// </summary>
/// <param name="startRowIndex"></param>
/// <param name="maximumRows"></param>
/// <param name="mtypename"></param>
/// <returns></returns>
public static List <Tab_QA_Type> GetQAMainType(int startRowIndex = 1, int maximumRows = 10, string mtypename = null)
{
bool bTotalCount = false;
maximumRows = maximumRows <= 1 ? 10 : maximumRows;
int pgIdx = startRowIndex / maximumRows; pgIdx = (pgIdx < 1 || startRowIndex <= 0) ? 1 : (startRowIndex / maximumRows) + 1;
if (startRowIndex == 0)
{
pgIdx = 1;
}
SqlParameter prmWhr = new SqlParameter("@strWhere", string.Empty);
if (!string.IsNullOrEmpty(mtypename))
{
prmWhr.SqlValue = "QaTypeName like '%" + mtypename + "%'";
}
var prmDoCount = new SqlParameter("@doCount", bTotalCount);
SqlParameter[] prms = new SqlParameter[] {
new SqlParameter("@tblName", "Tab_QA_Type"),
new SqlParameter("@strGetFields", "*"),
new SqlParameter("@fldName", "Idx"),
new SqlParameter("@PageSize", maximumRows),
new SqlParameter("@PageIndex", pgIdx),
prmDoCount,
new SqlParameter("@OrderType", true),//降序
prmWhr
};
var ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "P_Y_Pagination", prms);
if (null == ds || ds.Tables == null || ds.Tables.Count < 1)
{
return(null);
}
return(Tab_QA_Type.ToModel(ds.Tables[0]));
}
