/// <summary> /// 得到一个对象实体 /// </summary> public Model.s_stock_codeInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, stock_code, stock_name, stock_name_capital, rd_decl, rd_deal, rd_num, rd_money, rd_txt, remark, input_time "); strSql.Append(" from sys_stock_code "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; Model.s_stock_codeInfo model = new Model.s_stock_codeInfo(); DataSet ds = DbHelperMySQL.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(Model.s_stock_codeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sys_stock_code set "); strSql.Append(" stock_code = @stock_code , "); strSql.Append(" stock_name = @stock_name , "); strSql.Append(" stock_name_capital = @stock_name_capital , "); strSql.Append(" rd_decl = @rd_decl , "); strSql.Append(" rd_deal = @rd_deal , "); strSql.Append(" rd_num = @rd_num , "); strSql.Append(" rd_money = @rd_money , "); strSql.Append(" rd_txt = @rd_txt , "); strSql.Append(" remark = @remark , "); strSql.Append(" input_time = @input_time "); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@stock_code", MySqlDbType.VarChar, 8), new MySqlParameter("@stock_name", MySqlDbType.VarChar, 8), new MySqlParameter("@stock_name_capital", MySqlDbType.VarChar, 8), new MySqlParameter("@rd_decl", MySqlDbType.DateTime), new MySqlParameter("@rd_deal", MySqlDbType.DateTime), new MySqlParameter("@rd_num", MySqlDbType.Decimal, 12), new MySqlParameter("@rd_money", MySqlDbType.Decimal, 12), new MySqlParameter("@rd_txt", MySqlDbType.VarChar, 64), new MySqlParameter("@remark", MySqlDbType.VarChar, 128), new MySqlParameter("@input_time", MySqlDbType.DateTime), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.stock_code; parameters[1].Value = model.stock_name; parameters[2].Value = model.stock_name_capital; parameters[3].Value = model.rd_decl; parameters[4].Value = model.rd_deal; parameters[5].Value = model.rd_num; parameters[6].Value = model.rd_money; parameters[7].Value = model.rd_txt; parameters[8].Value = model.remark; parameters[9].Value = model.input_time; parameters[10].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.s_stock_codeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_stock_code("); strSql.Append("stock_code,stock_name,stock_name_capital,rd_decl,rd_deal,rd_num,rd_money,rd_txt,remark,input_time"); strSql.Append(") values ("); strSql.Append("@stock_code,@stock_name,@stock_name_capital,@rd_decl,@rd_deal,@rd_num,@rd_money,@rd_txt,@remark,@input_time"); strSql.Append("); Select LAST_INSERT_ID() "); MySqlParameter[] parameters = { new MySqlParameter("@stock_code", MySqlDbType.VarChar, 8), new MySqlParameter("@stock_name", MySqlDbType.VarChar, 8), new MySqlParameter("@stock_name_capital", MySqlDbType.VarChar, 8), new MySqlParameter("@rd_decl", MySqlDbType.DateTime), new MySqlParameter("@rd_deal", MySqlDbType.DateTime), new MySqlParameter("@rd_num", MySqlDbType.Decimal, 12), new MySqlParameter("@rd_money", MySqlDbType.Decimal, 12), new MySqlParameter("@rd_txt", MySqlDbType.VarChar, 64), new MySqlParameter("@remark", MySqlDbType.VarChar, 128), new MySqlParameter("@input_time", MySqlDbType.DateTime) }; parameters[0].Value = model.stock_code; parameters[1].Value = model.stock_name; parameters[2].Value = model.stock_name_capital; parameters[3].Value = model.rd_decl; parameters[4].Value = model.rd_deal; parameters[5].Value = model.rd_num; parameters[6].Value = model.rd_money; parameters[7].Value = model.rd_txt; parameters[8].Value = model.remark; parameters[9].Value = model.input_time; int rows = Convert.ToInt32(DbHelperMySQL.GetSingle(strSql.ToString(), parameters)); return(rows); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.s_stock_codeInfo GetModel(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, stock_code, stock_name, stock_name_capital, rd_decl, rd_deal, rd_num, rd_money, rd_txt, remark, input_time "); strSql.Append(" from sys_stock_code "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" limit 0,1"); Model.s_stock_codeInfo model = new Model.s_stock_codeInfo(); DataSet ds = DbHelperMySQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 将对象转换为实体 /// </summary> public Model.s_stock_codeInfo DataRowToModel(DataRow row) { Model.s_stock_codeInfo model = new Model.s_stock_codeInfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } model.stock_code = row["stock_code"].ToString(); model.stock_name = row["stock_name"].ToString(); model.stock_name_capital = row["stock_name_capital"].ToString(); if (row["rd_decl"] != null && row["rd_decl"].ToString() != "") { model.rd_decl = DateTime.Parse(row["rd_decl"].ToString()); } if (row["rd_deal"] != null && row["rd_deal"].ToString() != "") { model.rd_deal = DateTime.Parse(row["rd_deal"].ToString()); } if (row["rd_num"] != null && row["rd_num"].ToString() != "") { model.rd_num = decimal.Parse(row["rd_num"].ToString()); } if (row["rd_money"] != null && row["rd_money"].ToString() != "") { model.rd_money = decimal.Parse(row["rd_money"].ToString()); } model.rd_txt = row["rd_txt"].ToString(); model.remark = row["remark"].ToString(); if (row["input_time"] != null && row["input_time"].ToString() != "") { model.input_time = DateTime.Parse(row["input_time"].ToString()); } } return(model); }