public void ToSqlServer()
{
//string strCon = @"Data Source=bds13396396.my3w.com;initial catalog=bds13396396_db;user id=bds13396396;password=icox2015;multipleactiveresultsets=True;";
//data source=bds13396396.my3w.com;initial catalog=bds13396396_db;user id=bds13396396;password=icox2015;multipleactiveresultsets=True;
try {
int yes = 0;
int no = 0;
int c1 = GridView2.Rows.Count;
//MessageBox.Show("表格行数=" + GridView2.Rows.Count, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
for (int i = 0; i < c1; i++)
{
if (GridView2.Rows[i].Cells[2].Text == "youku")
{
string temppath = GridView2.Rows[i].Cells[3].Text.ToString();
string sql = "insert into dbo.VideoUrl(Vid,Source,Path,sort,Describe) values(" + GridView2.Rows[i].Cells[0].Text + ",'"
+ GridView2.Rows[i].Cells[2].Text.ToString() + "','" + GridView2.Rows[i].Cells[3].Text.ToString() + "','"
+ GridView2.Rows[i].Cells[4].Text.ToString() + "','" + GridView2.Rows[i].Cells[5].Text.ToString() + "') ";
if (SqlFunction.Sql_ReturnNumberENQ(sql) > 0)
{
yes++;
}
else
{
no++;
}
}
else
{
string temppath = GridView2.Rows[i].Cells[3].Text.ToString();
temppath = AES.Encrypt(temppath);
string sql = "insert into dbo.VideoUrl(Vid,Source,TempPath,sort,Describe) values(" + GridView2.Rows[i].Cells[0].Text + ",'"
+ GridView2.Rows[i].Cells[2].Text.ToString() + "','" + temppath + "','"
+ GridView2.Rows[i].Cells[4].Text.ToString() + "','" + GridView2.Rows[i].Cells[5].Text.ToString() + "') ";
if (SqlFunction.Sql_ReturnNumberENQ(sql) > 0)
{
yes++;
}
else
{
no++;
}
}
}
string clientIP = HttpContext.Current.Request.UserHostAddress;
u = (user)Session["Adminu"];
Buckup.Buckup_Add("添加信道", u.name, clientIP, yes);
//MessageBox.Show("导入SqlServer成功！成功数:" + yes + "失败数：" + no, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Label2.Text = "导入成功:" + yes + "; 失败:" + no;
} catch (Exception ex) {
Label2.Text = ("导入过程中出错,请联系开发人员:" + ex.Message).Replace("'", "〞");
Layer(string.Format(@"layer.alert('{0}', {
icon: 5,title: false,shade:false,
shadeClose: true,skin: 'layer-ext-moon'
})", Label2.Text), Page);
} finally {
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (TreeView1.SelectedValue == "")
{
Layer(@"layer.alert('请选中左侧节点类型', {
icon: 0,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
else
{
if (title.Value != "" && img.Value != "" && sort.Value != "")
{
if (TreeView1.SelectedNode.ChildNodes.Count == 0) //判断选择节点下是否有类型,没有则将原来tid替换成新的tid
{
string sql = "insert into videotype (Tid,Title,Cover,Sort,State) Values(" + TreeView1.SelectedValue + ",'" + title.Value + "','" + img.Value + "'," + sort.Value + ",1 )";
if (SqlFunction.Sql_ReturnNumberENQ(sql) > 0)
{
string clientIP = HttpContext.Current.Request.UserHostAddress;
u = (user)Session["Adminu"];
Buckup.Buckup_Add("添加类型", u.name, clientIP, 1);
string rtid = "select id from videotype where title='" + title.Value + "'";
Text1.Value = SqlFunction.Sql_ReturnNumberES(rtid);
if (SqlFunction.Sql_ReturnNumberENQ("update video set tid=(" + rtid + ") where tid=" + TreeView1.SelectedValue) > 0)
{
bing();
Layer(@"layer.alert('类型添加成功,原类型转移成功', {
icon: 6,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
else
{
bing();
Layer(@"layer.alert('类型添加成功,但原类型转移失败,请通知开发者转移', {
icon: 0,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
}
else
{
Layer(@"layer.alert('添加失败', {
icon: 5,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
}
else
{
string sql = "insert into videotype (Tid,Title,Cover,Sort,State) Values(" + TreeView1.SelectedValue + ",'" + title.Value + "','" + img.Value + "'," + sort.Value + ",0 )";
if (SqlFunction.Sql_ReturnNumberENQ(sql) > 0)
{
string rtid = "select id from videotype where title='" + title.Value + "'";
Text1.Value = SqlFunction.Sql_ReturnNumberES(rtid); bing();
Layer(@"layer.alert('添加成功', {
icon: 6,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
else
{
bing();
Layer(@"layer.alert('添加失败', {
icon: 5,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
}
}
else
{
Layer(@"layer.alert('有数据未填写', {
icon: 0,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
}
}
}
/// <summary>
/// 开始更新数据库
/// </summary>
/// <returns></returns>
protected void startUpdate()
{
int count = GridView1.Rows.Count;
bool isok = false;
int sourcenum = 0;
int state0source = 0;
string [] state0index = new string[3];
int index = 0;
string error = "";
for (int j = 0; j < count; j++)
{
int xindaoNum = 0, xindaoIndex = 0;
string sort = "";
for (int i = 17; i > 0; i -= 7)
{
if (GridView1.Rows[j].Cells[i].Text == "" || GridView1.Rows[j].Cells[i].Text == " ")
{
}
else
{
xindaoNum++;
xindaoIndex = i;
switch (xindaoIndex)
{
case 3: sort = "999"; break;
case 10: sort = "99"; break;
case 17: sort = "9"; break;
}
}
}
DateTime dt = DateTime.Now;
string sql = "";
string cover = "", Describe = "";
cover = GridView1.Rows[j].Cells[1].Text.ToString();
Describe = GridView1.Rows[j].Cells[xindaoIndex + 2].Text.ToString();
if (cover == " ")
{
cover = "";
}
if (Describe == " ")
{
Describe = "";
}
//video表增加
sql = "insert into video (tid,title,cover,Describe,CreateDate,Sort,State,Definition,Advertisement)" +
"values(" + "'" + GridView1.Rows[j].Cells[2].Text.ToString() + "',"
+ "'" + GridView1.Rows[j].Cells[0].Text.ToString() + "',"
+ "'" + cover + "',"
+ "'" + Describe + "'," //描述默认为信道1的原标题
+ "'" + dt.ToString() + "',"
+ "'" + GridView1.Rows[j].Cells[xindaoIndex + 1].Text.ToString() + "'," //优先级默认为信道1的优先级
+ "'" + GridView1.Rows[j].Cells[xindaoIndex + 4].Text.ToString() + "'," //状态默认为信道1的状态
+ "''," //清晰度在video表中默认为空
+ "'')"; //是否存在广告在video表中默认为空
int Vnum = SqlFunction.Sql_UpdatePL(sql);
if (Vnum > 0)
{
//Alert("成功添加"+Vnum+"条数据",Page);
}
else
{
Layer(@"layer.alert('给Video表添加数据失败,已停止', {
icon: 5,title: false,
shadeClose: true,skin: 'layer-ext-moon'
})", Page);
return;
}
//获取VideoId添加信道
string sql_id = "select id from Video where title='" + GridView1.Rows[j].Cells[0].Text.ToString() + "'";
string vid = SqlFunction.Sql_ReturnNumberES(sql_id);
//videourl表增加
List <bool> bl = new List <bool>();
bl.Add(false);
bl.Add(false);
bl.Add(false);
if (GridView1.Rows[j].Cells[17].Text != "" && GridView1.Rows[j].Cells[17].Text != " ")
{
bl[2] = true;//有信道1
}
if (GridView1.Rows[j].Cells[10].Text != "" && GridView1.Rows[j].Cells[10].Text != " ")
{
bl[1] = true;//有信道2
}
if (GridView1.Rows[j].Cells[3].Text != "" && GridView1.Rows[j].Cells[3].Text != " ")
{
bl[0] = true;//有信道3
}
for (int i = 0; i < 3; i++)
{
if (bl[i])
{
int uindex = 0;
switch (i)
{
case 0: sort = "999"; uindex = 3; break;
case 1: sort = "99"; uindex = 10; break;
case 2: sort = "9"; uindex = 17; break;
}
string Definition = "", Advertisement = "";
Definition = GridView1.Rows[j].Cells[uindex + 5].Text.ToString();
Advertisement = GridView1.Rows[j].Cells[uindex + 6].Text.ToString();
if (Definition == " ")
{
Definition = "";
}
if (Advertisement == " ")
{
Advertisement = "";
}
DateTime dtU = DateTime.Now;
if (GridView1.Rows[j].Cells[uindex].Text.ToString() == "youku")
{
sql = "insert into videoUrl (Vid,Source,Path,State,Sort,CreateDate,Definition,Advertisement,Describe)values("
+ "'" + vid + "',"
+ "'" + GridView1.Rows[j].Cells[uindex].Text.ToString() + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 3].Text.ToString() + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 4].Text.ToString() + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 1].Text.ToString() + "',"
+ "'" + dtU.ToString() + "',"
+ "'" + Definition + "',"
+ "'" + Advertisement + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 2].Text.ToString() + "')";
}
else
{
string temppath = GridView1.Rows[i].Cells[uindex + 3].Text.ToString();
temppath = AES.Encrypt(temppath);
sql = "insert into videoUrl (Vid,Source,TempPath,State,Sort,CreateDate,Definition,Advertisement,Describe)values("
+ "'" + vid + "',"
+ "'" + GridView1.Rows[j].Cells[uindex].Text.ToString() + "',"
+ "'" + temppath + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 4].Text.ToString() + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 1].Text.ToString() + "',"
+ "'" + dtU.ToString() + "',"
+ "'" + Definition + "',"
+ "'" + Advertisement + "',"
+ "'" + GridView1.Rows[j].Cells[uindex + 2].Text.ToString() + "')";
}
int Unum = SqlFunction.Sql_UpdatePL(sql);
if (Unum > 0)
{
isok = true;
sourcenum++;
}
}
}
if (isok)
{
try {
if (SqlFunction.Sql_ReturnNumberENQ("update videoType set state=1 where id=" + GridView1.Rows[1].Cells[2].Text.ToString()) > 0)
{
//sourcenum++;
}
} catch (Exception e) {
state0source++;
error = e.Message;
state0index[index] = j.ToString(); index++;
}
}
else
{
Label1.Text = "添加中出现问题:Vnum=" + Vnum;
Layer(string.Format(@"layer.alert('{0}', {{
icon: 5,title: false,
shadeClose: true,skin: 'layer-ext-moon'
}})", Label1.Text), Page);
}
}
string clientIP = HttpContext.Current.Request.UserHostAddress;
u = (user)Session["Adminu"];
if (sourcenum > 0)
{
Buckup.Buckup_Add("添加视频", u.name, clientIP, count);
Label1.Text = "添加成功," + sourcenum + "条信道" + count + "行数据";
Layer(string.Format(@"layer.alert('{0}', {{
icon: 6,title: false,
shadeClose: true,skin: 'layer-ext-moon'
}})", Label1.Text), Page);
}
else
{
if (state0source == 0)
{
Layer(string.Format(@"layer.alert('{0}', {{
icon: 5,title: false,
shadeClose: true,skin: 'layer-ext-moon'
}})", "全部行添加失败"), Page);
}
else
{
Buckup.Buckup_Add("添加视频", u.name, clientIP, count);
string errorinfo = "";
for (int m = 0; m < state0index.Length; m++)
{
if (state0index[m] != null && state0index[m] != "")
{
errorinfo += state0index[m] + ",";
}
}
errorinfo = errorinfo.Substring(0, errorinfo.Length - 1);
Label1.Text = ("添加成功," + count +
"行数据,但是当前类型是状态为0,请修改为1就可以显示,发生在第" + errorinfo + "条信道" +
error).Replace("'", "〞");
Layer(string.Format(@"layer.alert('{0}', {{
icon: 6,title: false,
shadeClose: true,skin: 'layer-ext-moon'
}})", Label1.Text), Page);
}
}
}