protected void ShowImage(string item) { if (item.Length < 18) { return; } PublicAppDAL paADL = new PublicAppDAL(); clsPublic cpb = new clsPublic(); string imgAdd_s = "/cf_art/artwork/AAAA/A588001.bmp"; //源文件 string art_file = paADL.GetArtWorkImagePath(item); //獲取ArtWork源文件 imgAdd_s = DBUtility.image_map_path + art_file; //獲取源文件完整文件路徑 int str_start = art_file.IndexOf("/"); string imgAdd_d = "file/image/" + art_file.Substring(str_start + 1, art_file.Length - (str_start + 1)); //"xls/A588001.bmp"; FileInfo file_s = new FileInfo(Server.MapPath(imgAdd_s)); //指定源文件路径 FileInfo file_d = new FileInfo(Server.MapPath(imgAdd_d)); //指定目的文件路徑 if (file_s.Exists) //判断源文件是否存在 { //cls.clsPublic.WebMessageBox(this.Page, "找到源文件!"); if (!file_d.Exists)//判断目的文件是否存在 { cpb.FileCopy(file_s.ToString(), file_d.ToString()); } } else { //cls.clsPublic.WebMessageBox(this.Page, "沒找到ArtWork圖片!"); } imgZp.ImageUrl = imgAdd_d; }
private void UpdateData(HttpContext context, string edit_mode) { string para = context.Request["param"]; string result = ""; string uname = ""; JArray ja = (JArray)JsonConvert.DeserializeObject(para); uname = ja[0]["uname"].ToString(); string strSql = "", strSql_geo = ""; if (edit_mode == "2")//刪除 { strSql = " Delete From tb_sy_user Where uname='" + uname + "'"; } else { string uname_desc = "", pwd = "", language = "0", vend_id = "", u_type = "I"; string sales_group = "", user_group = "", state = "0"; int t_groupid = 0, rid = 0, t_typeid = 0, t_subclassid = 1; string geo_groupid = ""; string userid = bp.getUserName(); uname_desc = ja[0]["uname_desc"].ToString().Trim(); t_groupid = ja[0]["t_groupid"].ToString() != "" ? Convert.ToInt32(ja[0]["t_groupid"].ToString()) : 0; sales_group = ja[0]["sales_group"].ToString().Trim(); user_group = ja[0]["user_group"].ToString().Trim(); language = ja[0]["language"].ToString().Trim() != "" ? ja[0]["language"].ToString().Trim() : "0"; u_type = ja[0]["u_type"].ToString().Trim() != "" ? ja[0]["u_type"].ToString().Trim() : "I"; state = ja[0]["state"].ToString().Trim() != "" ? ja[0]["state"].ToString().Trim() : "0"; vend_id = ja[0]["vend_id"].ToString().Trim(); rid = ja[0]["rid"].ToString() != "" ? Convert.ToInt32(ja[0]["rid"].ToString()) : 0; geo_groupid = ja[0]["geo_groupid"].ToString().Trim() != "" ? ja[0]["geo_groupid"].ToString().Trim() : "0"; strSql = "Select uname From tb_sy_user Where uname='" + uname + "'"; DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); if (dt.Rows.Count == 0) { strSql = "Insert Into tb_sy_user (uname,uname_desc,pwd,rid,language,vend_id,rid_oa,u_type,sales_group" + ",user_group,t_typeid,t_subclassid,t_groupid,state)" + " Values ('" + uname + "','" + uname_desc + "','" + pwd + "','" + rid + "','" + language + "','" + vend_id + "','" + t_groupid + "','" + u_type + "','" + sales_group + "','" + user_group + "','" + t_typeid + "','" + t_subclassid + "','" + t_groupid + "','" + state + "')"; } else { strSql = "Update tb_sy_user Set uname_desc='" + uname_desc + "',rid='" + rid + "',language='" + language + "',u_type='" + u_type + "',sales_group='" + sales_group + "',user_group='" + user_group + "',t_typeid='" + t_typeid + "',t_subclassid='" + t_subclassid + "',t_groupid='" + t_groupid + "',state='" + state + "'" + " Where uname='" + uname + "'"; } //更新Geo中的用戶表 strSql_geo = "Select user_id From " + remote_db + "sys_user Where user_id='" + uname + "'"; dt = SQLHelper.ExecuteSqlReturnDataTable(strSql_geo); if (dt.Rows.Count == 0) { PublicAppDAL pba = new PublicAppDAL(); pwd = pba.GeoEncrypt(ja[0]["pwd"].ToString().Trim()); strSql_geo = "Insert Into " + remote_db + "sys_user" + " (within_code,user_id,user_name,password,group_id,ava_date,status,typeid,masterdepid,usr_type,inherit_type,createby,createdate)" + " Values ('" + "" + "','" + uname + "','" + uname_desc + "','" + pwd + "','" + geo_groupid + "','" + System.DateTime.Now.ToString("yyyy/MM/dd") + "','" + "0" + "','" + "U" + "','" + "Y" + "','" + "G" + "','" + "Y" + "','" + userid + "','" + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "')"; } else//如果存在,就不更新Geo中的用戶了 { strSql_geo = ""; } // strSql_geo = "Update " + remote_db + "sys_user Set " // + "user_name='" + uname_desc + "',group_id='" + geo_groupid + "',modifyby='" + userid + "',modifydate='" + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") // + "'"; } result = sh.ExecuteSqlUpdate(strSql); if (result == "" && strSql_geo != "")//更新Geo中的用戶表 { result = sh.ExecuteSqlUpdate(strSql_geo); } if (result == "") { result = "OK"; } context.Response.ContentType = "text/plain"; context.Response.Write(result); context.Response.End(); }