//保存
private string getinsertsql(int type)
{
StringBuilder builder = new StringBuilder();
childSetNutritionguidObj obj1 = new childSetNutritionguidObj();
if (type == 1)
{
obj1.SetAge = dgvNutrition.CurrentRow.Cells[0].Value.ToString();
obj1.SetContent = this.txt_shiyingxing.Text.Trim();
}
else if (type == 2)
{
obj1.SetAge = dgvNutrition.CurrentRow.Cells[0].Value.ToString();
obj1.SetContent = this.txt_big.Text.Trim();
}
obj1.Type = type;
builder.Append("insert into tb_nutritionguid (");
builder.Append("setAge,");
builder.Append("shiyongxing,");
builder.Append("bigdongzuo,");
builder.Append("type ");
builder.Append(") values (");
builder.Append("'" + obj1.SetAge + "',");
builder.Append("'" + obj1.Shiyongxing + "',");
builder.Append("'" + obj1.Bigdongzuo + "',");
builder.Append("'" + obj1.Type + "' )");
return(builder.ToString());
}
public childSetNutritionguidObj getNutritionguidobj(string sqls)
{
DateLogic dg = new DateLogic();
SqlDataReader sdr = null;
childSetNutritionguidObj obj = null;
ArrayList arraylist = new ArrayList();;
try
{
sdr = dg.executequery(sqls);
if (!sdr.HasRows)
{
return(null);
}
else
{
obj = new childSetNutritionguidObj();
sdr.Read(); //读取第一行数据记录
obj.Id = Convert.ToInt32(sdr["id"]);
//obj.ChildId = Convert.ToInt32(sdr["childId"]);
obj.SetAge = sdr["setAge"].ToString();
//obj.SetContent = sdr["setContent"].ToString();
obj.Shiyongxing = sdr["shiyongxing"].ToString();
obj.Bigdongzuo = sdr["bigdongzuo"].ToString();
//obj.TYPE =Convert.ToInt32(sdr["type"]);
return(obj);
}
}
catch (Exception ex)
{
MessageBox.Show("系统异常,请联系管理员", "软件提示");
throw ex;
}
}
/// <summary>
/// 查询儿童体检信息 返回集合
/// </summary>
/// <param name="sqls"></param>
/// <returns></returns>
public ArrayList getNutritionguidList(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();//读取第一行数据记录
childSetNutritionguidObj obj = new childSetNutritionguidObj();
obj.Id = Convert.ToInt32(sdr["id"]);
//obj.ChildId = Convert.ToInt32(sdr["childId"]);
obj.SetAge = sdr["setAge"].ToString();
arraylist.Add(obj);
}
}
}
catch (Exception ex)
{
MessageBox.Show("系统异常,请联系管理员", "软件提示");
throw ex;
}
return(arraylist);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private string getupdatesql()
{
StringBuilder builder = new StringBuilder();
childSetNutritionguidObj obj1 = new childSetNutritionguidObj();
obj1.SetAge = dgvNutrition.CurrentRow.Cells[0].Value.ToString();
obj1.Shiyongxing = this.txt_shiyingxing.Text.Trim();
obj1.Bigdongzuo = this.txt_big.Text.Trim();
builder.Append("update tb_nutritionguid set ");
builder.Append("setAge='" + obj1.SetAge + "',");
builder.Append("shiyongxing='" + obj1.Shiyongxing + "',");
builder.Append("bigdongzuo='" + obj1.Bigdongzuo + "' ");
builder.Append(" where id = " + id + "");
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_nutritionguid where id = " + rowIndex + "");
obj = bll.getNutritionguidobj(sqls);
if (obj != null)
{
this.txt_shiyingxing.Text = obj.Shiyongxing;
this.txt_big.Text = obj.Bigdongzuo;
id = obj.Id;
}
else
{
this.txt_shiyingxing.Text = "";
this.txt_big.Text = "";
}
}