private ChildYingyanggeanObj getYingyangGeanObj()
{
ChildYingyanggeanObj goulougeanobj = new ChildYingyanggeanObj();
goulougeanobj.childId = _baseobj.Id;
goulougeanobj.jiwangshi = textBoxX3.Text.Trim();
goulougeanobj.managetime = dateTimeInput2.Value.ToString("yyyy-MM-dd");
if (!String.IsNullOrEmpty(dateTimeInput3.Value.ToString()))
{
goulougeanobj.endtime = dateTimeInput3.Value.ToString("yyyy-MM-dd");
}
goulougeanobj.zhuangui = getcheckedValue(pnl_zhuangui);
goulougeanobj.buruqi = getcheckedValue(panel1);
goulougeanobj.childvitd = getcheckedValue(panel2);
goulougeanobj.startvitdmonth = textBoxX2.Text.Trim();
goulougeanobj.startvitdday = textBoxX6.Text.Trim();
goulougeanobj.vitdname = textBoxX7.Text.Trim();
goulougeanobj.vitdliang = textBoxX11.Text.Trim();
goulougeanobj.tizheng = getcheckedValue(panel3);
goulougeanobj.xuegai = textBoxX13.Text.Trim();
goulougeanobj.xuelin = textBoxX14.Text.Trim();
goulougeanobj.xueakp = textBoxX15.Text.Trim();
goulougeanobj.xueoh = textBoxX16.Text.Trim();
goulougeanobj.xjiancha = textBoxX17.Text.Trim();
return(goulougeanobj);
}
public ChildYingyanggeanObj getYingyanggeanObj(string sqls)
{
DateLogic dg = new DateLogic();
SqlDataReader sdr = null;
try
{
sdr = dg.executequery(sqls);
ChildYingyanggeanObj obj = null;
if (!sdr.HasRows)
{
return(null);
}
else
{
sdr.Read();
obj = new ChildYingyanggeanObj();
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.chushengshi = sdr["chushengshi"].ToString();
obj.weiyangshi = sdr["weiyangshi"].ToString();
obj.foodchange = sdr["foodchange"].ToString();
obj.recordtime = sdr["recordtime"].ToString();
obj.recordname = sdr["recordname"].ToString();
obj.yunzhou = sdr["yunzhou"].ToString();
obj.yuntian = sdr["yuntian"].ToString();
obj.hb = sdr["hb"].ToString();
obj.tieji = sdr["tieji"].ToString();
obj.yaowu = sdr["yaowu"].ToString();
obj.jiliang = sdr["jiliang"].ToString();
obj.liaocheng = sdr["liaocheng"].ToString();
obj.muru = sdr["muru"].ToString();
obj.foodage = sdr["foodage"].ToString();
obj.buruqi = sdr["buruqi"].ToString();
obj.childvitd = sdr["childvitd"].ToString();
obj.startvitdmonth = sdr["startvitdmonth"].ToString();
obj.startvitdday = sdr["startvitdday"].ToString();
obj.vitdname = sdr["vitdname"].ToString();
obj.vitdliang = sdr["vitdliang"].ToString();
obj.tizheng = sdr["tizheng"].ToString();
obj.xuegai = sdr["xuegai"].ToString();
obj.xuelin = sdr["xuelin"].ToString();
obj.xueakp = sdr["xueakp"].ToString();
obj.xueoh = sdr["xueoh"].ToString();
obj.xjiancha = sdr["xjiancha"].ToString();
}
return(obj);
}
catch (Exception ex)
{
MessageBox.Show("系统异常,请联系管理员", "软件提示");
throw ex;
}
}
public PanelPinxuezhuananPrinter(DataGridView dataGridView, ChildBaseInfoObj baseobj, ChildYingyanggeanObj yinyanggeanobj)
{
InitializeComponent();
_dataGridView = dataGridView;//页面传过来需要打印的datagridview对象
_pageHeaders = new List <Header>();
_tableFoots = new List <Header>();
_columnsPrintWidth = new List <int>();
_baseobj = baseobj;
_yinyanggeanobj = yinyanggeanobj;
}
public void saveyingyangzhuanan()
{
yingyanggeanobj = getYingyangGeanObj();
if (yingyanggeanbll.savejibingguanliObj(yingyanggeanobj))
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}
public void savepinxuezhuanan()
{
yingyanggeanobj = getChildPinxuegeanObj();
if (yingyanggeanbll.saveYingyanggeanObj(yingyanggeanobj))
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}
private void Paneltsb_goulou_zhuanan_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;
gerenshi.Text = _baseobj.gerenshi;
jiwangshi.Text = _baseobj.jiwangshi;
jiazushi.Text = _baseobj.jiazushi;
textBoxX12.Text = new TbGaoweiBll().getGaoweistr(_baseobj.Id, "", "");
string goulougeansqlstr = "select * from child_yingyanggean where childid=" + _baseobj.Id;
yingyanggeanobj = yingyanggeanbll.getYingyanggeanObj(goulougeansqlstr);
if (yingyanggeanobj != null)
{
textBoxX3.Text = yingyanggeanobj.jiwangshi;
if (!String.IsNullOrEmpty(yingyanggeanobj.managetime))
{
dateTimeInput2.Value = Convert.ToDateTime(yingyanggeanobj.managetime);
}
if (!String.IsNullOrEmpty(yingyanggeanobj.endtime))
{
dateTimeInput3.Value = Convert.ToDateTime(yingyanggeanobj.endtime);
}
setcheckedValue(pnl_zhuangui, yingyanggeanobj.zhuangui);
setcheckedValue(panel1, yingyanggeanobj.buruqi);
setcheckedValue(panel2, yingyanggeanobj.childvitd);
textBoxX2.Text = yingyanggeanobj.startvitdmonth;
textBoxX6.Text = yingyanggeanobj.startvitdday;
textBoxX7.Text = yingyanggeanobj.vitdname;
textBoxX11.Text = yingyanggeanobj.vitdliang;
setcheckedValue(panel3, yingyanggeanobj.tizheng);
textBoxX13.Text = yingyanggeanobj.xuegai;
textBoxX14.Text = yingyanggeanobj.xuelin;
textBoxX15.Text = yingyanggeanobj.xueakp;
textBoxX16.Text = yingyanggeanobj.xueoh;
textBoxX17.Text = yingyanggeanobj.xjiancha;
}
else
{
dateTimeInput2.Value = Convert.ToDateTime(_baseobj.ChildBuildDay);
}
refreshRecordList();
}
private ChildYingyanggeanObj getYingyangGeanObj()
{
ChildYingyanggeanObj yingyanggeanobj = new ChildYingyanggeanObj();
yingyanggeanobj.childId = _baseobj.Id;
yingyanggeanobj.jiwangshi = textBoxX3.Text.Trim();
yingyanggeanobj.managetime = dateTimeInput2.Value.ToString("yyyy-MM-dd");
if (!String.IsNullOrEmpty(dateTimeInput3.Value.ToString()))
{
yingyanggeanobj.endtime = dateTimeInput3.Value.ToString("yyyy-MM-dd");
}
yingyanggeanobj.zhuangui = getcheckedValue(pnl_zhuangui);
yingyanggeanobj.chushengshi = getcheckedValue(panel1);
yingyanggeanobj.weiyangshi = getcheckedValue(panel2);
yingyanggeanobj.foodchange = textBoxX15.Text;
return(yingyanggeanobj);
}
private void Paneltsb_pinxue_zhuanan_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;
gerenshi.Text = _baseobj.gerenshi;
jiwangshi.Text = _baseobj.jiwangshi;
jiazushi.Text = _baseobj.jiazushi;
textBoxX12.Text = new TbGaoweiBll().getGaoweistr(_baseobj.Id, "", "");
string pinxuegeansqlstr = "select * from child_yingyanggean where childid=" + _baseobj.Id;
yingyanggeanobj = yingyanggeanbll.getYingyanggeanObj(pinxuegeansqlstr);
if (yingyanggeanobj != null)
{
textBoxX3.Text = yingyanggeanobj.jiwangshi;
if (!String.IsNullOrEmpty(yingyanggeanobj.managetime))
{
dateTimeInput2.Value = Convert.ToDateTime(yingyanggeanobj.managetime);
}
if (!String.IsNullOrEmpty(yingyanggeanobj.endtime))
{
dateTimeInput3.Value = Convert.ToDateTime(yingyanggeanobj.endtime);
}
setcheckedValue(pnl_zhuangui, yingyanggeanobj.zhuangui);
textBoxX13.Text = yingyanggeanobj.yunzhou;
textBoxX2.Text = yingyanggeanobj.yuntian;
textBoxX14.Text = yingyanggeanobj.hb;
setcheckedValue(panel1, yingyanggeanobj.tieji);
textBoxX11.Text = yingyanggeanobj.yaowu;
textBoxX6.Text = yingyanggeanobj.jiliang;
textBoxX7.Text = yingyanggeanobj.liaocheng;
setcheckedValue(panel2, yingyanggeanobj.muru);
textBoxX15.Text = yingyanggeanobj.foodage;
}
else
{
dateTimeInput2.Value = Convert.ToDateTime(_baseobj.ChildBuildDay);
}
refreshRecordList();
}
private void Paneljibingguanli_zhuanan_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 yingyanggeansqlstr = "select * from child_jibingguanli where childid=" + _baseobj.Id;
yingyanggeanobj = yingyanggeanbll.getYingyanggeanObj(yingyanggeansqlstr);
if (yingyanggeanobj != null)
{
textBoxX3.Text = yingyanggeanobj.jiwangshi;
if (!String.IsNullOrEmpty(yingyanggeanobj.managetime))
{
dateTimeInput2.Value = Convert.ToDateTime(yingyanggeanobj.managetime);
}
if (!String.IsNullOrEmpty(yingyanggeanobj.endtime))
{
dateTimeInput3.Value = Convert.ToDateTime(yingyanggeanobj.endtime);
}
setcheckedValue(pnl_zhuangui, yingyanggeanobj.zhuangui);
setcheckedValue(panel1, yingyanggeanobj.chushengshi);
setcheckedValue(panel2, yingyanggeanobj.weiyangshi);
textBoxX15.Text = yingyanggeanobj.foodchange;
}
else
{
dateTimeInput2.Value = Convert.ToDateTime(_baseobj.ChildBuildDay);
}
refreshRecordList();
}
private ChildYingyanggeanObj getChildPinxuegeanObj()
{
ChildYingyanggeanObj pinxuegeanobj = new ChildYingyanggeanObj();
pinxuegeanobj.childId = _baseobj.Id;
pinxuegeanobj.jiwangshi = textBoxX3.Text.Trim();
pinxuegeanobj.managetime = dateTimeInput2.Value.ToString("yyyy-MM-dd");
if (!String.IsNullOrEmpty(dateTimeInput3.Value.ToString()))
{
pinxuegeanobj.endtime = dateTimeInput3.Value.ToString("yyyy-MM-dd");
}
pinxuegeanobj.zhuangui = getcheckedValue(pnl_zhuangui);
pinxuegeanobj.yunzhou = textBoxX13.Text;
pinxuegeanobj.yuntian = textBoxX2.Text;
pinxuegeanobj.hb = textBoxX14.Text;
pinxuegeanobj.tieji = getcheckedValue(panel1);
pinxuegeanobj.yaowu = textBoxX11.Text;
pinxuegeanobj.jiliang = textBoxX6.Text;
pinxuegeanobj.liaocheng = textBoxX7.Text;
pinxuegeanobj.muru = getcheckedValue(panel2);
pinxuegeanobj.foodage = textBoxX15.Text;
return(pinxuegeanobj);
}
//保存
public bool saveYingyanggeanObj(ChildYingyanggeanObj yingyanggeanobj)
{
try
{
string selstr = "select * from child_yingyanggean where childid=" + yingyanggeanobj.childId;
string sqls = "";
if (ifhascount(selstr))
{
sqls = "insert into child_yingyanggean ("
+ "childId"
+ ",jiwangshi"
+ ",endtime"
+ ",managetime"
+ ",zhuangui"
+ ",chushengshi"
+ ",weiyangshi"
+ ",foodchange"
+ ",yunzhou"
+ ",yuntian"
+ ",hb"
+ ",tieji"
+ ",yaowu"
+ ",jiliang"
+ ",liaocheng"
+ ",muru"
+ ",foodage"
+ ",buruqi"
+ ",childvitd"
+ ",startvitdmonth"
+ ",startvitdday"
+ ",vitdname"
+ ",vitdliang"
+ ",tizheng"
+ ",xuegai"
+ ",xuelin"
+ ",xueakp"
+ ",xueoh"
+ ",xjiancha"
+ ",recordtime"
+ ",recordname"
+ " ) values ( "
+ "" + yingyanggeanobj.childId + ""
+ ",'" + yingyanggeanobj.jiwangshi + "'"
+ ",'" + yingyanggeanobj.endtime + "'"
+ ",'" + yingyanggeanobj.managetime + "'"
+ ",'" + yingyanggeanobj.zhuangui + "'"
+ ",'" + yingyanggeanobj.chushengshi + "'"
+ ",'" + yingyanggeanobj.weiyangshi + "'"
+ ",'" + yingyanggeanobj.foodchange + "'"
+ ",'" + yingyanggeanobj.yunzhou + "'"
+ ",'" + yingyanggeanobj.yuntian + "'"
+ ",'" + yingyanggeanobj.hb + "'"
+ ",'" + yingyanggeanobj.tieji + "'"
+ ",'" + yingyanggeanobj.yaowu + "'"
+ ",'" + yingyanggeanobj.jiliang + "'"
+ ",'" + yingyanggeanobj.liaocheng + "'"
+ ",'" + yingyanggeanobj.muru + "'"
+ ",'" + yingyanggeanobj.foodage + "'"
+ ",'" + yingyanggeanobj.buruqi + "'"
+ ",'" + yingyanggeanobj.childvitd + "'"
+ ",'" + yingyanggeanobj.startvitdmonth + "'"
+ ",'" + yingyanggeanobj.startvitdday + "'"
+ ",'" + yingyanggeanobj.vitdname + "'"
+ ",'" + yingyanggeanobj.vitdliang + "'"
+ ",'" + yingyanggeanobj.tizheng + "'"
+ ",'" + yingyanggeanobj.xuegai + "'"
+ ",'" + yingyanggeanobj.xuelin + "'"
+ ",'" + yingyanggeanobj.xueakp + "'"
+ ",'" + yingyanggeanobj.xueoh + "'"
+ ",'" + yingyanggeanobj.xjiancha + "'"
+ ",'" + yingyanggeanobj.recordtime + "'"
+ ",'" + yingyanggeanobj.recordname + "'"
+ ")";
}
else
{
sqls = "update child_yingyanggean set "
+ " jiwangshi = '" + yingyanggeanobj.jiwangshi + "'"
+ " ,endtime = '" + yingyanggeanobj.endtime + "'"
+ " ,managetime = '" + yingyanggeanobj.managetime + "'"
+ " ,zhuangui = '" + yingyanggeanobj.zhuangui + "'"
+ " ,chushengshi = '" + yingyanggeanobj.chushengshi + "'"
+ " ,weiyangshi = '" + yingyanggeanobj.weiyangshi + "'"
+ " ,foodchange = '" + yingyanggeanobj.foodchange + "'"
+ " ,yunzhou = '" + yingyanggeanobj.yunzhou + "'"
+ " ,yuntian = '" + yingyanggeanobj.yuntian + "'"
+ " ,hb = '" + yingyanggeanobj.hb + "'"
+ " ,tieji = '" + yingyanggeanobj.tieji + "'"
+ " ,yaowu = '" + yingyanggeanobj.yaowu + "'"
+ " ,jiliang = '" + yingyanggeanobj.jiliang + "'"
+ " ,liaocheng = '" + yingyanggeanobj.liaocheng + "'"
+ " ,muru = '" + yingyanggeanobj.muru + "'"
+ " ,foodage = '" + yingyanggeanobj.foodage + "'"
+ " ,buruqi = '" + yingyanggeanobj.buruqi + "'"
+ " ,childvitd = '" + yingyanggeanobj.childvitd + "'"
+ " ,startvitdmonth = '" + yingyanggeanobj.startvitdmonth + "'"
+ " ,startvitdday = '" + yingyanggeanobj.startvitdday + "'"
+ " ,vitdname = '" + yingyanggeanobj.vitdname + "'"
+ " ,vitdliang = '" + yingyanggeanobj.vitdliang + "'"
+ " ,tizheng = '" + yingyanggeanobj.tizheng + "'"
+ " ,xuegai = '" + yingyanggeanobj.xuegai + "'"
+ " ,xuelin = '" + yingyanggeanobj.xuelin + "'"
+ " ,xueakp = '" + yingyanggeanobj.xueakp + "'"
+ " ,xueoh = '" + yingyanggeanobj.xueoh + "'"
+ " ,xjiancha = '" + yingyanggeanobj.xjiancha + "'"
+ " ,recordtime = '" + yingyanggeanobj.recordtime + "'"
+ " ,recordname = '" + yingyanggeanobj.recordname + "'"
+ " where childId= " + yingyanggeanobj.childId;
}
if (dg.executeupdate(sqls) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show("保存失败", "软件提示");
throw ex;
}
}
