private void ShowInfo(int id)
{
Maticsoft.BLL.account bll = new Maticsoft.BLL.account();
Maticsoft.Model.account model = bll.GetModel(id);
Maticsoft.BLL.account_detail ac_d = new BLL.account_detail();
dt_all = ac_d.GetList(500, "", " id desc").Tables[0];
//leibie.SelectedIndex = 1;
leibie.SelectedValue = model.leibei.ToString().Trim();
this.lblid.Text = model.id.ToString();
this.txtname.Text = model.name;
lururen.Text = model.lururen;
lurushijian.Text = model.time.ToString();
this.txtbeizhu.Text = model.beizhu;
this.txtbeizhu2.Text = model.beizhu2;
Maticsoft.BLL.peixunban1 pei_bll = new Maticsoft.BLL.peixunban1();
DataSet ds = new DataSet();
ds = pei_bll.GetList("");
qishu.DataSource = ds;
qishu.DataTextField = "name";
qishu.DataValueField = "id";
qishu.DataBind();
//qishu.SelectedValue = model.peixunban_id.ToString();
if (model.peixunban_id != 0)
{
qishu.Items.FindByValue(model.peixunban_id.ToString()).Selected = true;
}
else
{
qishu.Enabled = false;
}
}
private void ShowInfo(int id)
{
Maticsoft.BLL.account bll = new Maticsoft.BLL.account();
Maticsoft.Model.account model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.lblname.Text = model.name;
this.lblleibei.Text = model.leibei;
this.lbllururen.Text = model.lururen;
this.lbltime.Text = model.time.ToString();
if (model.peixunban_id != 0)
{
Maticsoft.BLL.peixunban1 pei_bll = new BLL.peixunban1();
Maticsoft.Model.peixunban1 pei_mol = new Model.peixunban1();
pei_mol = pei_bll.GetModel(Convert.ToInt16(model.peixunban_id));
this.lblpeixunban_id.Text = pei_mol.name;
}
this.lblbeizhu.Text = model.beizhu;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.account model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update account set ");
strSql.Append("name=@name,");
strSql.Append("leibei=@leibei,");
strSql.Append("lururen=@lururen,");
strSql.Append("time=@time,");
strSql.Append("peixunban_id=@peixunban_id,");
strSql.Append("beizhu=@beizhu,");
strSql.Append("beizhu2=@beizhu2");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NChar, 50),
new SqlParameter("@leibei", SqlDbType.NChar, 10),
new SqlParameter("@lururen", SqlDbType.NChar, 10),
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@peixunban_id", SqlDbType.Int, 4),
new SqlParameter("@beizhu", SqlDbType.NChar, 50),
new SqlParameter("@beizhu2", SqlDbType.NChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.leibei;
parameters[2].Value = model.lururen;
parameters[3].Value = model.time;
parameters[4].Value = model.peixunban_id;
parameters[5].Value = model.beizhu;
parameters[6].Value = model.beizhu2;
parameters[7].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.account DataRowToModel(DataRow row)
{
Maticsoft.Model.account model = new Maticsoft.Model.account();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["leibei"] != null)
{
model.leibei = row["leibei"].ToString();
}
if (row["lururen"] != null)
{
model.lururen = row["lururen"].ToString();
}
if (row["time"] != null && row["time"].ToString() != "")
{
model.time = DateTime.Parse(row["time"].ToString());
}
if (row["peixunban_id"] != null && row["peixunban_id"].ToString() != "")
{
model.peixunban_id = int.Parse(row["peixunban_id"].ToString());
}
if (row["beizhu"] != null)
{
model.beizhu = row["beizhu"].ToString();
}
if (row["beizhu2"] != null)
{
model.beizhu2 = row["beizhu2"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.account model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into account(");
strSql.Append("name,leibei,lururen,time,peixunban_id,beizhu,beizhu2)");
strSql.Append(" values (");
strSql.Append("@name,@leibei,@lururen,@time,@peixunban_id,@beizhu,@beizhu2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NChar, 50),
new SqlParameter("@leibei", SqlDbType.NChar, 10),
new SqlParameter("@lururen", SqlDbType.NChar, 10),
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@peixunban_id", SqlDbType.Int, 4),
new SqlParameter("@beizhu", SqlDbType.NChar, 50),
new SqlParameter("@beizhu2", SqlDbType.NChar, 50)
};
parameters[0].Value = model.name;
parameters[1].Value = model.leibei;
parameters[2].Value = model.lururen;
parameters[3].Value = model.time;
parameters[4].Value = model.peixunban_id;
parameters[5].Value = model.beizhu;
parameters[6].Value = model.beizhu2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.account GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,name,leibei,lururen,time,peixunban_id,beizhu,beizhu2 from account ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Maticsoft.Model.account model = new Maticsoft.Model.account();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtname.Text.Trim().Length == 0)
{
strErr += "name不能为空！\\n";
}
//if(!PageValidate.IsDateTime(txttime.Text))
//{
// strErr+="time格式错误！\\n";
//}
//if(!PageValidate.IsNumber(txtpeixunban_id.Text))
//{
// strErr+="peixunban_id格式错误！\\n";
//}
//if(this.txtbeizhu.Text.Trim().Length==0)
//{
// strErr+="beizhu不能为空！\\n";
//}
//if(this.txtbeizhu2.Text.Trim().Length==0)
//{
// strErr+="beizhu2不能为空！\\n";
//}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int id = int.Parse(this.lblid.Text);
string name = this.txtname.Text;
string txtleibei = leibie.SelectedValue;
//string lururen=this.txtlururen.Text;
//DateTime time=DateTime.Parse(this.txttime.Text);
//int peixunban_id=int.Parse(this.txtpeixunban_id.Text);
string beizhu = this.txtbeizhu.Text;
string beizhu2 = this.txtbeizhu2.Text;
Maticsoft.Model.account model = new Maticsoft.Model.account();
model.id = id;
model.name = name;
model.leibei = txtleibei;
model.lururen = lururen.Text;
model.time = DateTime.Parse(lurushijian.Text);
if (leibie.SelectedValue == "培训班费用")
{
model.peixunban_id = Convert.ToInt16(qishu.SelectedValue);
}
else
{
model.peixunban_id = 0;
}
model.beizhu = beizhu;
model.beizhu2 = beizhu2;
Maticsoft.BLL.account bll = new Maticsoft.BLL.account();
bll.Update(model);
string err = gridview_err();
if (err == "")
{
StringBuilder str = new StringBuilder();
Maticsoft.BLL.account_detail acc_d_bll = new BLL.account_detail();
int i = 0;
foreach (GridViewRow row in GridView1.Rows)
{
TextBox wuzi = (TextBox)row.FindControl("wuzi");
if (wuzi.Text.Trim() != "")
{
Label mingxidanhao = (Label)row.FindControl("mingxidanhao");
TextBox danwei = (TextBox)row.FindControl("danwei");
TextBox danjia = (TextBox)row.FindControl("danjia");
TextBox shuliang = (TextBox)row.FindControl("shuliang");
TextBox beizhu1 = (TextBox)row.FindControl("beizhu");
Maticsoft.Model.account_detail acc_d_mod = new Model.account_detail();
acc_d_mod.wuzi = wuzi.Text.Trim();
acc_d_mod.danwei = danwei.Text.Trim();
acc_d_mod.danjia = Convert.ToDecimal(danjia.Text.Trim());
acc_d_mod.shuliang = Convert.ToInt16(shuliang.Text.Trim());
acc_d_mod.beizhu = beizhu1.Text.Trim();
acc_d_mod.account_id = Convert.ToInt16(lblid.Text);
if (mingxidanhao.Text == "")
{
acc_d_bll.Add(acc_d_mod);
i++;
}
else
{
acc_d_mod.id = Convert.ToInt16(mingxidanhao.Text);
if (acc_d_bll.Update(acc_d_mod))
{
i++;
}
;
}
}
}
string add_str = "list.aspx";
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "共更新了" + i + "条明细", add_str);
}
else
{
MessageBox.Show(this, err);
return;
}
}
