public string ChangeColor(object ii)
{
string str1;
if (FieldToValue.FieldToInt(ii) <= 0)
{
str1 = "<font color=red>" + FieldToValue.FieldToInt(ii).ToString() + "<font>";
}
else
{
str1 = FieldToValue.FieldToInt(ii).ToString();
}
return(str1);
}
private void inTable()
{
DataTable dt1 = new DataTable();
cbbTable.Items.Clear();
dt1 = DBOpt.dbHelper.GetDataTable("select NAME from DMIS_SYS_TABLES order by ORDER_ID");
if (dt1.Rows.Count > 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
cbbTable.Items.Add(FieldToValue.FieldToString(dt1.Rows[i][0]));
}
}
}
public string GetIcon(int iDocTypeNo, string sIcon)
{
if (sIcon != "")
{
return("../img/" + sIcon);
}
sIcon = FieldToValue.FieldToString(DBOpt.dbHelper.ExecuteScalar("select f_iconfile from dmis_sys_doctype where f_no=" + iDocTypeNo));
if ((sIcon == ""))
{
return("../img/wendang4.gif");
}
if ((sIcon.IndexOf("/") < 0))
{
return("../img/" + sIcon);
}
return(sIcon);
}
/// <summary>
/// 填充控件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmFlowRight_Load(object sender, EventArgs e)
{
cbbRole.Items.Clear();
lsvRight.Items.Clear();
strSql = "select ID,NAME from DMIS_SYS_ROLE order by ID";
DataTable dt1, dt2;
ListViewItem lv;
dt1 = DBOpt.dbHelper.GetDataTable(strSql);
cbbRole.DataSource = dt1;
cbbRole.DisplayMember = "NAME";
cbbRole.ValueMember = "ID";
cbbRole.Refresh();
if (frmFlow.iDocNo > 0)
{
//提取权限文档
strSql = "SELECT A.NAME,B.F_ACCESS FROM DMIS_SYS_ROLE A,DMIS_SYS_RIGHTS B"
+ " WHERE A.ID=B.F_ROLENO AND B.F_CATGORY='文档' AND F_FOREIGNKEY=" + frmFlow.iDocNo;
pan_pack.Visible = false;
}
else
{
//提取权限业务
strSql = "SELECT A.NAME,B.F_ACCESS FROM DMIS_SYS_ROLE A,DMIS_SYS_RIGHTS B"
+ " WHERE A.ID=B.F_ROLENO AND B.F_CATGORY='业务' AND F_FOREIGNKEY=" + frmFlow.iPackNo;
}
dt2 = DBOpt.dbHelper.GetDataTable(strSql);
if (dt2.Rows.Count > 0)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
lv = new ListViewItem();
lv.Text = FieldToValue.FieldToString(dt2.Rows[j][0]);
ListViewItem.ListViewSubItem lsv = new ListViewItem.ListViewSubItem();
string sTmp1 = FieldToValue.FieldToString(dt2.Rows[j][1]);
lsv.Tag = sTmp1;
DbGetRight(ref sTmp1);
lsv.Text = sTmp1;
lv.SubItems.Add(lsv);
lsvRight.Items.Add(lv);
}
}
}
private void frmpacktype_Load(object sender, EventArgs e)
{
if (frmFlow.iPackNo > 0)
{
DataTable dt1;
dt1 = DBOpt.dbHelper.GetDataTable("SELECT * FROM DMIS_SYS_PACKTYPE WHERE F_NO=" + frmFlow.iPackNo);
if (dt1.Rows.Count > 0)
{
tbName.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_NAME"]);
cbflow.Checked = FieldToValue.FieldToCheckBox(dt1.Rows[0]["F_ISFLOW"]);
cbcheck.Checked = FieldToValue.FieldToCheckBox(dt1.Rows[0]["F_ISCHECK"]);
cbarchive.Checked = FieldToValue.FieldToCheckBox(dt1.Rows[0]["F_ISARCHIEVE"]);
txtOTHER_LANGUAGE_DESCR.Text = FieldToValue.FieldToString(dt1.Rows[0]["OTHER_LANGUAGE_DESCR"]);
}
}
if (cbflow.Checked == false)
{
cbcheck.Visible = false;
cbarchive.Visible = false;
}
}
private void frmdoctype_Load(object sender, EventArgs e)
{
inTable();
//***** Modify Start v2.00 liujp 2010/01/14 报表文本框改为下拉框 *****
//取得报表信息SQL文
StringBuilder sbReportSql = new StringBuilder();
sbReportSql.Append("SELECT ID ID, ");
//报表名称(中文、西班牙文)
if (System.Threading.Thread.CurrentThread.CurrentCulture.Name == "zh-CN")
{
sbReportSql.Append(" NAME NAME ");
}
else
{
sbReportSql.Append(" OTHER_LANGUAGE_DESCR NAME ");
}
sbReportSql.Append(" FROM DMIS_SYS_REPORT ");
sbReportSql.Append(" ORDER BY TYPE_ID, ");
sbReportSql.Append(" ORDER_ID ");
//报表下拉框初始化
DataTable dtReport = new DataTable();
dtReport = DBOpt.dbHelper.GetDataTable(sbReportSql.ToString());
cbbReport.DataSource = dtReport;
cbbReport.DisplayMember = "NAME";
cbbReport.ValueMember = "ID";
cbbReport.SelectedIndex = -1;
//***** Modify End *****
if (frmFlow.iDocNo > 0)
{
DataTable dt1;
dt1 = DBOpt.dbHelper.GetDataTable("SELECT * FROM DMIS_SYS_DOCTYPE WHERE F_NO=" + frmFlow.iDocNo);
if (dt1.Rows.Count > 0)
{
txtName.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_NAME"]);
cbbType.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_DOCCAT"]);
txtForm.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_FORMFILE"]);
txtIcon.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_ICONFILE"]);
txtOpenIcon.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_OPENICON"]);
cbbTable.Text = FieldToValue.FieldToString(dt1.Rows[0]["F_TABLENAME"]);
txtOTHER_LANGUAGE_DESCR.Text = FieldToValue.FieldToString(dt1.Rows[0]["OTHER_LANGUAGE_DESCR"]);
//***** Modify Start v2.00 liujp 2010/01/14 报表文本框改为下拉框 *****
//报表下拉框默认初始值
if (!(dt1.Rows[0]["F_REPORTFILE"] != Convert.DBNull || dt1.Rows[0]["F_REPORTFILE"].ToString().Equals("")))
{
int index;
if (int.TryParse(dt1.Rows[0]["F_REPORTFILE"].ToString(), out index))
{
cbbReport.SelectedValue = index;
}
}
//***** Modify End *****
}
}
TypeChange();
}
public void openPage(System.Web.UI.Page pg, string sFileName, int iEdit)
{
DataTable oleRd;
string sFile;
if (sFileName != "")
{
Session["FormFile"] = sFileName;
}
else
{
if (!(Session["DocNo"] == null))
{
if (FieldToValue.FieldToInt(Session["DocNo"]) > -1)
{
sSql = "SELECT F_DOCTYPENO,F_RECNO,F_TABLENAME FROM DMIS_SYS_DOC WHERE F_NO=" + Session["DocNo"];
oleRd = DBOpt.dbHelper.GetDataTable(sSql);
if (oleRd.Rows.Count > 0)
{
Session["DocTypeNo"] = oleRd.Rows[0][0].ToString();
Session["RecNo"] = oleRd.Rows[0][1].ToString();
Session["TableName"] = oleRd.Rows[0][2].ToString();
}
}
}
if (FieldToValue.FieldToInt(Session["DocTypeNo"]) == -2)
{
sFile = DBOpt.dbHelper.ExecuteScalar("SELECT F_FILENAME FROM DMIS_SYS_FILE WHERE F_NO=" + Session["RecNo"]).ToString();
if (sFile != "")
{
sFile = sFile.Replace("\\", "/");
sFile = sFile.Substring(sFile.LastIndexOf("/") + 1);
}
Session["FormFile"] = Server.MapPath("..\\upload\\") + sFile;
}
else
{
sSql = "SELECT F_FORMFILE FROM DMIS_SYS_DOCTYPE WHERE F_NO=" + Session["DocTypeNo"];
Session["FormFile"] = FieldToValue.FieldToString(DBOpt.dbHelper.ExecuteScalar(sSql)) + "?TID=" + Session["RecNo"];
Session["oper"] = -1;
if (iEdit > 0)
{
string sRight = WebWorkFlow.sDocTypeRight(Convert.ToInt32(Session["DocTypeNo"]), Session["RoleIDs"].ToString());
if (sRight.Length == 7)
{
if (sRight.Substring(2, 1) == "1" | sRight.Substring(3, 1) == "1")
{
Session["oper"] = 1;
}
}
}
}
}
if (Session["FormFile"].ToString() != "")
{
oleRd = DBOpt.dbHelper.GetDataTable("select F_STYLE,F_TARGET from DMIS_SYS_filestyle where F_FILENAME='" + Session["FormFile"] + "'");
string sTyle = "";
string starget = "";
if (oleRd.Rows.Count > 0)
{
sTyle = FieldToValue.FieldToString(oleRd.Rows[0][0].ToString());
starget = FieldToValue.FieldToString(oleRd.Rows[0][1].ToString());
}
if (starget == "")
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script language=javascript>\r\n");
if (sTyle == "")
{
sb.Append("window.open('" + Session["FormFile"] + "');\r\n");
}
else
{
sb.Append("window.open('" + Session["FormFile"] + "','','" + sTyle + "');\r\n");
}
sb.Append("</script>");
pg.Response.Write(sb.ToString());
}
else
{
pg.Response.Redirect(Session["FormFile"].ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["PackTypeNo"] == null)
{
return;
}
if (Request["PackNo"] == null)
{
return;
}
strSql = "SELECT * FROM DMIS_SYS_FLOWLINK WHERE F_PACKTYPENO=" + Request["PackTypeNo"] + " ORDER BY F_FLOWCAT";
DataTable dtFlow = DBOpt.dbHelper.GetDataTable(strSql);
strSql = "SELECT F_STARTNO,F_ENDNO FROM DMIS_SYS_FLOWLINE WHERE F_PACKTYPENO=" + Request["PackTypeNo"]
+ " ORDER BY F_STARTNO,F_ENDNO";
DataTable dtLine = DBOpt.dbHelper.GetDataTable(strSql);
DataTable dtWork, dtZhuBan;
DataRow[] rws;
int iLeft = 0, iTop = 0;
string sTmp = "", recNos, sStatus, sPreNode;
int iMinx, iMiny, iMaxx, iMaxy;
float iScale;
float iScale1;
iMinx = FieldToValue.FieldToInt(DBOpt.dbHelper.ExecuteScalar("select min(F_LEFT) from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + Request["PackTypeNo"]));
iMiny = FieldToValue.FieldToInt(DBOpt.dbHelper.ExecuteScalar("select min(F_TOP) from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + Request["PackTypeNo"]));
iMaxx = FieldToValue.FieldToInt(DBOpt.dbHelper.ExecuteScalar("select max(F_LEFT) from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + Request["PackTypeNo"]));
iMaxy = FieldToValue.FieldToInt(DBOpt.dbHelper.ExecuteScalar("select max(F_TOP) from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + Request["PackTypeNo"]));
iScale = 1;
iScale1 = 1;
if (((iMaxx - iMinx) > 700))
{
iScale = 700 / (iMaxx - iMinx);
}
if (((iMaxy - iMiny) > 600))
{
iScale1 = 600 / (iMaxx - iMinx);
}
for (int i = 0; i <= dtFlow.Rows.Count - 1; i++)
{
iLeft = FieldToValue.FieldToInt(dtFlow.Rows[i]["F_LEFT"]); //Convert.ToInt32(Convert.ToInt32(FieldToValue.FieldToInt(dtFlow.Rows[i]["F_LEFT"]) - iMinx) * iScale);
iTop = FieldToValue.FieldToInt(dtFlow.Rows[i]["F_TOP"]); // Convert.ToInt32(Convert.ToInt32(FieldToValue.FieldToInt(dtFlow.Rows[i]["F_TOP"]) - iMiny) * iScale1);
recNos = "";
sStatus = FieldToValue.FieldToString(DBOpt.dbHelper.ExecuteScalar("SELECT DISTINCT F_STATUS FROM DMIS_SYS_WORKFLOW WHERE F_FLOWNO=" + dtFlow.Rows[i]["F_NO"] + " AND F_PACKNO=" + Request["PackNo"]));
strSql = "SELECT F_RECEIVER FROM DMIS_SYS_WORKFLOW " + " WHERE F_FLOWNO=" + dtFlow.Rows[i]["F_NO"] + " AND F_PACKNO=" + Request["PackNo"];
dtZhuBan = DBOpt.dbHelper.GetDataTable(strSql);
if (dtZhuBan.Rows.Count > 0)
{
recNos = dtZhuBan.Rows[0][0].ToString() + ",";
}
strSql = "SELECT A.F_RECEIVER FROM DMIS_SYS_MEMBERSTATUS A,DMIS_SYS_WORKFLOW B " + " WHERE A.F_WORKFLOWNO=B.F_NO AND B.F_FLOWNO=" + dtFlow.Rows[i]["F_NO"] + " AND B.F_PACKNO=" + Request["PackNo"];
dtWork = DBOpt.dbHelper.GetDataTable(strSql);
if (dtWork.Rows.Count > 0)
{
for (int j = 0; j <= dtWork.Rows.Count - 1; j++)
{
recNos += FieldToValue.FieldToString(dtWork.Rows[j][0]) + ",";
}
}
if ((recNos.Length > 0))
{
recNos = recNos.Substring(0, recNos.Length - 1);
}
rws = dtLine.Select("F_ENDNO=" + dtFlow.Rows[i]["F_NO"]);
sPreNode = "";
if ((rws.Length > 0))
{
for (int j = 0; j <= rws.Length - 1; j++)
{
sPreNode += FieldToValue.FieldToString(rws[j]["F_STARTNO"]) + "_";
}
sPreNode = sPreNode.Substring(0, sPreNode.Length - 1);
}
else
{
sPreNode = "-1";
}
if (Session["Culture"] == null || Session["Culture"].ToString() == "zh-CN")
{
sTmp += dtFlow.Rows[i]["F_NO"].ToString() + ":" + FieldToValue.FieldToString(dtFlow.Rows[i]["F_NAME"]) + ":" + iLeft + ":" + iTop + ":" + recNos + ":" + sStatus + ":" + sPreNode + "|";
}
else
{
sTmp += dtFlow.Rows[i]["F_NO"].ToString() + ":" + FieldToValue.FieldToString(dtFlow.Rows[i]["OTHER_LANGUAGE_DESCR"]) + ":" + iLeft + ":" + iTop + ":" + recNos + ":" + sStatus + ":" + sPreNode + "|";
}
}
if ((sTmp.Length > 0))
{
if ((sTmp.Substring(sTmp.Length - 1, 1) == "|"))
{
sTmp = sTmp.Substring(0, sTmp.Length - 1);
NodeData.Value = sTmp;
}
}
}
