/// <summary>
/// ɾ��ijĿ¼
/// </summary>
/// <param name="ClassID">��ĿID</param>
public void Delete(int ClassID)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@TeamID" , SqlDbType.Int, 20, ClassID),
};
try
{
data.RunProc("sp_DeleteTeam", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
/// <summary>
/// ��Ŀ¼�ڵ�
/// </summary>
/// <param name="ClassID">��Ŀ¼�ڵ�</param>
/// <returns>��Ŀ¼�ڵ�</returns>
public void AddClass(int ParentID, string ClassName, string ClassRemark, int ClassType, string AddedBy, DateTime AddedDate, int Status)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@ClassParentID" , SqlDbType.Int, 20, ParentID),
data.MakeInParam("@ClassName" , SqlDbType.NVarChar, 20, ClassName),
data.MakeInParam("@ClassRemark" , SqlDbType.NVarChar, 400, ClassRemark),
data.MakeInParam("@ClassType" , SqlDbType.Int, 1, ClassType),
data.MakeInParam("@AddedBy" , SqlDbType.NVarChar, 40, AddedBy),
data.MakeInParam("@AddedDate" , SqlDbType.DateTime, 30, AddedDate),
data.MakeInParam("@Status" , SqlDbType.Int, 1, Status)
};
try
{
data.RunProc("sp_AddTeam", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("Ŀ¼��ӳ���", ex);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
/// <summary>
/// 获得前5条已经全部确认的任务列表
/// </summary>
public string[] GetTop5ConfirmedTaskList(string Date, string Username)
{
// 定义数据库操作类及DataReader
Database data = new Database();
SqlDataReader dataReader = null;
String[] a = new String[5] {
"0", "0", "0", "0", "0"
};
// 执行存储过程，并返回SqlDataReader对象
SqlParameter[] prams =
{
data.MakeInParam("@Username", SqlDbType.VarChar, 20, Username),
data.MakeInParam("@Date", SqlDbType.VarChar, 30, Date)
};
try
{
data.RunProc("sp_GetTop5ConfirmedTask", prams, out dataReader);
int c = 0;
while (dataReader.Read())
{
if (dataReader[1].ToString() == dataReader[2].ToString())
{
a[c] = dataReader[0].ToString();
}
c++;
}
dataReader = null;
return(a);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("获得前5条已经全部确认的任务列表出错!", ex);
}
finally
{
data.Dispose();
dataReader = null;
}
}
public void AddBoardMaster(int boardid, int staffid)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@BoardID", SqlDbType.Int, 4,boardid),
data.MakeInParam("@StaffID", SqlDbType.Int, 4,staffid)
};
try
{
data.RunProc("sp_BBS_SetupBoardMaster", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
/// <summary>
/// ��ȡ�û�������Ϣ
/// </summary>
/// <param name="Username">�û�����</param>
/// <returns>������ʵ����</returns>
public static string GetRealNameByUsername(string Username)
{
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@Username", SqlDbType.NVarChar, 30, Username),
};
try
{
// run the stored procedure
data.RunProc("sp_GetRealNameByUsername",prams,out dataReader);
if(dataReader.Read())
{
return dataReader[0].ToString();
}
else
{
return "";
}
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("��Ա��Ϣ��ȡ����!",ex);
}
finally
{
dataReader.Close();
data.Dispose();
}
}
//string CatalogName,string CatalogDescription
//给uds_bbs_catalog表,新增记录
public bool AddBBSCatalog(BBSCatalog BBSCatalog)
{
//参数 CatalogName 表示BBS中的title , 参数 CatalogDescription 表示BBS中的content
//给存储过程传递参数
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@title", SqlDbType.VarChar, 300, BBSCatalog.CatalogName),
data.MakeInParam("@content", SqlDbType.NText, 16, BBSCatalog.CatalogDescription),
};
try
{
data.RunProc("sp_BBS_AddCatalog", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
return true;
}
/// <summary>
/// Ŀ¼���
/// </summary>
public void Add(int ParentID,string ProjectName,string ProjectRemark,string Wright,int Status,int Scale,DateTime StartDate,DateTime EndDate)
{
// �������ݿ�����༰DataReader
Database data = new Database();
// ִ�д洢���̣�������SqlDataReader����
SqlParameter[] prams = {
data.MakeInParam("@ParentID" , SqlDbType.Int, 20, ParentID),
data.MakeInParam("@ProjectName" , SqlDbType.NVarChar, 20, ProjectName),
data.MakeInParam("@ProjectRemark" , SqlDbType.NVarChar, 400, ProjectRemark),
data.MakeInParam("@Wright" , SqlDbType.NVarChar, 40, Wright),
data.MakeInParam("@Status" , SqlDbType.Int, 40, Status),
data.MakeInParam("@Scale" , SqlDbType.Int, 20, Scale),
data.MakeInParam("@StartDate" , SqlDbType.DateTime, 30, StartDate),
data.MakeInParam("@EndDate" , SqlDbType.DateTime, 30, EndDate)
};
try
{
data.RunProc("sp_AddProject",prams);
}
catch(Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("��Ŀ��ӳ���",ex);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
data = null;
}
}
/// <summary>
/// ���ij���������ϸ��Ϣ
/// </summary>
public TaskClass GetTaskDetail(int TaskID)
{
// �������ݿ�����༰DataReader
Database data = new Database();
SqlDataReader dataReader = null;
TaskClass tsk = new TaskClass();
// ִ�д洢���̣�������SqlDataReader����
SqlParameter[] prams = {
data.MakeInParam("@TaskID", SqlDbType.Int,8, TaskID)
};
try
{
data.RunProc("sp_GetTaskDetail",prams,out dataReader);
if(dataReader.Read())
{
tsk.ArrangedBy = dataReader["ArrangedBy"].ToString();
tsk.Detail = dataReader["Detail"].ToString();
tsk.StartTime = dataReader["StartTime"].ToString();
tsk.EndTime = dataReader["EndTime"].ToString();
tsk.ProjectID = Int32.Parse(dataReader["ProjectID"].ToString());
tsk.Subject = dataReader["Subject"].ToString();
tsk.CooperatorList = dataReader["CooperatorList"].ToString();
tsk.Type = Int32.Parse(dataReader["Type"].ToString());
tsk.Attribute = dataReader["Attribute"].ToString()=="True"?1:0;
tsk.ContractList = dataReader["ContractList"].ToString();
}
dataReader = null;
data.Dispose();
return tsk;
}
catch(Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("���ij������ij��ĵ�ʱ��γ���!",ex);
}
finally
{
if (data != null)
{
data.Close();
}
if (dataReader != null)
{
dataReader.Close();
}
dataReader = null;
}
}
/// <summary>
/// ���ij������ij��ĵ�ʱ��� ���س���Ϊ11��int�����飬��������ij��ԭ��û��ֵ����ֵΪ0
/// </summary>
public int[] GetTaskPeriod(string Date,string Username,int TaskID)
{
// �������ݿ�����༰DataReader
Database data = new Database();
SqlDataReader dataReader = null;
int[] a = new int[20]{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
// ִ�д洢���̣�������SqlDataReader����
SqlParameter[] prams = {
data.MakeInParam("@Username", SqlDbType.VarChar, 20, Username),
data.MakeInParam("@Date", SqlDbType.VarChar,30, Date),
data.MakeInParam("@TaskID", SqlDbType.Int,8, TaskID)
};
try
{
data.RunProc("sp_GetTaskPeriod",prams,out dataReader);
while(dataReader.Read())
{
a[Int32.Parse(dataReader[0].ToString())-1] = 7+Int32.Parse(dataReader[0].ToString());
}
dataReader = null;
data.Dispose();
return a;
}
catch(Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("���ij������ij��ĵ�ʱ��γ���!",ex);
}
finally
{
if (data != null)
{
data.Close();
}
if (dataReader != null)
{
dataReader.Close();
}
dataReader = null;
}
}
/// <summary>
/// ɾ��һ���ĵ�
/// </summary>
/// <param name="MailIDStr">�ĵ�ID�������ַ������ö�������</param>
public bool DocDelete(string DocIDStr,int DeleteType)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@DocIDs", SqlDbType.VarChar,4000, DocIDStr),
data.MakeInParam("@DeleteType",SqlDbType.Int,1,DeleteType)
};
try
{
data.RunProc("SP_DeleteDocument",prams);
data = null;
return true;
}
catch(Exception ex)
{
Error.Log(ex.ToString());
return false;
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
/// <summary>
/// 判断是否有管理权限
/// </summary>
/// <param name="username">用户名</param>
/// <returns>bool</returns>
public bool AdminBBS(string username, int classid)
{
if (classid != 0)
{
int actid = 8;
Database db = new Database();
SqlParameter[] prams = {
db.MakeInParam("@Class_ID",SqlDbType.Int,4,classid),
db.MakeInParam("@Username",SqlDbType.VarChar,100,username),
db.MakeInParam("@Act_ID",SqlDbType.Int,4,actid),
db.MakeOutParam("@ReturnValue",SqlDbType.Int,4)
};
try
{
db.RunProc("sp_GetAccessPermission", prams);
// 仅做测试用
// return(true);
return ((Int32.Parse(prams[3].Value.ToString()) == 1) ? true : false);
}
catch (Exception ex)
{
Error.Log(ex.Message);
throw new Exception("BBS权限判断错误!", ex);
}
finally
{
db.Close();
db.Dispose();
}
}
else
return (false);
}
/// <summary>
/// 判断用户对对象是否有某个权限
/// </summary>
/// <param name="UserName">用户名</param>
/// <param name="classID">被检查的对象</param>
/// <param name="actID">权限ID</param>
/// <returns>是否有权限</returns>
public bool GetAccessPermission(string UserName,int classID,int actID)
{
int flag = 0;
// 定义数据库操作类及DataReader
Database data = new Database();
// 执行存储过程，并返回SqlDataReader对象
SqlParameter[] prams = {
data.MakeInParam("@Class_ID" , SqlDbType.Int, 20, classID),
data.MakeInParam("@UserName" , SqlDbType.NVarChar, 20, UserName),
data.MakeInParam("@Act_ID" , SqlDbType.Int, 20, actID),
// data.MakeInParam("@Inheit" , SqlDbType.Bit, 1, 1),
data.MakeOutParam("@ReturnValue",SqlDbType.Int,20)
};
try
{
data.RunProc("sp_GetAccessPermission",prams);
flag = Int32.Parse(prams[3].Value.ToString());
return (flag==1)?true:false;
}
catch(Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("获取访问权出错",ex);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
data = null;
}
}
}
/// <summary>
/// �ļ��������ݿ����
/// </summary>
/// <param name="att">DocAttachFile��</param>
/// <param name="DocID">�ļ�ID</param>
public void AddAttach(DocAttachFile att,int DocID)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@DocID", SqlDbType.Int, 20, DocID),
data.MakeInParam("@FileName", SqlDbType.VarChar, 300, att.FileName),
data.MakeInParam("@FileSize", SqlDbType.Int, 20, att.FileSize),
data.MakeInParam("@FileAttribute", SqlDbType.SmallInt,20, att.FileAttribute),
data.MakeInParam("@FileVisualPath", SqlDbType.NVarChar, 200, att.FileVisualPath),
data.MakeInParam("@FileAuthor", SqlDbType.NVarChar, 50, att.FileAuthor),
data.MakeInParam("@FileCatlog", SqlDbType.NVarChar, 20, att.FileCatlog),
data.MakeInParam("@FileAddedDate", SqlDbType.DateTime, 30, DateTime.Parse(att.FileAddedDate))
};
try
{
data.RunProc("SP_Ext_AddFile", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("�ļ��������ͳ���!",ex);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
//设置成员
public bool SetupBoardMember(int boardid, int staffid)
{
//参数:
// @BoardID int : 板块ID
// @StaffID int : 员工ID
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@BoardID", SqlDbType.Int, 4, boardid),
data.MakeInParam("@StaffID", SqlDbType.Int, 4, staffid),
};
try
{
data.RunProc("sp_BBS_SetupBoardMember", prams);
return true;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return false;
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
idtype = Request.QueryString["idtype"].ToString();
ids = Request.QueryString["ids"].ToString();
begintime = Request.QueryString["begintime"].ToString();
endtime = Request.QueryString["endtime"].ToString();
ViewState["idtype"] = idtype;
ViewState["ids"] = ids;
ViewState["begintime"] = begintime;
ViewState["endtime"] = endtime;
}
else
{
idtype = ViewState["idtype"].ToString();
ids = ViewState["ids"].ToString();
begintime = ViewState["begintime"].ToString();
endtime = ViewState["endtime"].ToString();
}
ds_Duty = (DataSet)Cache["WA_Duty"];
//��TotalDuty.xsd��üܹ�
ds_Report = new DataSet();
ds_Report.ReadXmlSchema(Request.MapPath(".")+"\\TotalDuty.xsd");
#region �������������
if(ds_Duty==null)
{
//���»�ȡds_Duty
SqlDataReader dr,dr1,dr2;
SqlParameter[] prams = new SqlParameter[4];
UDS.Components.Database db = new UDS.Components.Database();
DataSet ds = new DataSet();
//�õ���������
prams[0] = db.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime);
prams[1] = db.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime);
prams[2] = db.MakeInParam("@ids",SqlDbType.VarChar,1000,ids);
prams[3] = db.MakeInParam("@idtype",SqlDbType.VarChar,50,idtype);
db.RunProc("sp_WA_GetAttendanceData",prams,out dr);
DataTable datatable = Tools.ConvertDataReaderToDataTable(dr);
ds.Tables.Add(datatable);
db.Dispose();
dr.Close();
//�õ���Ա����
if(idtype=="staff")
{
SqlParameter[] prams1 = {db.MakeInParam("@ids",SqlDbType.VarChar,1000,ids)};
db.RunProc("sp_WA_GetSelectedStaffFromID",prams1,out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
db.Dispose();
dr1.Close();
}
else if(idtype=="Position")
{
SqlParameter[] prams1 = {
db.MakeInParam("@Position_id",SqlDbType.Int,4,Int32.Parse(ids)),
db.MakeInParam("@Dimission",SqlDbType.Bit,1,0)
};
db.RunProc("sp_GetStaffInPosition",prams1,out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
db.Dispose();
dr1.Close();
}
else if(idtype=="company")
{
SqlParameter[] prams1 = {
db.MakeInParam("@StaffType",SqlDbType.Int,4,0)
};
db.RunProc("sp_GetAllStaff",prams1,out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
db.Dispose();
dr1.Close();
}
SqlParameter[] prams2 = {
db.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
db.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
};
db.RunProc("sp_WA_GetDutyDay",prams2,out dr2);
DataTable datatable2 = Tools.ConvertDataReaderToDataTable(dr2);
ds.Tables.Add(datatable2);
db.Dispose();
dr2.Close();
//��������
Cache["WA_Duty"] = ds;
ds_Duty = (DataSet)Cache["WA_Duty"];
}
#endregion
//����ds_Report�Կ���rpt
//ds_Duty.Tables[0] ��������
//ds_Duty.Tables[1] ��Ա����
//ds_Duty.Tables[2] ������������
//������Ա���ݱ��������µ�ds_Report
for(int i=0;i<ds_Duty.Tables[1].Rows.Count;i++)
{
DataRow row = ds_Report.Tables[0].NewRow();
row[0] = ds_Duty.Tables[1].Rows[i]["RealName"];
row[1] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView,ds_Duty.Tables[2].DefaultView,ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(),0);
row[2] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView,ds_Duty.Tables[2].DefaultView,ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(),1);
row[3] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView,ds_Duty.Tables[2].DefaultView,ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(),2);
row[4] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView,ds_Duty.Tables[2].DefaultView,ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(),3);
row[5] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView,ds_Duty.Tables[2].DefaultView,ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(),4);
ds_Report.Tables[0].Rows.Add(row);
}
myreport = new rpt_DutyReport();
myreport.SetDataSource(ds_Report);
cv_Duty.ReportSource = myreport;
cv_Duty.DataBind();
}
public int ReplayItem(BBSReplay replay)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, replay.ItemID),
data.MakeInParam("@content", SqlDbType.NText,5000, replay.Content),
data.MakeInParam("@replayer", SqlDbType.VarChar,300, replay.Replayer),
data.MakeInParam("@replay_ip", SqlDbType.VarChar,50, replay.ReplayId)
};
try
{
return (data.RunProc("sp_BBSReplay", prams));
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("回复出错！");
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
public int SendItem(BBSForumItem item)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@board_id", SqlDbType.Int, 4,item.BoardID),
data.MakeInParam("@title", SqlDbType.VarChar,300,item.Title),
data.MakeInParam("@content", SqlDbType.NText,5000,item.Content),
data.MakeInParam("@sender", SqlDbType.VarChar,100,item.Sender),
data.MakeInParam("@ip", SqlDbType.VarChar,50,item.IP ),
data.MakeInParam("@bulletin",SqlDbType.Bit,1,item.Bulletin),
data.MakeInParam("@sysbulletin",SqlDbType.Bit,1,item.SysBulletin),
data.MakeInParam("@desktop",SqlDbType.Bit,1,item.DeskTop)
};
try
{
return (data.RunProc("sp_BBSAddItem", prams));
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("发布出错！");
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
public void ReadBBSForumItemStruct(BBSForumItem item)
{
//参数: @item_id int : 帖子ID
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, item.ItemID),
};
try
{
data.RunProc("sp_ReadBBSForumItem", prams, out dataReader);
while (dataReader.Read())
{
item.BoardID = Int32.Parse(dataReader["board_id"].ToString());
item.Title = dataReader["title"].ToString();
item.Content = dataReader["content"].ToString();
item.Sender = dataReader["sender"].ToString();
item.SendTime = DateTime.Parse(dataReader["send_time"].ToString());
item.HitTimes = Int32.Parse(dataReader["hit_times"].ToString());
item.ReplayTimes = Int32.Parse(dataReader["replay_times"].ToString());
item.LastReplayer = dataReader["last_replayer"].ToString();
item.LastReplayTime = dataReader["last_replay_time"].ToString();
item.IP = dataReader["ip"].ToString();
item.Bulletin = Convert.ToBoolean(dataReader["bulletin"]);
item.SysBulletin = Convert.ToBoolean(dataReader["sysbulletin"]);
item.DeskTop = Convert.ToBoolean(dataReader["desktop"]);
}
}
catch (Exception ex)
{
Error.Log(ex.ToString());
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
if (dataReader != null)
{
dataReader.Close();
dataReader.Dispose();
}
}
}
public void MoveBoardItem(BBSForumItem olditem, BBSForumItem newitem)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4,olditem.ItemID),
data.MakeInParam("@to_board_id", SqlDbType.Int, 4,newitem.BoardID)
};
try
{
data.RunProc("sp_BBSMoveItem", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
public void ModBBSForumItem(BBSForumItem item)
{
//参数: @item_id int : 帖子ID
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, item.ItemID),
data.MakeInParam("@board_id", SqlDbType.Int, 4, item.BoardID),
data.MakeInParam("@title", SqlDbType.VarChar, 300, item.Title),
data.MakeInParam("@content", SqlDbType.NText, 5000, item.Content),
data.MakeInParam("@sender", SqlDbType.VarChar, 50, item.Sender),
data.MakeInParam("@send_time", SqlDbType.DateTime, 8, item.SendTime),
data.MakeInParam("@hit_times", SqlDbType.Int, 4, item.HitTimes),
data.MakeInParam("@replay_times", SqlDbType.Int, 4, item.ReplayTimes),
data.MakeInParam("@last_replayer", SqlDbType.VarChar, 50, item.LastReplayer),
data.MakeInParam("@last_replay_time", SqlDbType.DateTime, 8, item.LastReplayTime==""?Convert.DBNull:item.LastReplayTime),
data.MakeInParam("@ip", SqlDbType.VarChar, 50, item.IP),
data.MakeInParam("@bulletin", SqlDbType.Bit, 4, item.Bulletin),
data.MakeInParam("@sysbulletin", SqlDbType.Bit, 4, item.SysBulletin),
data.MakeInParam("@desktop", SqlDbType.Bit, 4, item.DeskTop),
};
try
{
data.RunProc("sp_BBS_UpdateItemInfo", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
private void btnsubmit_Click(object sender, System.EventArgs e)
{
string tmpstr = hcellstatus.Value;
string indaystr,outdaystr;
indaystr = outdaystr = "";
string[] arrdate = tmpstr.Split(',');
string[] tmp = new string[2];
Database db = new Database();
SqlParameter[] prams = new SqlParameter[2];
for(int i=0;i<arrdate.Length;i++)
{
if(arrdate[i].Trim()!="")
{
tmp = arrdate[i].Split(':');
if(Int32.Parse(tmp[1].ToString())%2==0) //ż���ϰ�����
indaystr = indaystr + tmp[0] + ",";
else
outdaystr = outdaystr + tmp[0] + ",";
}
}
outdaystr = (outdaystr.Length==0)?"":outdaystr.Substring(0,outdaystr.Length-1);
indaystr = (indaystr.Length==0)?"":indaystr.Substring(0,indaystr.Length-1);
try
{
if(indaystr!="")
{
prams[0] = db.MakeInParam("@datetimestr",SqlDbType.VarChar,8000,indaystr);
prams[1] = db.MakeInParam("@type",SqlDbType.Bit,1,1);
db.RunProc("sp_WA_ChangeDaySetting",prams);
}
if(outdaystr!="")
{
prams[0] = db.MakeInParam("@datetimestr",SqlDbType.VarChar,8000,outdaystr);
prams[1] = db.MakeInParam("@type",SqlDbType.Bit,1,0);
db.RunProc("sp_WA_ChangeDaySetting",prams);
}
daytable.Visible = false;
btnsubmit.Visible = false;
lblMessage.Visible = true;
db.Dispose();
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.Message);
Server.Transfer("../Error.aspx");
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// �ڴ˴������û������Գ�ʼ��ҳ��
string filter = "";
if (!Page.IsPostBack)
{
//try
staffid = (Request.QueryString["staffid"] == null) ? "0" : Request.QueryString["staffid"].ToString();
begintime = (Request.QueryString["begintime"] == null) ? DateTime.Now.ToString() : Request.QueryString["begintime"].ToString();
endtime = (Request.QueryString["endtime"] == null) ? DateTime.Now.ToString() : Request.QueryString["endtime"].ToString();
type = (Request.QueryString["type"] == null) ? DateTime.Now.ToString() : Request.QueryString["type"].ToString();
switch (type)
{
case "1": type = "�����ϰ�"; filter = "OnDuty_Status = false and OffDuty_Status = false"; break;
case "2": type = "�ٵ�"; filter = "OnDuty_Status = true"; break;
case "3": type = "����"; filter = "OffDuty_Status = true"; break;
case "4": type = "���"; break;
case "5": type = "�ܿ���"; break;
}
Database db = new Database();
SqlDataReader dr =null;
SqlDataReader dr1=null;
try
{
//�õ��û���
SqlParameter[] pram = {
db.MakeInParam("@ids",SqlDbType.VarChar,1000,staffid)
};
db.RunProc("sp_WA_GetSelectedStaffFromID", pram, out dr1);
while (dr1.Read())
{
ltlname.Text = dr1["staff_name"].ToString();
}
dr1.Close();
db.Dispose();
if (type == "���")
{
SqlParameter[] prams = {
db.MakeInParam("@staffid",SqlDbType.Int,4,staffid),
db.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
db.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
};
db.RunProc("sp_WA_GetAbsenceDay", prams, out dr);
DataTable table = Tools.ConvertDataReaderToDataTable(dr);//Ӧ�ó��ڵ�����
DataColumn myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "OnDuty";
table.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "OffDuty";
table.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "OnDuty_MemoID";
table.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "OffDuty_MemoID";
table.Columns.Add(myDataColumn);
table.DefaultView.Sort = "WorkDate ASC";
grdStaff.DataSource = table.DefaultView;
grdStaff.DataBind();
}
else
{
SqlParameter[] prams = {
db.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
db.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime),
db.MakeInParam("@ids",SqlDbType.VarChar,1000,staffid),
db.MakeInParam("@idtype",SqlDbType.VarChar,50,"staff")
};
db.RunProc("sp_WA_GetAttendanceData", prams, out dr);
DataTable table = Tools.ConvertDataReaderToDataTable(dr);
table.DefaultView.RowFilter = filter;
grdStaff.DataSource = table.DefaultView;
grdStaff.DataBind();
}
ltlbegintime.Text = begintime;
ltlendtime.Text = endtime;
lbltype.Text = type;
}
finally//�ر�db
{
if (db != null)
{
db.Close();
}
if (dr != null)
{
dr.Close();
}
if (dr1 != null)
{
dr1.Close();
}
}
//catch(Exception ex)
//{
// UDS.Components.Error.Log(ex.Message);
// Server.Transfer("../Error.aspx");
//}
}
}
//更新板块信息
public bool EditBBSBoard(BBSBoard BBSBoard)
{
//@board_id int, : 被更新的板块ID
//@board_name varchar(300) : 板块名称
//@board_description varchar(300), : 板块介绍
//@board_type bit : 板块类型(公共型，私有型)
// 给存储过程传递参数
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@board_id", SqlDbType.Int, 4, BBSBoard.BoardID),
data.MakeInParam("@board_name", SqlDbType.VarChar, 300, BBSBoard.BoardName),
data.MakeInParam("@board_description", SqlDbType.VarChar ,300, BBSBoard.BoardDescription),
data.MakeInParam("@board_type", SqlDbType.Bit, 1 ,BBSBoard.BoardType),
};
//try
{
try
{
data.RunProc("sp_BBS_UpdateBoardInfo", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
return true;
}
//catch (Exception ex)
{
// Error.Log(ex.ToString());
// throw new Exception("BBS板块编缉错误!",ex);
}
}
//更新分类栏信息
public bool EditBBSCatalog(BBSCatalog BBSCatalog)
{
// @catalog_id int, : 分栏ID
// @catalog_name varchar(300), : 分栏名称
// @catalog_description varchar(300) : 分栏介绍
// 给存储过程传递参数
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@catalog_id", SqlDbType.Int, 4, BBSCatalog.CatalogID),
data.MakeInParam("@catalog_name", SqlDbType.VarChar, 300, BBSCatalog.CatalogName),
data.MakeInParam("@catalog_description", SqlDbType.VarChar ,300, BBSCatalog.CatalogDescription),
};
try
{
data.RunProc("sp_BBS_UpdateCatalogInfo", prams);
return true;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("BBS类别编缉错误!", ex);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
public void DelReplay(BBSReplay replay)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@replayid", SqlDbType.Int, 4,replay.ReplayId),
data.MakeInParam("@itemid",SqlDbType.Int,4,replay.ItemID)
};
try
{
data.RunProc("sp_BBS_DeleteReplay", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
/// <summary>
/// ��ȡ�ӵ�����
/// </summary>
/// <param name="ClassID">�ӵ�ID</param>
/// <returns>���ؽӵ�����</returns>
public string GetClassName(int ClassID)
{
string ClassName = null;
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@ClassID", SqlDbType.Int, 8, ClassID)
};
try
{
data.RunProc("sp_GetClass", prams, out dataReader);
if (dataReader.Read())
{
ClassName = dataReader[1].ToString();
}
else
{
ClassName = "";
}
} finally//�ر�db
{
if (data != null)
{
data.Close();
data.Dispose();
}
if (dataReader != null)
{
dataReader.Close();
dataReader.Dispose();
}
}
return ClassName;
}
private void btnsearch_Click(object sender, System.EventArgs e)
{
SqlDataReader dr, dr1, dr2;
dr = null;
dr1 = null;
dr2 = null;
DataSet ds = new DataSet();
Database db = new Database();
try
{
btn_Report.Style["display"] = "";
SqlParameter[] prams = new SqlParameter[4];
string idtype = "";
string ids = "";
switch (ddlsearchbound.SelectedIndex)
{
case 0: idtype = "company"; break;
case 1: idtype = "Position"; break;
case 2: idtype = "staff"; break;
}
if (idtype == "staff")
{
foreach (ListItem staffitem in lbstaffs.Items)
{
if (staffitem.Selected)
{
ids = ids + staffitem.Value + ",";
}
}
if (ids != "") ids = ids.Substring(0, ids.Length - 1);
}
else if (idtype == "Position")
{
ids = ddldepartments.SelectedItem.Value;
}
else if (idtype == "company")
{
ids = "";
}
try
{
//�õ���������
this.txtbegintime.Text = Request.Form["txtbegintime"].ToString();
this.txtendtime.Text = Request.Form["txtendtime"].ToString();
prams[0] = db.MakeInParam("@begintime", SqlDbType.DateTime, 8, this.txtbegintime.Text);
prams[1] = db.MakeInParam("@endtime", SqlDbType.DateTime, 8, this.txtendtime.Text);
prams[2] = db.MakeInParam("@ids", SqlDbType.VarChar, 1000, ids);
prams[3] = db.MakeInParam("@idtype", SqlDbType.VarChar, 50, idtype);
db.RunProc("sp_WA_GetAttendanceData", prams, out dr);
DataTable datatable = Tools.ConvertDataReaderToDataTable(dr);
ds.Tables.Add(datatable);
dvw = ds.Tables[0].DefaultView;
db.Dispose();
dr.Close();
//�õ���Ա����
if (idtype == "staff")
{
SqlParameter[] prams1 = { db.MakeInParam("@ids", SqlDbType.VarChar, 1000, ids) };
db.RunProc("sp_WA_GetSelectedStaffFromID", prams1, out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
dvwAttGrid = ds.Tables[1].DefaultView;
db.Dispose();
dr1.Close();
}
else if (idtype == "Position")
{
SqlParameter[] prams1 = {
db.MakeInParam("@Position_id",SqlDbType.Int,4,Int32.Parse(ids)),
db.MakeInParam("@Dimission",SqlDbType.Bit,1,0)
};
db.RunProc("sp_GetStaffInPosition", prams1, out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
dvwAttGrid = ds.Tables[1].DefaultView;
db.Dispose();
dr1.Close();
}
else if (idtype == "company")
{
SqlParameter[] prams1 = {
db.MakeInParam("@StaffType",SqlDbType.Int,4,0)
};
db.RunProc("sp_GetAllStaff", prams1, out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
dvwAttGrid = ds.Tables[1].DefaultView;
db.Dispose();
dr1.Close();
}
SqlParameter[] prams2 = {
db.MakeInParam("@begintime",SqlDbType.DateTime,8,txtbegintime.Text),
db.MakeInParam("@endtime",SqlDbType.DateTime,8,txtendtime.Text)
};
db.RunProc("sp_WA_GetDutyDay", prams2, out dr2);
DataTable datatable2 = Tools.ConvertDataReaderToDataTable(dr2);
ds.Tables.Add(datatable2);
dvw1 = ds.Tables[2].DefaultView;
db.Dispose();
dr2.Close();
AttendanceGrid.DataSource = dvwAttGrid;
AttendanceGrid.DataBind();
//��������
Cache["WA_Duty"] = ds;
btn_Report.Attributes["onclick"] = "window.open('Report/DutyReport.aspx?idtype=" + idtype + "&ids=" + ids + "&begintime=" + txtbegintime.Text + "&endtime=" + txtendtime.Text + "')";
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.Message);
Server.Transfer("../Error.aspx");
}
}
finally
{
if (db != null)
{
db.Close();
}
if (dr != null)
{
dr.Close();
}
if (dr1 != null)
{
dr1.Close();
}
if (dr2 != null)
{
dr2.Close();
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
idtype = Request.QueryString["idtype"].ToString();
ids = Request.QueryString["ids"].ToString();
begintime = Request.QueryString["begintime"].ToString();
endtime = Request.QueryString["endtime"].ToString();
ViewState["idtype"] = idtype;
ViewState["ids"] = ids;
ViewState["begintime"] = begintime;
ViewState["endtime"] = endtime;
}
else
{
idtype = ViewState["idtype"].ToString();
ids = ViewState["ids"].ToString();
begintime = ViewState["begintime"].ToString();
endtime = ViewState["endtime"].ToString();
}
ds_Duty = (DataSet)Cache["WA_Duty"];
//从TotalDuty.xsd获得架构
ds_Report = new DataSet();
ds_Report.ReadXmlSchema(Request.MapPath(".") + "\\TotalDuty.xsd");
#region 缓存如果不存在
if (ds_Duty == null)
{
//重新获取ds_Duty
SqlDataReader dr, dr1, dr2;
SqlParameter[] prams = new SqlParameter[4];
UDS.Components.Database db = new UDS.Components.Database();
DataSet ds = new DataSet();
//得到考勤数据
prams[0] = db.MakeInParam("@begintime", SqlDbType.DateTime, 8, begintime);
prams[1] = db.MakeInParam("@endtime", SqlDbType.DateTime, 8, endtime);
prams[2] = db.MakeInParam("@ids", SqlDbType.VarChar, 1000, ids);
prams[3] = db.MakeInParam("@idtype", SqlDbType.VarChar, 50, idtype);
db.RunProc("sp_WA_GetAttendanceData", prams, out dr);
DataTable datatable = Tools.ConvertDataReaderToDataTable(dr);
ds.Tables.Add(datatable);
db.Dispose();
dr.Close();
//得到人员名单
if (idtype == "staff")
{
SqlParameter[] prams1 = { db.MakeInParam("@ids", SqlDbType.VarChar, 1000, ids) };
db.RunProc("sp_WA_GetSelectedStaffFromID", prams1, out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
db.Dispose();
dr1.Close();
}
else if (idtype == "Position")
{
SqlParameter[] prams1 =
{
db.MakeInParam("@Position_id", SqlDbType.Int, 4, Int32.Parse(ids)),
db.MakeInParam("@Dimission", SqlDbType.Bit, 1, 0)
};
db.RunProc("sp_GetStaffInPosition", prams1, out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
db.Dispose();
dr1.Close();
}
else if (idtype == "company")
{
SqlParameter[] prams1 =
{
db.MakeInParam("@StaffType", SqlDbType.Int, 4, 0)
};
db.RunProc("sp_GetAllStaff", prams1, out dr1);
DataTable datatable1 = Tools.ConvertDataReaderToDataTable(dr1);
ds.Tables.Add(datatable1);
db.Dispose();
dr1.Close();
}
SqlParameter[] prams2 =
{
db.MakeInParam("@begintime", SqlDbType.DateTime, 8, begintime),
db.MakeInParam("@endtime", SqlDbType.DateTime, 8, endtime)
};
db.RunProc("sp_WA_GetDutyDay", prams2, out dr2);
DataTable datatable2 = Tools.ConvertDataReaderToDataTable(dr2);
ds.Tables.Add(datatable2);
db.Dispose();
dr2.Close();
//缓存数据
Cache["WA_Duty"] = ds;
ds_Duty = (DataSet)Cache["WA_Duty"];
}
#endregion
//生成ds_Report以可以绑定到rpt
//ds_Duty.Tables[0] 考勤数据
//ds_Duty.Tables[1] 人员数据
//ds_Duty.Tables[2] 考勤日期数据
//遍历人员数据表以生成新的ds_Report
for (int i = 0; i < ds_Duty.Tables[1].Rows.Count; i++)
{
DataRow row = ds_Report.Tables[0].NewRow();
row[0] = ds_Duty.Tables[1].Rows[i]["RealName"];
row[1] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView, ds_Duty.Tables[2].DefaultView, ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(), 0);
row[2] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView, ds_Duty.Tables[2].DefaultView, ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(), 1);
row[3] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView, ds_Duty.Tables[2].DefaultView, ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(), 2);
row[4] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView, ds_Duty.Tables[2].DefaultView, ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(), 3);
row[5] = GetDutyDateCount(ds_Duty.Tables[0].DefaultView, ds_Duty.Tables[2].DefaultView, ds_Duty.Tables[1].Rows[i]["Staff_ID"].ToString(), 4);
ds_Report.Tables[0].Rows.Add(row);
}
myreport = new rpt_DutyReport();
myreport.SetDataSource(ds_Report);
cv_Duty.ReportSource = myreport;
cv_Duty.DataBind();
}
/// <summary>
/// �ļ��������
/// </summary>
/// <param name="DocBody"> �ļ�������</param>
public string AddDocBody(DocBody docbody)
{
// create data object and params
Database data = new Database();
string DocID = "";
SqlParameter[] prams = {
data.MakeInParam("@ClassID", SqlDbType.Int, 20, docbody.DocClassID),
data.MakeInParam("@DocTitle", SqlDbType.NVarChar, 300, docbody.DocTitle),
data.MakeInParam("@DocContent",SqlDbType.NText, 8000,docbody.DocContent),
data.MakeInParam("@DocApprover", SqlDbType.NVarChar,200, docbody.DocApprover),
data.MakeInParam("@DocApproveDate", SqlDbType.NVarChar, 20, docbody.DocApproveDate),
data.MakeInParam("@DocApproved", SqlDbType.Int, 1, docbody.DocApproved),
data.MakeInParam("@DocType", SqlDbType.Int, 2, docbody.DocType),
data.MakeInParam("@DocAttribute", SqlDbType.Int , 2, docbody.DocAttribute),
data.MakeInParam("@DocAddedBy", SqlDbType.NVarChar, 300, docbody.DocAddedBy),
data.MakeInParam("@DocAddedDate", SqlDbType.DateTime, 300,DateTime.Parse(docbody.DocAddedDate)),
data.MakeOutParam("@CurrentDocID", SqlDbType.Int, 2)
};
try
{
data.RunProc("SP_Ext_AddDocument", prams);
DocID = prams[10].Value.ToString();
if (DocID == string.Empty )
return null;
else
return DocID;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("�ĵ��������Ӵ���!",ex);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
/// <summary>
/// ɾ��ij����
/// </summary>
public void DeleteTask(int TaskID)
{
// �������ݿ�����༰DataReader
Database data = new Database();
// ִ�д洢���̣�������SqlDataReader����
SqlParameter[] prams = {
data.MakeInParam("@TaskID", SqlDbType.Int,8, TaskID)
};
try
{
data.RunProc("sp_DeleteTask",prams);
data.Dispose();
}
catch(Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("ɾ��ij����!",ex);
}
finally
{
if (data != null)
{
data.Close();
}
}
}
/// <summary>
///��ȡij��Ŀ�е��ĵ� ����DataTable
/// </summary>
/// <param name="ClassID">��ĿID</param>
public DataTable GetClassDocs(int ClassID)
{
SqlDataReader dataReader = null;
Database data = new Database();
DataTable datatable = new DataTable();
SqlParameter[] prams =
{
data.MakeInParam("@ClassID", SqlDbType.Int, 20 ,ClassID)
};
try
{
data.RunProc("sp_GetNewDocument", prams, out dataReader);
datatable = Tools.ConvertDataReaderToDataTable(dataReader);
dataReader.Close();
return datatable;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
if (dataReader != null)
{
dataReader.Close();
}
}
}
public int InsertFile(string name, string extension)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@name",SqlDbType.VarChar,200,name),
data.MakeInParam("@extension",SqlDbType.VarChar,100,extension)
};
try
{
return (data.RunProc("sp_BBS_AddFile", prams));
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
