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);
}
