/// <summary>
/// 更新
/// </summary>
/// <param name="设备测试记录Info"></param>
public static void UpDate设备测试记录(DateDef.设备测试记录 设备测试记录Info)
{
//if (设备测试记录Info.B图片 == null)
//{ string s = "NULL";}
//else{
// 设备测试记录Info.B图片
//}
string InsertSQL =
"UPDATE [设备测试记录] " +
" SET " +
" [基站名称] = '" + 设备测试记录Info.B基站名称.ToString().Replace("'", "''") + "' " +
" ,[测试时间] = '" + 设备测试记录Info.B测试时间.ToString().Replace("'", "''") + "' " +
" ,[测试结果] = '" + 设备测试记录Info.B测试结果.ToString().Replace("'", "''") + "' " +
" ,[图片] = @photo " +
" ,[测试人] = '" + 设备测试记录Info.B测试人.ToString().Replace("'", "''") + "' " +
" WHERE [basedateID] = '" + 设备测试记录Info.BbasedateID.ToString().Replace("'", "''") + "' " +
"AND [测试项目] = '" + 设备测试记录Info.B测试项目.ToString().Replace("'", "''") + "' ";
string UpDateSQL =
"INSERT INTO [设备测试记录] " +
" ([basedateID] " +
" ,[基站名称] " +
" ,[测试项目] " +
" ,[测试时间] " +
" ,[测试结果] " +
" ,[图片] " +
" ,[测试人]) " +
" VALUES " +
"('" + 设备测试记录Info.BbasedateID.ToString().Replace("'", "''") + "' " +
",'" + 设备测试记录Info.B基站名称.ToString().Replace("'", "''") + "' " +
",'" + 设备测试记录Info.B测试项目.ToString().Replace("'", "''") + "' " +
",'" + 设备测试记录Info.B测试时间.ToString().Replace("'", "''") + "' " +
",'" + 设备测试记录Info.B测试结果.ToString().Replace("'", "''") + "' " +
", @photo , " +
"'" + 设备测试记录Info.B测试人.ToString().Replace("'", "''") + "') ";
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@photo", SqlDbType.Image);
param[0].Value = 设备测试记录Info.B图片;
string strSQL = null;
strSQL += InsertSQL;//= string.Format("Update S_RoleDetail set [Power]='{0}' where [RoleID]='{1}' and ProgramID ='{2}'", dt.Rows[i][1].ToString().Replace("'", "''"), dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"));
strSQL = strSQL + " if @@RowCount=0 ";
strSQL = strSQL + UpDateSQL;//string.Format("Insert into S_RoleDetail ([RoleID],[ProgramID],[Power]) values ('{0}','{1}','{2}')", dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"), dt.Rows[i][1].ToString().Replace("'", "''"));
SQLExecute.ExecuteNonQuery(SQLExecute.ConnectionStringLocalTransaction, CommandType.Text, strSQL, param);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="图片Info"></param>
public static void Insert图片(DateDef.图片 图片Info)
{
string strSQL =
"INSERT INTO [图片] " +
" ([basedateID] " +
" ,[概要] " +
" ,[图片说明] " +
" ,[图片]) " +
" VALUES " +
"('" + 图片Info.BbasedateID.ToString().Replace("'", "''") + "' " +
",'" + 图片Info.B概要.ToString().Replace("'", "''") + "' " +
",'" + 图片Info.B图片说明.ToString().Replace("'", "''") + "' " +
",@photo)";
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@photo", SqlDbType.Image);
param[0].Value = 图片Info.B图片;
SQLExecute.ExecuteNonQuery(SQLExecute.ConnectionStringLocalTransaction, CommandType.Text, strSQL, param);
}
/// <summary>
/// ���
/// </summary>
/// <param name="��������Info"></param>
public static void Insert��������(DateDef.�������� ��������Info)
{
string sql =
"INSERT INTO [��������] " +
" ([basedateID] " +
" ,[�¼�ʱ��] " +
" ,[��������] " +
" ,[���봦����] " +
" ,[�������] " +
" ,[��ע] " +
" ,[��������]) " +
" VALUES " +
"('" + ��������Info.BbasedateID.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B�¼�ʱ��.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B��������.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B���봦����.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B�������.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B��ע.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B��������.ToString().Replace("'", "''") + "')";
SQLExecute.ExecuteNonQuery(sql);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="设备测试记录Info"></param>
///
public static void Insert设备测试记录(DateDef.设备测试记录 设备测试记录Info)
{
string sql =
"INSERT INTO [BaseStationDB].[dbo].[健康档案] " +
" ([basedateID] " +
" ,[事件时间] " +
" ,[现象描述] " +
" ,[参与处理人] " +
" ,[处理过程] " +
" ,[备注] " +
" ,[分析结论]) " +
" VALUES " +
"('" + 设备测试记录Info.BbasedateID.ToString().Replace("'", "''") + "'" +
",'" + 设备测试记录Info.B基站名称.ToString().Replace("'", "''") + "'" +
",'" + 设备测试记录Info.B测试项目.ToString().Replace("'", "''") + "'" +
",'" + 设备测试记录Info.B测试时间.ToString().Replace("'", "''") + "'" +
",'" + 设备测试记录Info.B测试结果.ToString().Replace("'", "''") + "'" +
",'" + 设备测试记录Info.B测试人.ToString().Replace("'", "''") + "'" +
",'" + 设备测试记录Info.B图片.ToString().Replace("'", "''") + "')";
SQLExecute.ExecuteNonQuery(sql);
}
/// <summary>
/// ����
/// </summary>
/// <param name="��������Info"></param>
public static void UpDate��������(DateDef.�������� ��������Info)
{
string InsertSQL =
"UPDATE [��������] " +
" SET " +
" [��������] = '" + ��������Info.B��������.ToString().Replace("'", "''") + "' " +
" ,[���봦����] = '" + ��������Info.B���봦����.ToString().Replace("'", "''") + "' " +
" ,[�������] = '" + ��������Info.B�������.ToString().Replace("'", "''") + "' " +
" ,[��ע] = '" + ��������Info.B��ע.ToString().Replace("'", "''") + "' " +
" ,[��������] = '" + ��������Info.B��������.ToString().Replace("'", "''") + "'" +
" WHERE [basedateID] = '" + ��������Info.BbasedateID.ToString().Replace("'", "''") + "' " +
" AND [�¼�ʱ��] = '" + ��������Info.B�¼�ʱ��.ToString().Replace("'", "''") + "' ";
string UpDateSQL =
"INSERT INTO [��������] " +
" ([basedateID] " +
" ,[�¼�ʱ��] " +
" ,[��������] " +
" ,[���봦����] " +
" ,[�������] " +
" ,[��ע] " +
" ,[��������]) " +
" VALUES " +
"('" + ��������Info.BbasedateID.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B�¼�ʱ��.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B��������.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B���봦����.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B�������.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B��ע.ToString().Replace("'", "''") + "'" +
",'" + ��������Info.B��������.ToString().Replace("'", "''") + "')";
string strSQL = null;
strSQL += InsertSQL;//= string.Format("Update S_RoleDetail set [Power]='{0}' where [RoleID]='{1}' and ProgramID ='{2}'", dt.Rows[i][1].ToString().Replace("'", "''"), dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"));
strSQL = strSQL + " if @@RowCount=0 ";
strSQL = strSQL + UpDateSQL;//string.Format("Insert into S_RoleDetail ([RoleID],[ProgramID],[Power]) values ('{0}','{1}','{2}')", dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"), dt.Rows[i][1].ToString().Replace("'", "''"));
SQLExecute.ExecuteNonQuery(strSQL);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="图片Info"></param>
public static void UpDate图片(DateDef.图片 图片Info)
{
string InsertSQL =
"UPDATE [图片] " +
" SET " +
" [图片] = @photo " +
" ,[图片说明] = '" + 图片Info.B图片说明.ToString().Replace("'", "''") + "' " +
" WHERE [basedateID] = '" + 图片Info.BbasedateID.ToString().Replace("'", "''") + "' " +
" AND [概要] = '" + 图片Info.B概要.ToString().Replace("'", "''") + "'";
string UpDateSQL =
"INSERT INTO [图片] " +
" ([basedateID] " +
" ,[概要] " +
" ,[图片说明] " +
" ,[图片]) " +
" VALUES " +
"('" + 图片Info.BbasedateID.ToString().Replace("'", "''") + "' " +
",'" + 图片Info.B概要.ToString().Replace("'", "''") + "' " +
",'" + 图片Info.B图片说明.ToString().Replace("'", "''") + "' " +
",@photo)";
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@photo", SqlDbType.Image);
param[0].Value = 图片Info.B图片;
string strSQL = null;
strSQL += InsertSQL;
strSQL = strSQL + " if @@RowCount=0 ";
strSQL = strSQL + UpDateSQL;
SQLExecute.ExecuteNonQuery(SQLExecute.ConnectionStringLocalTransaction, CommandType.Text, strSQL, param);
}
public static SqlDataAdapter InitSqlDataAdapter(DateDef.BSINFO BSinfo)
{
sqlda = new SqlDataAdapter();
//sqlda.DeleteCommand = new SqlCommand(string.Format("DELETE FROM BSTypeInfo WHERE (TypeID = '{0}')", BSinfo.Bsid), SQLExecute.SqlConn);
//sqlda.SelectCommand = new SqlCommand(string.Format("SELECT TypeID, TypeName FROM BSTypeInfo"), SQLExecute.SqlConn);
sqlda.InsertCommand = new SqlCommand(string.Format("INSERT INTO BSTypeInfo TypeID, TypeName) VALUES ('{0}', '{1}')", BSinfo.Bsid, BSinfo.Bsname), SQLExecute.SqlConn);
//sqlda.UpdateCommand = new SqlCommand(string.Format("UPDATE BSTypeInfo SET TypeID = '{0}', TypeName = '{1}' WHERE (TypeID = '{2}') ", BSinfo.Bsid, BSinfo.Bsname, BSinfo.Bsid), SQLExecute.SqlConn);
return sqlda;
}
