/// <summary>
/// 如何是修改，则读取数据绑定
/// </summary>
/// <param name="questionID"></param>
protected void databind(int questionID)
{
E_Question data = new E_Question();
data.QuestionID = questionID;
data.EnterpriseID = EnterpriceID;
data = new T_Question().GetModel(data);
if (data != null)
{
txtQuestionName.Text = data.QuestionName;
rblQuestionType.SelectedValue = data.QuestionType.ToString();
rpList.DataSource = data.QuestionItem;
rpList.DataBind();
}
//加载与该问题相关的名录
data = new E_Question();
data.EnterpriseID = EnterpriceID;
data.QuestionID = questionID;
DataTable dt = new T_Question().ListSelect(data);
lblClientNum.Text = dt.Rows.Count.ToString();
rpClientInfo.DataSource = dt;
rpClientInfo.DataBind();
}
/// <summary>
/// 查询与该问题相关的名录信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-07</remarks>
public DataTable ListSelect(E_Question data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@QuestionID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.QuestionID;
return(DbHelperSQL.RunProcedureTable("ProcEP_B_ClientInfoS_ListSelect", parms));
}
/// <summary>
/// 获取问题列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-04</remarks>
public DataSet List(E_Question data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@ClientInfoID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.ClientInfoID;
DataSet ds = DbHelperSQL.RunProcedureDataSet("ProcEP_B_QuestionS_List", parms);
return(ds);
}
/// <summary>
/// 删除问题
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-14</remarks>
public bool Delete(E_Question data)
{
int rowsAffected = 0;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@QuestionID", SqlDbType.Int),
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.QuestionID;
parms[1].Value = data.EnterpriseID;
DbHelperSQL.ExecProcedure("ProcEP_B_QuestionS_Delete", parms, out rowsAffected);
return(rowsAffected > 0);
}
/// <summary>
/// 更新问题
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-14</remarks>
public bool Update(E_Question data)
{
int rowsAffected = 0;
string child_ItemIDs = string.Empty;
string child_ItemNameS = string.Empty;
//参数列表
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@QuestionID", SqlDbType.Int),
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@QuestionName", SqlDbType.VarChar, 128),
new SqlParameter("@QuestionType", SqlDbType.TinyInt),
new SqlParameter("@Child_ItemIDs", SqlDbType.VarChar),
new SqlParameter("@Child_ItemNameS", SqlDbType.VarChar),
new SqlParameter("@Separation", SqlDbType.VarChar, 2),
new SqlParameter("@Flag", SqlDbType.TinyInt)
};
parms[0].Value = data.QuestionID;
parms[1].Value = data.EnterpriseID;
parms[2].Value = data.QuestionName;
parms[3].Value = data.QuestionType;
//拼装child_Item
for (int i = 0; i < data.QuestionItem.Count; i++)
{
if (i == 0)
{
child_ItemIDs = data.QuestionItem[i].QuestionItemID.ToString();
child_ItemNameS = data.QuestionItem[i].QuestionItemName;
}
else
{
//加上分隔符
child_ItemIDs += MLMGC.COMP.Config.Separation + data.QuestionItem[i].QuestionItemID.ToString();
child_ItemNameS += MLMGC.COMP.Config.Separation + data.QuestionItem[i].QuestionItemName;
}
}
parms[4].Value = child_ItemIDs;
parms[5].Value = child_ItemNameS;
parms[6].Value = MLMGC.COMP.Config.Separation;
parms[7].Value = data.Flag;
DbHelperSQL.ExecProcedure("ProcEP_B_QuestionS_Update", parms, out rowsAffected);
return(rowsAffected > 0);
}
/// <summary>
/// 更新调查问卷答案
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-07</remarks>
public bool UpdateQuestion(E_Question data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@ClientInfoID", SqlDbType.Int),
new SqlParameter("@EPUserTMRID", SqlDbType.Int),
new SqlParameter("@QuestionItemIDs", SqlDbType.VarChar)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.ClientInfoID;
parms[2].Value = data.EPUserTMRID;
parms[3].Value = data.QuestionItemIDs;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_R_CIQuestionS_Update", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 绑定数据
/// </summary>
protected void databind(string questionName)
{
E_Question data = new E_Question();
data.EnterpriseID = EnterpriceID;
data.QuestionName = questionName;
//分页参数
data.Page = new MLMGC.DataEntity.E_Page();
data.Page.PageSize = pageSize;
data.Page.PageIndex = pageIndex;
rpList.DataSource = new T_Question().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
/// <summary>
/// 获取问题列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-14</remarks>
public DataTable GetList(E_Question data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@QuestionName", SqlDbType.VarChar, 128),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalCount", SqlDbType.Int),
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.QuestionName;
parms[2].Value = data.Page.PageIndex;
parms[3].Value = data.Page.PageSize;
parms[4].Direction = ParameterDirection.Output;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_QuestionS_ListSelect", parms);
data.Page.TotalCount = parms[4].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[4].Value);
return(dt);
}
/// <summary>
/// 增加问题
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks >tianzhenyun 2011-10-14</remarks>
public bool Add(E_Question data)
{
int rowsAffected = 0;
string child_ItemNameS = string.Empty;
//参数列表
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@QuestionID", SqlDbType.Int),
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@QuestionName", SqlDbType.VarChar, 128),
new SqlParameter("@QuestionType", SqlDbType.TinyInt),
new SqlParameter("@Child_Item", SqlDbType.VarChar),
new SqlParameter("@Separation", SqlDbType.VarChar, 2)
};
parms[0].Direction = ParameterDirection.Output;
parms[1].Value = data.EnterpriseID;
parms[2].Value = data.QuestionName;
parms[3].Value = data.QuestionType;
//拼装child_Item
for (int i = 0; i < data.QuestionItem.Count; i++)
{
if (i == 0)
{
child_ItemNameS = data.QuestionItem[i].QuestionItemName;
}
else
{
//加上分隔符
child_ItemNameS += MLMGC.COMP.Config.Separation + data.QuestionItem[i].QuestionItemName;
}
}
parms[4].Value = child_ItemNameS;
parms[5].Value = MLMGC.COMP.Config.Separation;
DbHelperSQL.ExecProcedure("ProcEP_B_QuestionS_Insert", parms, out rowsAffected);
data.QuestionID = Convert.ToInt32(parms[0].Value);
return(rowsAffected > 0);
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
clientinfoid = Requests.GetQueryInt("ciid", 0);
E_Question data = new E_Question();
data.EnterpriseID = EnterpriceID;
data.ClientInfoID = clientinfoid;
DataSet ds = new T_Question().List(data);
if (ds != null && ds.Tables.Count == 2)
{
if (ds.Tables[0].Rows.Count == 0)
{
hide = true;
}
dtItem = ds.Tables[1];
rpList.DataSource = ds.Tables[0];
rpList.DataBind();
}
}
/// <summary>
/// 删除问题
/// </summary>
/// <param name="questionID"></param>
protected void Delete(int questionID)
{
E_Question data = new E_Question();
data.QuestionID = questionID;
data.EnterpriseID = EnterpriceID;
bool flag = new T_Question().Delete(data);
if (flag)
{
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "删除问题", IP = MLMGC.COMP.Requests.GetRealIP()
});
//MLMGC.COMP.Jscript.AlertAndRedirect(this, "删除成功", "MaterialList.aspx");
MLMGC.COMP.Jscript.ShowMsg("删除成功", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("删除失败", this);
}
}
/// <summary>
/// 得到一个问题对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-14</remarks>
public E_Question GetModel(E_Question data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@QuestionID", SqlDbType.Int),
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.QuestionID;
parms[1].Value = data.EnterpriseID;
DataSet ds = DbHelperSQL.RunProcedureDataSet("ProcEP_B_QuestionS_Select", parms);
DataTable questionTable = ds.Tables[0];
DataTable itemTable = ds.Tables [1];
if (questionTable != null && questionTable.Rows.Count == 1)
{
data.QuestionName = questionTable.Rows[0]["QuestionName"].ToString();
data.QuestionType = Convert.ToInt32(questionTable.Rows[0]["QuestionType"]);
data.UpdateDate = Convert.ToDateTime(questionTable.Rows[0]["UpdateDate"]);
//封装问题选项
List <E_QuestionItem> list = null;
if (itemTable != null && itemTable.Rows.Count > 0)
{
list = new List <E_QuestionItem>();
}
E_QuestionItem item = null;
foreach (DataRow row in itemTable.Rows)
{
item = new E_QuestionItem();
item.QuestionItemID = Convert.ToInt32(row["QuestionItemID"]);
item.QuestionItemName = row["QuestionItemName"].ToString();
list.Add(item);
}
data.QuestionItem = list;
return(data);
}
return(null);
}
/// <summary>
/// 查询与该问题相关的名录信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-07</remarks>
public DataTable ListSelect(E_Question data)
{
return(dal.ListSelect(data));
}
/// <summary>
/// 更新调查问卷答案
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-07</remarks>
public bool UpdateQuestion(E_Question data)
{
return(dal.UpdateQuestion(data));
}
/// <summary>
/// 调查问题列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataSet List(E_Question data)
{
return(dal.List(data));
}
/// <summary>
/// 得到调查问题列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataTable GetList(E_Question data)
{
return(dal.GetList(data));
}
/// <summary>
/// 得到调查问题对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public E_Question GetModel(E_Question data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 删除调查问题
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Delete(E_Question data)
{
return(dal.Delete(data));
}
/// <summary>
/// 增加调查问题
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Add(E_Question data)
{
return(dal.Add(data));
}
/// <summary>
/// 点击保存按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//判断标题是否输入
string questionName = txtQuestionName.Text;
if (questionName == "")
{
MLMGC.COMP.Jscript.ShowMsg("请输入标题", this);
return;
}
//获取界面里所有隐藏域集合
System.Collections.Specialized.NameValueCollection nv = Request.Form;
string[] child_ItemIDs = nv.GetValues("hdQuestionItemIDs");
string[] child_ItemNameS = nv.GetValues("hdQuestionItemNameS");
if (child_ItemIDs == null || child_ItemNameS == null)
{
return;
}
if (child_ItemIDs.Length != child_ItemNameS.Length)
{
MLMGC.COMP.Jscript.ShowMsg("参数错误", this);
return;
}
if (child_ItemIDs.Length == 0)
{
MLMGC.COMP.Jscript.ShowMsg("请输入选项", this);
return;
}
//封装数据
E_Question data = new E_Question();
data.EnterpriseID = EnterpriceID;
data.QuestionName = questionName;
data.Flag = cbDeleteRelation.Checked ? 1 : 0;
data.QuestionType = Convert.ToInt32(rblQuestionType.SelectedValue);
data.QuestionItem = new List <E_QuestionItem>();
E_QuestionItem item = null;
for (int i = 0; i < child_ItemIDs.Length; i++)
{
item = new E_QuestionItem();
item.QuestionItemID = Convert.ToInt64(child_ItemIDs[i]);
item.QuestionItemName = child_ItemNameS[i];
data.QuestionItem.Add(item);
}
//判断是添加还是修改
if (type == "add")
{
bool flag = new T_Question().Add(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "添加问题", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
MLMGC.COMP.Jscript.AlertAndRedirect(this, "添加成功", "QuestionList.aspx");
}
else
{
MLMGC.COMP.Jscript.ShowMsg("添加失败", this);
}
}
else
{
//获取项目资料编号
int questionID = MLMGC.COMP.Requests.GetQueryInt("questionid", 0);
data.QuestionID = questionID;
bool flag = new T_Question().Update(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "修改问题", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
MLMGC.COMP.Jscript.AlertAndRedirect(this, "修改成功", "QuestionList.aspx");
}
else
{
MLMGC.COMP.Jscript.ShowMsg("修改失败", this);
}
}
}
