</asp:DropDownList>
{
get
{
return (new CommonBLL()).GetZt_new("projectStatusType");
}
}
{
DataTable table;
table = CommonDA.GetCodeList3(type).Tables[0];
return table;
}
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONN;
string sql = "select a.codeValue, a.codeText, a.subId from bsCodeList a "
+ "INNER JOIN bsCodeType b ON a.codeType = b.id where (b.name = '" + typeName + "')";
SqlCommand objcommand = new SqlCommand();
objcommand.Connection = conn;
objcommand.CommandType = CommandType.Text;
objcommand.CommandText = sql;
SqlDataAdapter commandAdp = new SqlDataAdapter();
commandAdp.SelectCommand = objcommand;
DataSet data = new DataSet();
commandAdp.Fill(data, "CodeList3");
conn.Close();
return data;
}
+ "INNER JOIN bsCodeType b ON a.codeType = b.id where (b.name = '" + typeName + "')"就是调用数据库的方法,当然也可以写到数据库存储过程中,直接调用存储过程访问数据库。
{
CheckBox1.Checked = false;
//“不分页”控件是实现下面显示表(DataGrid)是否分页要求的。在页面第一次加载默认是分页的
if (Session["PrjType"] != null && Session["PrjTypeTime"] != null && Session["ProjectStatus"] != null)
{
prjType = SessionGetInt("PrjType");
dropProjectType.DataBind();
dropProjectType.SelectedValue = Session["PrjType"].ToString();
prjTypeTime = SessionGetInt("PrjTypeTime");
DropDownList1.DataBind();
DropDownList1.SelectedValue = Session["PrjTypeTime"].ToString();
prjTypeZt = SessionGetInt("PrjTypeZt");
DropDownList3.DataBind();
DropDownList3.SelectedValue = Session["PrjTypeZt"].ToString();
}
else
{
prjType = 0;
dropProjectType.DataBind();
dropProjectType.SelectedValue = "0";
prjTypeTime = 0;
DropDownList1.DataBind();
DropDownList1.SelectedValue = "0";
prjTypeZt = 3;
DropDownList3.DataBind();
DropDownList3.SelectedValue = "3";
}
BindProjects(prjType, prjTypeTime, prjTypeZt); //根据目前3个条件绑定数据
Session["PrjTypeTime"] = null;
Session["PrjTypeZt"] = null;
}
else
{
prjType = SessionGetInt("PrjType");
prjTypeTime = SessionGetInt("PrjTypeTime");
prjTypeZt = SessionGetInt("PrjTypeZt");
}
{
ListItem item = new ListItem("所有类型", "3");
DropDownList drop = (DropDownList)sender;
drop.Items.Add(item);
}
{
ProjectsCollection projectList = Project.GetProjects(_user.UserID, _user.Role, Convert.ToInt32(dropProjectType.SelectedValue), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(DropDownList3.SelectedValue));
SortGridData(projectList, SortField, SortAscending);
ProjectsGrid.DataSource = projectList;
try
{
ProjectsGrid.DataBind();
}
catch
{
ProjectsGrid.CurrentPageIndex = (ProjectsGrid.CurrentPageIndex - 1 > 0 ? ProjectsGrid.CurrentPageIndex - 1 : 0);
ProjectsGrid.DataBind();
)
}
{
DataSet ds = SqlHelper.ExecuteDataset(
ConfigurationManager.AppSettings["ConnectionString"],
"PM_ListProjectsTime", userID, Convert.ToInt32(role));
ProjectsCollection projects = new ProjectsCollection();
foreach (DataRow r in ds.Tables[0].Rows)
{
Project prj = new Project();
prj.ProjectType = Convert.ToInt32(r["ProjectType"]);
prj.ProjectTypeTime = Convert.ToInt32(r["ProjectTypeTime"]);
prj.ProjectStatus = Convert.ToInt32(r["ProjectStatus"]);
if ((type == 0 || prj.ProjectType == type) && (typetime == 0 || prj.ProjectTypeTime == typetime) && (typezt == 3 || prj.ProjectStatus == typezt))
{
prj.ProjectID = Convert.ToInt32(r["ProjectID"]); prj.Name = r["ProjectName"].ToString();
prj.Description = r["Description"].ToString();
prj.ProjectCode = r["ProjectCode"].ToString();
prj.ManagerUserID = Convert.ToInt32(r["ManagerUserID"]);
prj.ManagerUserName = Convert.ToString(r["Username"]);
prj.EstCompletionDate = Convert.ToDateTime(r["EstCompletionDate"]);
prj.EstDuration = Convert.ToDecimal(r["EstDuration"]);
//prj.ProjectStatus = Convert.ToInt32(r["ProjectStatus"]);
projects.Add(prj);
}
}
return projects;
}
CREATE PROCEDURE PM_ListProjectsTime
(
@UserID int,
@RoleID int
)
AS
IF @RoleID = 1 /*全部*/
BEGIN
SELECT ProjectID,
Name as ProjectName,
Description,
ManagerUserID,
EmpName as UserName,
EstCompletionDate,
EstDuration,
ProjectCode,
ProjectStatus,
ProjectType,
ProjectTypeTime
FROM
PM_Projects
INNER JOIN
mrBaseInf
ON
ManagerUserID = EmpID order by ProjectName
END
ELSE IF @RoleID = 2 /*自己管的项目*/
BEGIN
SELECT ProjectID,
Name as ProjectName,
Description,
ManagerUserID,
EmpName as UserName,
EstCompletionDate,
EstDuration,
ProjectCode,
ProjectType,
ProjectTypeTime,
ProjectStatus
FROM
PM_Projects
INNER JOIN
mrBaseInf
ON
ManagerUserID = EmpID
WHERE ManagerUserID = @UserID order by ProjectName
END
GO
{
ProjectsGrid.CurrentPageIndex = 0;
Session["PrjType"] = Convert.ToInt32(dropProjectType.SelectedValue);
Session["PrjTypeTime"] = Convert.ToInt32(DropDownList1.SelectedValue);
Session["PrjTypeZt"] = Convert.ToInt32(DropDownList3.SelectedValue);
try
{
BindProjects(Convert.ToInt32(dropProjectType.SelectedValue), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(DropDownList3.SelectedValue));
}
catch
{
ProjectsGrid.CurrentPageIndex = (ProjectsGrid.CurrentPageIndex - 1 > 0 ? ProjectsGrid.CurrentPageIndex - 1 : 0);
BindProjects(Convert.ToInt32(dropProjectType.SelectedValue), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(DropDownList3.SelectedValue));
}
}
{
e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lbl = (Label)e.Item.Cells[3].Controls[1];
int status = Int32.Parse(lbl.Text);
switch (status)
{
case 0:
lbl.Text = "结束";
lbl.BackColor = System.Drawing.Color.Gray;
break;
case 1:
lbl.Text = "进行中";
break;
case -1:
lbl.Text = "被关闭";
lbl.BackColor = System.Drawing.Color.Red;
break;
case -2:
lbl.Text = "停止";
lbl.BackColor = System.Drawing.Color.Red;
break;
}
if (lbl.Text == "结束")
{
m6 = m6 + 1;
Label7.Text = "共" + m6.ToString() + "个";
}
if (lbl.Text == "进行中")
{
m7 = m7 + 1;
Label8.Text = "共" + m7.ToString() + "个";
}
if (lbl.Text == "被关闭")
{
m8 = m8 + 1;
Label9.Text = "共" + m8.ToString() + "个";
}
if (lbl.Text == "停止")
{
m10 = m10 + 1;
Label10.Text = "共" + m10.ToString() + "个";
}
}