/// <summary> /// 儿童保健对象 /// </summary> /// <param name="sqls"></param> /// <returns></returns> public childSetbaoJiangGuidObj getbaojianobj(string sqls) { DateLogic dg = new DateLogic(); SqlDataReader sdr = null; childSetbaoJiangGuidObj obj = null; ArrayList arraylist = new ArrayList();; try { sdr = dg.executequery(sqls); if (!sdr.HasRows) { return(null); } else { obj = new childSetbaoJiangGuidObj(); sdr.Read();//读取第一行数据记录 obj.Id = Convert.ToInt32(sdr["id"]); //obj.ChildId = Convert.ToInt32(sdr["childId"]); obj.Setage = sdr["setage"].ToString(); obj.Eduction = sdr["eduction"].ToString(); obj.Shanshi = sdr["shanshi"].ToString(); obj.Jibing = sdr["jibing"].ToString(); obj.Huli = sdr["huli"].ToString(); return(obj); } } catch (Exception ex) { MessageBox.Show("系统异常,请联系管理员", "软件提示"); throw ex; //ErrorHandle.OnError(ex); } }
/// <summary> /// 修改 /// </summary> /// <returns></returns> private string getupdatesql() { StringBuilder builder = new StringBuilder(); childSetbaoJiangGuidObj obj1 = new childSetbaoJiangGuidObj(); obj1.Eduction = this.txt_eduction.Text.Trim(); obj1.Shanshi = this.txt_shanshi.Text.Trim(); obj1.Jibing = this.txt_jibing.Text.Trim(); obj1.Huli = this.txt_huli.Text.Trim(); builder.Append("update tb_baojianguid set "); builder.Append("setage='" + obj1.Setage + "',"); builder.Append("eduction = '" + obj1.Eduction + "',"); builder.Append("shanshi='" + obj1.Shanshi + "',"); builder.Append("jibing='" + obj1.Jibing + "',"); builder.Append("huli='" + obj1.Huli + "'"); builder.Append(" where id = " + dgvbaojianguid.CurrentRow.Cells[1].Value.ToString() + ""); return(builder.ToString()); }
/// <summary> /// 根据每行的Id 加载对应的设置内容 /// </summary> /// <param name="rowIndex"></param> /// <param name="type">类型</param> private void addContent(int rowIndex) { string sqls = string.Format("select * from tb_baojianguid where id = " + rowIndex + ""); obj = bll.getbaojianobj(sqls); if (obj != null) { this.txt_eduction.Text = obj.Eduction; this.txt_shanshi.Text = obj.Shanshi; this.txt_jibing.Text = obj.Jibing; this.txt_huli.Text = obj.Huli; id = obj.Id; } else { this.txt_eduction.Text = ""; this.txt_shanshi.Text = ""; this.txt_jibing.Text = ""; this.txt_huli.Text = ""; } }