/// <summary> /// 查询一个点对应的所有信息 /// </summary> /// <param name="BasedateID"></param> /// <returns></returns> public static Dictionary<int, 历史调度资源> GetDic历史调度资源ByBasedateID(string BasedateID) { Dictionary<int, 历史调度资源> dic历史调度资源 = new Dictionary<int, 历史调度资源>(); string sql = "SELECT " + " [FileName] " + //" ,[Value] " + " ,[CreateDate] " + " ,[Size] " + " ,[ID] " + " FROM [历史调度资源] where BasedateID = '" + BasedateID.ToString().Replace("'", "''") + "'"; DataTable dt = new DataTable("历史调度资源"); SQLExecute.Convertdrtodt(SQLExecute.ExecuteReader(sql), dt); if (dt.Rows.Count == 0) { dic历史调度资源 = new Dictionary<int, 历史调度资源>(); } else if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { 历史调度资源 历史调度资源_ = new 历史调度资源(BasedateID); 历史调度资源_.BCreateDate = Convert.ToDateTime(dt.Rows[i]["CreateDate"]); 历史调度资源_.BFileName = dt.Rows[i]["FileName"].ToString(); //历史调度资源_.BImage = (byte[])(dt.Rows[i]["Value"]); 历史调度资源_.BSize = Convert.ToInt32(dt.Rows[i]["Size"]); 历史调度资源_.Bindex = Convert.ToInt32(dt.Rows[i]["ID"]); dic历史调度资源.Add(i, 历史调度资源_); } } return dic历史调度资源; }
/// <summary> /// 更新数据(有数据即更新,无数据即添加) /// </summary> /// <param name="BasedateID"></param> /// <returns></returns> public static int UpdateFileByBasedateID(历史调度资源 历史调度资源_) { string InsertSQL = "UPDATE [历史调度资源] SET " + " [FileName] = '" + 历史调度资源_.BFileName.ToString().Replace("'", "''") + "'" + " ,[CreateDate] = '" + 历史调度资源_.BCreateDate.ToString("yyyy-MM-dd HH:mm:ss") + "'" + " ,[Size] = '" + 历史调度资源_.BSize.ToString().Replace("'", "''") + "'" + " ,[Value] = @Value " + " WHERE [basedateID] ='" + 历史调度资源_.BbasedateID.ToString().Replace("'", "''") + "' " + " AND [CreateDate] ='" + 历史调度资源_.BCreateDate.ToString("yyyy-MM-dd HH:mm:ss") + "'" + " AND [FileName] = '" + 历史调度资源_.BFileName.ToString().Replace("'", "''") + "'"; string UpDateSQL = "INSERT INTO [历史调度资源] " + " ([FileName] " + " ,[basedateID] " + " ,[CreateDate] " + " ,[Size] " + " ,[Value]) " + " VALUES " + " ( '" + 历史调度资源_.BFileName.ToString().Replace("'", "''") + "'" + " , '" + 历史调度资源_.BbasedateID.ToString().Replace("'", "''") + "'" + " , '" + 历史调度资源_.BCreateDate.ToString("yyyy-MM-dd HH:mm:ss") +"'" + " , '" + 历史调度资源_.BSize.ToString().Replace("'", "''") + "'" + " , @Value)"; 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); ; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Value", SqlDbType.Image); param[0].Value = 历史调度资源_.BValue; return SQLExecute.ExecuteNonQuery(SQLExecute.ConnectionStringLocalTransaction, CommandType.Text, strSQL, param); }
private void button2_Click(object sender, EventArgs e) { if (listView1.Items.Count<=0) { return; } 历史调度资源 历史调度资源_ = null; List<string> list_str = new List<string>(); for (int i = 0; i < listView1.Items.Count; i++) { list_str.Add(this.listView1.Items[i].SubItems[0].Text); } try { for (int i = 0; i < list_str.Count; i++) { FileInfo fi = new FileInfo(list_str[i]); 历史调度资源_ = new 历史调度资源(BasedateID); 历史调度资源_.BCreateDate = fi.CreationTime; 历史调度资源_.BFileName = fi.Name; 历史调度资源_.BSize = fi.Length; 历史调度资源_.BValue = S_OperateInfocomend.getBytefromFile(list_str[i]); if (历史调度资源comend.UpdateFileByBasedateID(历史调度资源_) > 0) { } } MessageBox.Show("更新成功!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); SQLExecute.Operate = "用户" + DBUser.CURR_USERID + "添加历史调度资源文件,支撑中心编号:" + BasedateID;//+ ",设备测试记录的测试项目:" + listBox1.Items[listBox1.SelectedIndex].ToString(); SQLExecute.SaveOperate(); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ee) { MessageBox.Show("更新失败!请与管理员联系!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }