/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.account_view model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update account_view set "); strSql.Append("account_id=@account_id,"); strSql.Append("peixunban_id=@peixunban_id,"); strSql.Append("detail_id=@detail_id,"); strSql.Append("peixunban=@peixunban,"); strSql.Append("lururen=@lururen,"); strSql.Append("leibei=@leibei,"); strSql.Append("wuzi=@wuzi,"); strSql.Append("danwei=@danwei,"); strSql.Append("danjia=@danjia,"); strSql.Append("shuliang=@shuliang,"); strSql.Append("xiaoji=@xiaoji,"); strSql.Append("beizhu=@beizhu,"); strSql.Append("time=@time"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@account_id", SqlDbType.Int, 4), new SqlParameter("@peixunban_id", SqlDbType.Int, 4), new SqlParameter("@detail_id", SqlDbType.Int, 4), new SqlParameter("@peixunban", SqlDbType.NChar, 50), new SqlParameter("@lururen", SqlDbType.NChar, 10), new SqlParameter("@leibei", SqlDbType.NChar, 10), new SqlParameter("@wuzi", SqlDbType.NChar, 50), new SqlParameter("@danwei", SqlDbType.NChar, 10), new SqlParameter("@danjia", SqlDbType.Money, 8), new SqlParameter("@shuliang", SqlDbType.Int, 4), new SqlParameter("@xiaoji", SqlDbType.Money, 8), new SqlParameter("@beizhu", SqlDbType.NChar, 50), new SqlParameter("@time", SqlDbType.DateTime) }; parameters[0].Value = model.account_id; parameters[1].Value = model.peixunban_id; parameters[2].Value = model.detail_id; parameters[3].Value = model.peixunban; parameters[4].Value = model.lururen; parameters[5].Value = model.leibei; parameters[6].Value = model.wuzi; parameters[7].Value = model.danwei; parameters[8].Value = model.danjia; parameters[9].Value = model.shuliang; parameters[10].Value = model.xiaoji; parameters[11].Value = model.beizhu; parameters[12].Value = model.time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.account_view DataRowToModel(DataRow row) { Maticsoft.Model.account_view model = new Maticsoft.Model.account_view(); if (row != null) { if (row["account_id"] != null && row["account_id"].ToString() != "") { model.account_id = int.Parse(row["account_id"].ToString()); } if (row["peixunban_id"] != null && row["peixunban_id"].ToString() != "") { model.peixunban_id = int.Parse(row["peixunban_id"].ToString()); } if (row["detail_id"] != null && row["detail_id"].ToString() != "") { model.detail_id = int.Parse(row["detail_id"].ToString()); } if (row["peixunban"] != null) { model.peixunban = row["peixunban"].ToString(); } if (row["lururen"] != null) { model.lururen = row["lururen"].ToString(); } if (row["leibei"] != null) { model.leibei = row["leibei"].ToString(); } if (row["wuzi"] != null) { model.wuzi = row["wuzi"].ToString(); } if (row["danwei"] != null) { model.danwei = row["danwei"].ToString(); } if (row["danjia"] != null && row["danjia"].ToString() != "") { model.danjia = decimal.Parse(row["danjia"].ToString()); } if (row["shuliang"] != null && row["shuliang"].ToString() != "") { model.shuliang = int.Parse(row["shuliang"].ToString()); } if (row["xiaoji"] != null && row["xiaoji"].ToString() != "") { model.xiaoji = decimal.Parse(row["xiaoji"].ToString()); } if (row["beizhu"] != null) { model.beizhu = row["beizhu"].ToString(); } if (row["time"] != null && row["time"].ToString() != "") { model.time = DateTime.Parse(row["time"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.account_view model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into account_view("); strSql.Append("account_id,peixunban_id,detail_id,peixunban,lururen,leibei,wuzi,danwei,danjia,shuliang,xiaoji,beizhu,time)"); strSql.Append(" values ("); strSql.Append("@account_id,@peixunban_id,@detail_id,@peixunban,@lururen,@leibei,@wuzi,@danwei,@danjia,@shuliang,@xiaoji,@beizhu,@time)"); SqlParameter[] parameters = { new SqlParameter("@account_id", SqlDbType.Int, 4), new SqlParameter("@peixunban_id", SqlDbType.Int, 4), new SqlParameter("@detail_id", SqlDbType.Int, 4), new SqlParameter("@peixunban", SqlDbType.NChar, 50), new SqlParameter("@lururen", SqlDbType.NChar, 10), new SqlParameter("@leibei", SqlDbType.NChar, 10), new SqlParameter("@wuzi", SqlDbType.NChar, 50), new SqlParameter("@danwei", SqlDbType.NChar, 10), new SqlParameter("@danjia", SqlDbType.Money, 8), new SqlParameter("@shuliang", SqlDbType.Int, 4), new SqlParameter("@xiaoji", SqlDbType.Money, 8), new SqlParameter("@beizhu", SqlDbType.NChar, 50), new SqlParameter("@time", SqlDbType.DateTime) }; parameters[0].Value = model.account_id; parameters[1].Value = model.peixunban_id; parameters[2].Value = model.detail_id; parameters[3].Value = model.peixunban; parameters[4].Value = model.lururen; parameters[5].Value = model.leibei; parameters[6].Value = model.wuzi; parameters[7].Value = model.danwei; parameters[8].Value = model.danjia; parameters[9].Value = model.shuliang; parameters[10].Value = model.xiaoji; parameters[11].Value = model.beizhu; parameters[12].Value = model.time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.account_view GetModel(int detail_id) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 account_id,peixunban_id,detail_id,peixunban,lururen,leibei,wuzi,danwei,danjia,shuliang,xiaoji,beizhu,time from account_view "); strSql.Append(" where detail_id="); strSql.Append(detail_id); Maticsoft.Model.account_view model = new Maticsoft.Model.account_view(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }