/// <summary> /// 更新一条数据 /// </summary> public bool Update(MDD_accountsM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MDD_accounts set "); strSql.Append("Context=@Context,"); strSql.Append("money=@money,"); strSql.Append("Type=@Type,"); strSql.Append("turnover=@turnover,"); strSql.Append("remark=@remark,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where Acc_Id=@Acc_Id "); SqlParameter[] parameters = { new SqlParameter("@Context", SqlDbType.VarChar, 200), new SqlParameter("@money", SqlDbType.Decimal, 5), new SqlParameter("@Type", SqlDbType.VarChar, 50), new SqlParameter("@turnover", SqlDbType.VarChar, 50), new SqlParameter("@remark", SqlDbType.VarChar, 500), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Acc_Id", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Context; parameters[1].Value = model.money; parameters[2].Value = model.Type; parameters[3].Value = model.turnover; parameters[4].Value = model.remark; parameters[5].Value = model.CreateTime; parameters[6].Value = model.Acc_Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MDD_accountsM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MDD_accounts("); strSql.Append("Acc_Id,Context,money,Type,turnover,remark,CreateTime)"); strSql.Append(" values ("); strSql.Append("@Acc_Id,@Context,@money,@Type,@turnover,@remark,@CreateTime)"); SqlParameter[] parameters = { new SqlParameter("@Acc_Id", SqlDbType.VarChar, 50), new SqlParameter("@Context", SqlDbType.VarChar, 200), new SqlParameter("@money", SqlDbType.Decimal, 5), new SqlParameter("@Type", SqlDbType.VarChar, 50), new SqlParameter("@turnover", SqlDbType.VarChar, 50), new SqlParameter("@remark", SqlDbType.VarChar, 500), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.Acc_Id; parameters[1].Value = model.Context; parameters[2].Value = model.money; parameters[3].Value = model.Type; parameters[4].Value = model.turnover; parameters[5].Value = model.remark; parameters[6].Value = model.CreateTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MDD_accountsM DataRowToModel(DataRow row) { MDD_accountsM model = new MDD_accountsM(); if (row != null) { if (row["Acc_Id"] != null) { model.Acc_Id = row["Acc_Id"].ToString(); } if (row["Context"] != null) { model.Context = row["Context"].ToString(); } if (row["money"] != null && row["money"].ToString() != "") { model.money = decimal.Parse(row["money"].ToString()); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["turnover"] != null) { model.turnover = row["turnover"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public MDD_accountsM GetModel(string Acc_Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Acc_Id,Context,money,Type,turnover,remark,CreateTime from MDD_accounts "); strSql.Append(" where Acc_Id=@Acc_Id "); SqlParameter[] parameters = { new SqlParameter("@Acc_Id", SqlDbType.VarChar, 50) }; parameters[0].Value = Acc_Id; MDD_accountsM model = new MDD_accountsM(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MDD_accountsM model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MDD_accountsM model) { return(dal.Add(model)); }