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