/// <summary> /// 插入 /// </summary> /// <returns></returns> private string getinsertsql() { StringBuilder builder = new StringBuilder(); childSetyimiaoObj obj1 = new childSetyimiaoObj(); obj1.YimiaoName = this.txt_yimiaoName.Text.Trim(); obj1.ProductionDay = dtp_production.Value.ToString("yyyy-MM-dd"); obj1.FactorName = this.cbx_factorName.Text.Trim(); obj1.Pihao = this.txt_pihao.Text.Trim(); obj1.Guige = this.txt_guige.Text.Trim(); obj1.JiliangUnit = this.cbx_jiliang.Text.Trim(); obj1.Month = this.txt_month.Text.Trim(); builder.Append("insert into tb_setyimiao"); builder.Append("("); builder.Append("yimiaoName"); builder.Append(",productionDay"); builder.Append(",factorName"); builder.Append(",pihao"); builder.Append(",guige"); builder.Append(",jiliangUnit"); builder.Append(",month"); builder.Append(" ) values ( "); builder.Append("'" + obj1.YimiaoName + "'"); builder.Append(",'" + obj1.ProductionDay + "'"); builder.Append(",'" + obj1.FactorName + "'"); builder.Append(",'" + obj1.Pihao + "'"); builder.Append(",'" + obj1.Guige + "'"); builder.Append(",'" + obj1.JiliangUnit + "'"); builder.Append(",'" + obj1.Month + "')"); return(builder.ToString()); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { string sqls = string.Format("select * from tb_setyimiao where id=" + rowId + ""); childSetyimiaoObj obj2 = bll.getyimiaoobj(sqls); if (obj2 == null) { string insertsql = this.getinsertsql(); if (bll.saverecord(insertsql)) { MessageBox.Show("保存成功!", "软件提示"); adddgvList(); } else { MessageBox.Show("保存失败!", "软件提示"); } } else { string updatesql = this.getupdatesql(); if (bll.updaterecord(updatesql) > 0) { MessageBox.Show("保存成功!", "软件提示"); adddgvList(); } else { MessageBox.Show("保存失败!", "软件提示"); } } }
/// <summary> /// 加载数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvyimiao_CellClick(object sender, DataGridViewCellEventArgs e) { rowId = Convert.ToInt32(dgvyimiao.CurrentRow.Cells[7].Value.ToString()); string sqls = string.Format("select * from tb_setyimiao where id=" + rowId + ""); childSetyimiaoObj obj2 = bll.getyimiaoobj(sqls); if (obj2 != null) { this.txt_yimiaoName.Text = obj2.YimiaoName; dtp_production.Value = Convert.ToDateTime(obj2.ProductionDay); this.cbx_factorName.Text = obj2.FactorName; this.txt_pihao.Text = obj2.Pihao; this.txt_guige.Text = obj2.Guige; this.cbx_jiliang.Text = obj2.JiliangUnit; this.txt_month.Text = obj2.Month; } }
/// <summary> /// 查询儿童体检信息 返回集合 /// </summary> /// <param name="sqls"></param> /// <returns></returns> public ArrayList getyimiaoList(string sqls) { DateLogic dg = new DateLogic(); SqlDataReader sdr = null; ArrayList arraylist = new ArrayList();; try { sdr = dg.executequery(sqls); if (!sdr.HasRows) { return(null); } else { while (sdr.Read()) { //sdr.Read();//读取第一行数据记录 childSetyimiaoObj obj = new childSetyimiaoObj(); obj.Id = Convert.ToInt32(sdr["id"]); //obj.ChildId = Convert.ToInt32(sdr["childId"]); obj.YimiaoName = sdr["yimiaoName"].ToString(); obj.FactorName = sdr["factorName"].ToString(); obj.ProductionDay = sdr["productionDay"].ToString(); obj.Pihao = sdr["pihao"].ToString(); obj.Guige = sdr["guige"].ToString(); obj.JiliangUnit = sdr["jiliangUnit"].ToString(); obj.Month = sdr["month"].ToString(); arraylist.Add(obj); } } } catch (Exception ex) { MessageBox.Show("系统异常,请联系管理员", "软件提示"); throw ex; } return(arraylist); }
/// <summary> /// 修改 /// </summary> /// <returns></returns> private string getupdatesql() { StringBuilder builder = new StringBuilder(); childSetyimiaoObj obj1 = new childSetyimiaoObj(); obj1.YimiaoName = this.txt_yimiaoName.Text.Trim(); obj1.ProductionDay = dtp_production.Value.ToString("yyyy-MM-dd"); obj1.FactorName = this.cbx_factorName.Text.Trim(); obj1.Pihao = this.txt_pihao.Text.Trim(); obj1.Guige = this.txt_guige.Text.Trim(); obj1.JiliangUnit = this.cbx_jiliang.Text.Trim(); obj1.Month = this.txt_month.Text.Trim(); builder.Append("update tb_setyimiao set "); builder.Append("yimiaoName = '" + obj1.YimiaoName + "'"); builder.Append(",productionDay = '" + obj1.ProductionDay + "'"); builder.Append(",factorName = '" + obj1.FactorName + "'"); builder.Append(",pihao = '" + obj1.Pihao + "'"); builder.Append(",guige = '" + obj1.Guige + "'"); builder.Append(",jiliangUnit = '" + obj1.JiliangUnit + "'"); builder.Append(",month = '" + obj1.Month + "' where id = " + rowId + ""); return(builder.ToString()); }