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