public void ResourceData(int i)
{
string head = System.Configuration.ConfigurationManager.AppSettings["MetadataService"];
string tail = System.Configuration.ConfigurationManager.AppSettings["mField"];
string urlRSORT = String.Format(head + tail, "RSORT"); //14资源类型
string jsonRSORT = Common.HttpGet(urlRSORT); //y({....})
string jsonRSORT2 = jsonRSORT.Substring(2, jsonRSORT.Length - 3); //{}
string tep = jsonRSORT2.Substring(7, jsonRSORT2.Length - 8);
m.Title = worksheet[i, 2].ToString();
m.StandardBook = DealData.RetSubstringUnderline(worksheet[i, 5].ToString());
#region 版本 册别 学科 年级
//foreach (KeyValuePair<string, string> kvp in Testdic)
//{
// if (kvp.Key == m.StandardBook.ToString())
// {
// testValue = kvp.Value;
// }
//}
//if (testValue != "")
//{
// string[] sArray = testValue.Split(',');
// if (sArray == null || sArray.Length == 0)
// {
// m.SchoolStage = null;
// m.Subject = null;
// m.Grade = null;
// m.BookReel = null;
// m.Edition = null;
// }
// else
// {
// m.SchoolStage = int.Parse(sArray[0]);
// m.Subject = int.Parse(sArray[1]);
// m.Grade = int.Parse(sArray[2]);
// m.BookReel = int.Parse(sArray[3]);
// m.Edition = int.Parse(sArray[4]);
// }
//}
//else
//{
// m.SchoolStage = null;
// m.Subject = null;
// m.Grade = null;
// m.BookReel = null;
// m.Edition = null;
//}
#endregion
m.Catalog = DealData.RetSubstringBracket(worksheet[i, 6].ToString());
//m.Copyright = Mirror[worksheet[i, 23].ToString()];
//string CopyrightName = banquanxinxi[m.Copyright].Split('_')[0];
//资源类型
int eId = DealData.RetSubstringBracket(worksheet[i, 4].ToString());
string ResourceType = string.Empty;
string ResourceStyle = string.Empty;
GetResType(tep, eId.ToString(), out ResourceType, out ResourceStyle);
if (ResourceType != string.Empty)
{
ResourceType = int.Parse(ResourceType).ToString();
}
if (ResourceStyle != string.Empty)
{
ResourceStyle = int.Parse(ResourceStyle).ToString();
}
m.KeyWords = worksheet[i, 7].ToString().Replace("\'", "\'\'");
m.Description = worksheet[i, 8].ToString().Replace("\'", "\'\'");
updateStr = "update dbo.[tb_Resource] set Title = '" + m.Title + "',Catalog ='" + m.Catalog + "', ResourceType ='" + ResourceType
+ "',ResourceStyle = '" + ResourceStyle + "',KeyWords ='" + m.KeyWords + "',Description = '" + m.Description + "' where " + "FileID ='" + worksheet[i, 13] + "'";
SqlConnection sqlconn = new SqlConnection(sqlstr);
sqlconn.Open();
SqlCommand cmd = new SqlCommand(updateStr, sqlconn);
int uptnum = cmd.ExecuteNonQuery();
if (false)
{
string url = System.Configuration.ConfigurationManager.AppSettings["ResourceImplement"] + "Handler.ashx";
string str = "'{'Form':'{\'RID\':\'BEC2C674-AADE-283D-A506-35BFE61B1387\',\'SKEY\':\'ResourceImplement\',\'Pack\':\'{\\\'ID\\\':\\\'BEC2C674-AADE-283D-A506-35BFE61B1387\\\',\\\'Function\\\':\\\'PushResource\\\',\\\'Data\\\':\\\'{}\\\'}\',\'Ticket\':\'\'}'}'";
var response = PostData.RequestData(url, str);
}
}
