public string GetAnnexDataMode(string ConsultID)
{
List <AnnexOneVo> _list = new List <AnnexOneVo>();
string sql = "select * from Annex where ConsultID='" + ConsultID + "'";
DataTable dt = op.ExecuteDataTable(sql, CommandType.Text, null);
for (int i = 0; i < dt.Rows.Count; i++)
{
AnnexOneVo _AnnexOneVo = new AnnexOneVo();
_AnnexOneVo.Path = dt.Rows[i]["SerPath"].ToString() + dt.Rows[i]["FilePath"].ToString();
// _AnnexOneVo.Path = AnnexPath + "\\" + ConsultID + "\\Annex\\" + dt.Rows[i]["AnnexName"].ToString();
_AnnexOneVo.AnnexName = dt.Rows[i]["AnnexName"].ToString();
_AnnexOneVo.ClientPath = dt.Rows[i]["Client_Annex_Path"].ToString();
_AnnexOneVo.AnnexType = dt.Rows[i]["AnnexType"].ToString();
string UncIp = dt.Rows[i]["UncIp"].ToString();
string UncUserName = dt.Rows[i]["UncUserName"].ToString();
string UncPassWord = dt.Rows[i]["UncPassWord"].ToString();
string UncToken = "";
if (UncIp != "" && UncUserName != "" && UncPassWord != "")
{
string Token = "{\"ip\":\"" + UncIp + "\",\"username\":\"" + UncUserName + "\",\"password\":\"" + UncPassWord + "\"}";
string val = ConfigurationManager.AppSettings["UncTokenKey"].ToString();
UncToken = Convert.ToBase64String(Des3.Des3EncodeECB(val, Token));
}
_AnnexOneVo.UncToken = UncToken;
string status = "0";
if (_AnnexOneVo.Path.IndexOf("\\") == 0)
{
IdentityScope iss = new IdentityScope(UncUserName, UncPassWord, UncIp);
}
if (_AnnexOneVo.Path.StartsWith("http://"))
{
_AnnexOneVo.Path = _AnnexOneVo.Path.Replace("\\", "/");
bool f = IsExist(_AnnexOneVo.Path);
if (f == true)
{
status = "1";
}
}
else
{
if (File.Exists(_AnnexOneVo.Path))
{
status = "1";
}
}
//if (File.Exists(_AnnexOneVo.Path))
//{
// status = "1";
//}
_AnnexOneVo.Status = status;
_list.Add(_AnnexOneVo);
}
return(JsonConvert.SerializeObject(_list));
}
public string GetSlideDataMode(string ConsultID)
{
List <SlidePathVo> _list = new List <SlidePathVo>();
string sql = "select * from Slide where ConsultID='" + ConsultID + "' order by UpTime,RanSe desc";
DataTable dt = op.ExecuteDataTable(sql, CommandType.Text, null);
for (int i = 0; i < dt.Rows.Count; i++)
{
FileInfo fileInfo = new FileInfo(dt.Rows[i]["Client_Slide_Path"].ToString());
SlidePathVo _SlidePathVo = new SlidePathVo();
_SlidePathVo.Path = dt.Rows[i]["SerPath"].ToString() + dt.Rows[i]["FilePath"].ToString();
_SlidePathVo.SlideName = dt.Rows[i]["SlideName"].ToString();
string ReName = dt.Rows[i]["ReName"].ToString();
if (ReName.Trim() == "")
{
ReName = dt.Rows[i]["SlideName"].ToString();
}
if (!System.IO.File.Exists(_SlidePathVo.Path))
{
if (fileInfo.Extension != ".kfb")
{
_SlidePathVo.Path = dt.Rows[i]["SerPath"].ToString() + "\\" + ConsultID + "\\Annex\\" + dt.Rows[i]["SlideName"].ToString() + "\\1.mds";
}
}
_SlidePathVo.ReName = ReName;
_SlidePathVo.RanSe = dt.Rows[i]["RanSe"].ToString();
_SlidePathVo.CaseNo = dt.Rows[i]["CaseNo"].ToString();
_SlidePathVo.ClientPath = dt.Rows[i]["Client_Slide_Path"].ToString();
string UncIp = dt.Rows[i]["UncIp"].ToString();
string UncUserName = dt.Rows[i]["UncUserName"].ToString();
string UncPassWord = dt.Rows[i]["UncPassWord"].ToString();
string UncToken = "";
if (UncIp != "" && UncUserName != "" && UncPassWord != "")
{
string Token = "{\"ip\":\"" + UncIp + "\",\"username\":\"" + UncUserName + "\",\"password\":\"" + UncPassWord + "\"}";
string val = ConfigurationManager.AppSettings["UncTokenKey"].ToString();
UncToken = Convert.ToBase64String(Des3.Des3EncodeECB(val, Token));
}
_SlidePathVo.UncToken = UncToken;
string status = "0";
if (_SlidePathVo.Path.IndexOf("\\") == 0)
{
IdentityScope iss = new IdentityScope(UncUserName, UncPassWord, UncIp);
}
if (_SlidePathVo.Path.StartsWith("http://"))
{
_SlidePathVo.Path = _SlidePathVo.Path.Replace("\\", "/");
bool f = IsExist(_SlidePathVo.Path);
if (f == true)
{
status = "1";
}
}
else
{
if (File.Exists(_SlidePathVo.Path))
{
status = "1";
}
}
_SlidePathVo.Status = status;
_list.Add(_SlidePathVo);
}
return(JsonConvert.SerializeObject(_list));
}