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); }