private void fr基站隐患_Load(object sender, EventArgs e) { Def_基站隐患 基站隐患 = new Def_基站隐患(BasedateID); 基站隐患 = 基站隐患Comend.Get基站隐患ByBasedateID(BasedateID); tb基站存在隐患.Text = 基站隐患.B基站存在隐患; IsCanModify(IsModify); }
private void button2_Click(object sender, EventArgs e) { Def_基站隐患 基站隐患 = new Def_基站隐患(BasedateID); 基站隐患.B基站存在隐患 = tb基站存在隐患.Text; 基站隐患Comend.UpDate基站隐患(基站隐患); SQLExecute.Operate = "用户" + DBUser.CURR_USERID + "更新了基站隐患 ,基站编号:" + 基站隐患.BasedateID; SQLExecute.SaveOperate(); MessageBox.Show("更新成功 !", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); }
/// <summary> /// 添加 /// </summary> /// <param name="基站隐患"></param> public static void Insert基站隐患(Def_基站隐患 基站隐患) { string sql = "INSERT INTO [New基站隐患] " + " ([basedateID] " + " ,[基站存在隐患])" + " VALUES " + " ('" + 基站隐患.BasedateID.ToString().Replace("'", "''") + "' " + 基站隐患.B基站存在隐患.ToString().Replace("'", "''") + "') "; SQLExecute.ExecuteNonQuery(sql); }
/// <summary> /// 更新(带插入) /// </summary> /// <param name="基站隐患"></param> public static void UpDate基站隐患(Def_基站隐患 基站隐患) { string InsertSQL = "UPDATE [New基站隐患] " + " SET " + " [基站存在隐患] = '" + 基站隐患.B基站存在隐患.ToString().Replace("'", "''") + "'" + " WHERE [basedateID] = '" + 基站隐患.BasedateID.ToString().Replace("'", "''") + "'"; string UpDateSQL = "INSERT INTO [New基站隐患] " + " ([basedateID] " + " ,[基站存在隐患])" + " VALUES " + " ('" + 基站隐患.BasedateID.ToString().Replace("'", "''") + "' " + " ,'" + 基站隐患.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="BasedateID"></param> /// <returns></returns> public static Def_基站隐患 Get基站隐患ByBasedateID(string BasedateID) { Def_基站隐患 基站隐患 = new Def_基站隐患(BasedateID); string sql = "SELECT [ID] " + " ,[basedateID] " + " ,[基站存在隐患]"+ " FROM [New基站隐患] where basedateID = '" + BasedateID.ToString().Replace("'", "''") + "'"; DataTable dt = new DataTable("基站隐患"); SQLExecute.Convertdrtodt(SQLExecute.ExecuteReader(sql), dt); if (dt.Rows.Count == 0) { 基站隐患 = new Def_基站隐患(BasedateID); } else { 基站隐患.B基站存在隐患 = dt.Rows[0]["基站存在隐患"].ToString(); } return 基站隐患; }