public ChildGaoweigeanObj getGaoweigeanObj(string sqls) { DateLogic dg = new DateLogic(); SqlDataReader sdr = null; try { sdr = dg.executequery(sqls); ChildGaoweigeanObj obj = null; if (!sdr.HasRows) { return(null); } else { sdr.Read(); obj = new ChildGaoweigeanObj(); obj.id = Convert.ToInt32(sdr["id"]); obj.childId = Convert.ToInt32(sdr["childId"]); obj.jiwangshi = sdr["jiwangshi"].ToString(); obj.endtime = sdr["endtime"].ToString(); obj.managetime = sdr["managetime"].ToString(); obj.zhuangui = sdr["zhuangui"].ToString(); obj.zhuanzhendanwei = sdr["zhuanzhendanwei"].ToString(); obj.recordtime = sdr["recordtime"].ToString(); obj.recordname = sdr["recordname"].ToString(); } return(obj); } catch (Exception ex) { MessageBox.Show("系统异常,请联系管理员", "软件提示"); throw ex; } }
private void Panelxinliyichang_Load(object sender, EventArgs e) { textBoxX1.Text = _baseobj.childName; textBoxX4.Text = _baseobj.childGender; textBoxX5.Text = _baseobj.childBirthDay; textBoxX8.Text = _baseobj.MotherName; textBoxX9.Text = _baseobj.Telephone; textBoxX10.Text = _baseobj.address; textBoxX12.Text = new TbGaoweiBll().getGaoweistr(_baseobj.Id, "", ""); string gaoweigeansqlstr = "select * from child_xinlixingwei where childid=" + _baseobj.Id; gaoweigeanobj = gaoweigeanbll.getGaoweigeanObj(gaoweigeansqlstr); if (gaoweigeanobj != null) { textBoxX3.Text = gaoweigeanobj.jiwangshi; if (!String.IsNullOrEmpty(gaoweigeanobj.managetime)) { dateTimeInput2.Value = Convert.ToDateTime(gaoweigeanobj.managetime); } if (!String.IsNullOrEmpty(gaoweigeanobj.endtime)) { dateTimeInput3.Value = Convert.ToDateTime(gaoweigeanobj.endtime); } setcheckedValue(pnl_zhuangui, gaoweigeanobj.zhuangui); textBoxX2.Text = gaoweigeanobj.zhuanzhendanwei; } else { dateTimeInput2.Value = Convert.ToDateTime(_baseobj.ChildBuildDay); } refreshRecordList(); }
public bool savexinlixingweigeanObj(ChildGaoweigeanObj gaoweigeanobj) { try { string selstr = "select * from child_xinlixingwei where childid=" + gaoweigeanobj.childId; string sqls = ""; if (ifhascount(selstr)) { sqls = "insert into child_xinlixingwei (" + "childId" + ",jiwangshi" + ",endtime" + ",managetime" + ",zhuangui" + ",zhuanzhendanwei" + ",recordtime" + ",recordname" + " ) values ( " + "" + gaoweigeanobj.childId + "" + ",'" + gaoweigeanobj.jiwangshi + "'" + ",'" + gaoweigeanobj.endtime + "'" + ",'" + gaoweigeanobj.managetime + "'" + ",'" + gaoweigeanobj.zhuangui + "'" + ",'" + gaoweigeanobj.zhuanzhendanwei + "'" + ",'" + gaoweigeanobj.recordtime + "'" + ",'" + gaoweigeanobj.recordname + "'" + ")"; } else { sqls = "update child_xinlixingwei set " + " jiwangshi = '" + gaoweigeanobj.jiwangshi + "'" + " ,endtime = '" + gaoweigeanobj.endtime + "'" + " ,managetime = '" + gaoweigeanobj.managetime + "'" + " ,zhuangui = '" + gaoweigeanobj.zhuangui + "'" + " ,zhuanzhendanwei = '" + gaoweigeanobj.zhuanzhendanwei + "'" + " ,recordtime = '" + gaoweigeanobj.recordtime + "'" + " ,recordname = '" + gaoweigeanobj.recordname + "'" + " where childId= " + gaoweigeanobj.childId; } if (dg.executeupdate(sqls) > 0) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show("保存失败", "软件提示"); throw ex; } }
public pritner(DataGridView dataGridView, ChildBaseInfoObj baseobj, ChildGaoweigeanObj gaoweigeanobj) { InitializeComponent(); _dataGridView = dataGridView;//页面传过来需要打印的datagridview对象 _pageHeaders = new List <Header>(); _tableFoots = new List <Header>(); _columnsPrintWidth = new List <int>(); _baseobj = baseobj; _gaoweigeanobj = gaoweigeanobj; }
public void savegaoweizhuanan() { gaoweigeanobj = getGaoweiGeanObj(); if (gaoweigeanbll.savexinlixingweigeanObj(gaoweigeanobj)) { MessageBox.Show("保存成功!"); } else { MessageBox.Show("保存失败!"); } }
private ChildGaoweigeanObj getGaoweiGeanObj() { ChildGaoweigeanObj gaoweigeanobj = new ChildGaoweigeanObj(); gaoweigeanobj.childId = _baseobj.Id; gaoweigeanobj.jiwangshi = textBoxX3.Text.Trim(); gaoweigeanobj.managetime = dateTimeInput2.Value.ToString("yyyy-MM-dd"); if (!String.IsNullOrEmpty(dateTimeInput3.Value.ToString())) { gaoweigeanobj.endtime = dateTimeInput3.Value.ToString("yyyy-MM-dd"); } gaoweigeanobj.zhuangui = getcheckedValue(pnl_zhuangui); gaoweigeanobj.zhuanzhendanwei = textBoxX2.Text.Trim(); return(gaoweigeanobj); }