public bool cUpdateUserData(string yhdm, string zw, string jtzz, string yzbm, string bgdh, string zzdh, string zdbs, string sj, string sjbs, string cz, string xb, string dzyx, string wlch, string bz)
{
string sqlString = "";
if (this.cGetLinkmanDetail(yhdm) != null)
{
string str4 = "update pt_txl_nbtxl set v_zw = '" + zw + "',v_jtzz = '" + jtzz + "',v_yzbm = '" + yzbm + "',v_bgdh = '" + bgdh + "',v_zzdh = '" + zzdh + "',c_zdbs = '" + zdbs + "',v_sj = '" + sj + "',";
sqlString = str4 + "c_sjbs = '" + sjbs + "',v_cz = '" + cz + "',c_xb = '" + xb + "',v_dzyx = '" + dzyx + "',v_wlch = '" + wlch + "',v_bz = '" + bz + "' where v_yhdm = '" + yhdm + "' and c_bs = 'y'";
}
else
{
int num = Convert.ToInt32(publicDbOpClass.QuaryMaxid("pt_txl_nbtxl", "i_id")) + 1;
DataTable table = new userManageDb().userQuaryDt(yhdm);
string word = table.Rows[0]["v_xm"].ToString();
int num2 = Convert.ToInt32(table.Rows[0]["i_bmdm"].ToString());
string str3 = new ChineseToSpell().WordToSpell(word);
object obj2 = sqlString + "insert into pt_txl_nbtxl (i_id,v_xm,i_bmdm,v_zw,v_jtzz,v_yzbm,v_bgdh,v_zzdh,c_zdbs,v_sj,c_sjbs,v_cz,c_xb,v_dzyx,v_wlch,v_bz,v_yhdm,c_bs,v_hypy) values ";
string str5 = string.Concat(new object[] {
obj2, " (", num, ",'", word, "',", num2, ",'", zw, "','", jtzz, "','", yzbm, "','", bgdh, "','",
zzdh, "','", zdbs, "','", sj, "','", sjbs, "','", cz, "','", xb, "',"
});
sqlString = str5 + "'" + dzyx + "','" + wlch + "','" + bz + "','" + yhdm + "','y','" + str3 + "')";
}
return(publicDbOpClass.NonQuerySqlString(sqlString));
}
public string strApplyManName(Guid ACRecordID, int MaterialID)
{
string str = "";
object obj2 = str + " select ApplyMan from OA_OfficeRes_PersonalApplication a " + " right join OA_OfficeRes_PersonalApplicationDetail b ";
DataTable table = publicDbOpClass.DataTableQuary(string.Concat(new object[] { obj2, " on a.PARecordID = b.PARecordID where ACRecordID = '", ACRecordID, "' " }) + " and MaterialID = " + MaterialID);
if (table.Rows.Count > 0)
{
userManageDb db = new userManageDb();
return(db.GetUserName(table.Rows[0]["ApplyMan"].ToString()));
}
return("");
}
public string strApplyDepartmentName(Guid ACRecordID, int MaterialID)
{
string str = "";
object obj2 = str + " select ApplyDepartment from OA_OfficeRes_DepartmentApplication a right join " + " OA_OfficeRes_DepartmentApplicationDetail b on a.DARecordID = b.DARecordID";
DataTable table = publicDbOpClass.DataTableQuary(string.Concat(new object[] { obj2, " where ACRecordID = '", ACRecordID, "' " }) + " and MaterialID = " + MaterialID);
if (table.Rows.Count > 0)
{
userManageDb db = new userManageDb();
return(db.depName(table.Rows[0]["ApplyDepartment"].ToString()));
}
return("");
}
public string RightMenu()
{
string str = "";
if (this._strUserCode == "")
{
return(str);
}
DataTable userDisplayMenu = new userManageDb().GetUserDisplayMenu(this._strUserCode);
str = str + "<SCRIPT language=\"javascript\" type=\"text/javascript\" src=\"/oa/common/DrawMouseMenu.js\"></SCRIPT>\n" + "<SCRIPT language=\"javascript\">DrawMouseMenu(";
for (int i = 0; i < userDisplayMenu.Rows.Count; i++)
{
string str2 = str;
str = str2 + "\"top.NavigationMenu.location.href='/SysFrame/NavigationMenu.aspx?id=" + userDisplayMenu.Rows[i][0].ToString() + "&url=/" + userDisplayMenu.Rows[i][2].ToString() + "';\\\">" + userDisplayMenu.Rows[i][1].ToString() + "\"";
if (i != (userDisplayMenu.Rows.Count - 1))
{
str = str + ",";
}
}
return(str + ");</SCRIPT>");
}
public string GetAduitUserName(int tempid, Guid InstanceCode)
{
object obj2 = ("" + " select * from WF_Instance n left join WF_Instance_Main m on n.ID =m.ID ") + " where TheOrder in ( " + " select isnull(Max(TheOrder),0) from WF_Instance a left join WF_Instance_Main b on a.ID =b.ID ";
object obj3 = string.Concat(new object[] { obj2, " where b.TemplateID = ", tempid, " " });
DataTable table = publicDbOpClass.DataTableQuary(string.Concat(new object[] { obj3, " ) and m.TemplateID = ", tempid, " and m.InstanceCode = '", InstanceCode, "'" }));
if (table.Rows.Count <= 0)
{
return("");
}
userManageDb db = new userManageDb();
string str2 = "";
for (int i = 0; i < table.Rows.Count; i++)
{
string userName = db.GetUserName(table.Rows[i]["Operator"].ToString());
if (userName != "")
{
str2 = str2 + userName + ",";
}
}
return(str2);
}