public int dtz_number()
{
int num = 0;
string sql = "";
sql += "select * from T_PLANRUN_DTZ where 1=1 and BUFFER=0";
if (userlevel == "2" && Organization == "规划室")
{
sql = sql + "and (PLANFLAG=0 or PLANFLAG=1)";
}
if (userlevel == "2" && Organization == "矿区室")
{
sql = sql + "and (PLANFLAG=2 OR PLANFLAG_DESIGN=1)";
}
if (userlevel == "2" && Organization == "设计室")
{
sql = sql + "and PLANFLAG_DESIGN=0";
}
if (userlevel == "4")
{
sql = sql + "and (CHECKSTATE=1 OR CHECKSTATE is null)";
}
DB db = new DB();
DataTable dt = db.GetDataTable(sql);
//增加列
dt.Columns.Add("workitem");
dt.Columns.Add("workurl");
CTaskList tl = new CTaskList();
tl.userName = userName;
tl.userlevel = userlevel;
tl.Organization = Organization;
for (int i = 0; i < dt.Rows.Count; i++)
{
tl = tl.getSingleTask(dt.Rows[i]);
dt.Rows[i]["workitem"] = tl.workItem;
dt.Rows[i]["workurl"] = tl.workUrl;
if (dt.Rows[i]["workitem"].ToString() != "结束" && dt.Rows[i]["workitem"].ToString() != "等待中" && dt.Rows[i]["workitem"].ToString() != "退回方案")
{
num++;
}
}
return(num);
}
// public bool Export(string sTaskFilePath, string sDestFilePath, bool bSilent, Dictionary<string, string> prefs)
public bool Export(CTaskList srcTasks, string sDestFilePath, bool bSilent, CPreferences prefs, string sKey)
{
int nVal = prefs.GetProfileInt("bob", "dave", 20);
int nVal2 = prefs.GetProfileInt("bob", "phil", 20);
// add some dummy values to prefs
prefs.WriteProfileInt("bob", "dave", 10);
IntPtr hTask = srcTasks.GetFirstTask(IntPtr.Zero);
String sTitle = srcTasks.GetTaskTitle(hTask);
// Array categories = new Array;
// UInt32 numCat = srcTasks.GetTaskCategories(hTask, categories);
//MessageBox.Show("ExporterCore");
return true;
}
public int zcq_number()
{
int num = 0;
string sql = "";
if (userlevel == "2")
{
sql += "select * from T_PLANRUN_ZCQ where 1=1 and BUFFER=0";
}
else
{
sql += "select * from T_PLANRUN_ZCQ where SOLUCHIEF='" + userName + "' and BUFFER=0";
}
//if (Organization == "矿区室")
// sql += " and FLAGS=2";
//else if (Organization == "规划室")
// sql += " and FLAGS=1";
//else
// sql += " and FLAGS=0";
DB db = new DB();
DataTable dt = db.GetDataTable(sql);
//增加列
dt.Columns.Add("workitem");
dt.Columns.Add("workurl");
CTaskList tl = new CTaskList();
tl.userName = userName;
tl.userlevel = userlevel;
tl.Organization = Organization;
for (int i = 0; i < dt.Rows.Count; i++)
{
tl = tl.getSingleTask_longplan(dt.Rows[i]);
dt.Rows[i]["workitem"] = tl.workItem;
dt.Rows[i]["workurl"] = tl.workUrl;
if (dt.Rows[i]["workitem"].ToString() != "结束" && dt.Rows[i]["workitem"].ToString() != "等待中")
{
num++;
}
}
return(num);
}
public int bdtz_number()
{
int num = 0;
string sql = "";
if ((userlevel == "2" || userlevel == "8") && (Organization == "设计室" || Organization == "规划室" || Organization == "综合室"))
{
sql += "select * from T_PLANRUN_BDTZ where BUFFER=0";
}
else
{
sql += "select * from T_PLANRUN_BDTZ where 1=0";
}
DB db = new DB();
DataTable dt = db.GetDataTable(sql);
//增加列
dt.Columns.Add("workitem");
dt.Columns.Add("workurl");
CTaskList tl = new CTaskList();
tl.userName = userName;
tl.userlevel = userlevel;
tl.Organization = Organization;
for (int i = 0; i < dt.Rows.Count; i++)
{
tl = tl.getSingleTask_bdtz(dt.Rows[i]);
dt.Rows[i]["workitem"] = tl.workItem;
dt.Rows[i]["workurl"] = tl.workUrl;
if (dt.Rows[i]["workitem"].ToString() != "结束" && dt.Rows[i]["workitem"].ToString() != "等待中")
{
num++;
}
}
return(num);
}
