/// <summary>
/// 儿童保健对象
/// </summary>
/// <param name="sqls"></param>
/// <returns></returns>
public childSetbaoJiangGuidObj getbaojianobj(string sqls)
{
DateLogic dg = new DateLogic();
SqlDataReader sdr = null;
childSetbaoJiangGuidObj obj = null;
ArrayList arraylist = new ArrayList();;
try
{
sdr = dg.executequery(sqls);
if (!sdr.HasRows)
{
return(null);
}
else
{
obj = new childSetbaoJiangGuidObj();
sdr.Read();//读取第一行数据记录
obj.Id = Convert.ToInt32(sdr["id"]);
//obj.ChildId = Convert.ToInt32(sdr["childId"]);
obj.Setage = sdr["setage"].ToString();
obj.Eduction = sdr["eduction"].ToString();
obj.Shanshi = sdr["shanshi"].ToString();
obj.Jibing = sdr["jibing"].ToString();
obj.Huli = sdr["huli"].ToString();
return(obj);
}
}
catch (Exception ex)
{
MessageBox.Show("系统异常,请联系管理员", "软件提示");
throw ex;
//ErrorHandle.OnError(ex);
}
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
private string getupdatesql()
{
StringBuilder builder = new StringBuilder();
childSetbaoJiangGuidObj obj1 = new childSetbaoJiangGuidObj();
obj1.Eduction = this.txt_eduction.Text.Trim();
obj1.Shanshi = this.txt_shanshi.Text.Trim();
obj1.Jibing = this.txt_jibing.Text.Trim();
obj1.Huli = this.txt_huli.Text.Trim();
builder.Append("update tb_baojianguid set ");
builder.Append("setage='" + obj1.Setage + "',");
builder.Append("eduction = '" + obj1.Eduction + "',");
builder.Append("shanshi='" + obj1.Shanshi + "',");
builder.Append("jibing='" + obj1.Jibing + "',");
builder.Append("huli='" + obj1.Huli + "'");
builder.Append(" where id = " + dgvbaojianguid.CurrentRow.Cells[1].Value.ToString() + "");
return(builder.ToString());
}
/// <summary>
/// 根据每行的Id 加载对应的设置内容
/// </summary>
/// <param name="rowIndex"></param>
/// <param name="type">类型</param>
private void addContent(int rowIndex)
{
string sqls = string.Format("select * from tb_baojianguid where id = " + rowIndex + "");
obj = bll.getbaojianobj(sqls);
if (obj != null)
{
this.txt_eduction.Text = obj.Eduction;
this.txt_shanshi.Text = obj.Shanshi;
this.txt_jibing.Text = obj.Jibing;
this.txt_huli.Text = obj.Huli;
id = obj.Id;
}
else
{
this.txt_eduction.Text = "";
this.txt_shanshi.Text = "";
this.txt_jibing.Text = "";
this.txt_huli.Text = "";
}
}
