/// <summary> /// 执行股票拆分存储过程 /// </summary> /// <param name="model">拆分主表实体</param> /// <returns></returns> public bool SplitProcDetail(lgk.Model.tb_StockSplit model) { int result = 0; string prop = "Proc_StockSplitDetail"; SqlParameter[] para = { new SqlParameter("@SplitID", SqlDbType.Int, 4), new SqlParameter("@SplitPriceB", SqlDbType.Decimal, 9), new SqlParameter("@SplitPriceL", SqlDbType.Decimal, 9), new SqlParameter("@SplitTimes", SqlDbType.Int, 4), new SqlParameter("@SplitDate", SqlDbType.DateTime) }; para[0].Value = model.SplitID; para[1].Value = model.SplitPriceB; para[2].Value = model.SplitPriceL; para[3].Value = model.SplitTimes; para[4].Value = model.SplitDate; DbHelperSQL.RunProcedure(prop, para, out result); if (result > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_StockSplit GetModel(long SplitID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SplitID, SplitPrice, SplitPriceB, SplitPriceL, SplitRate, SplitTimes, SplitDate"); strSql.Append(" from tb_StockSplit "); strSql.Append(" where SplitID=@SplitID"); SqlParameter[] parameters = { new SqlParameter("@SplitID", SqlDbType.BigInt, 8) }; parameters[0].Value = SplitID; lgk.Model.tb_StockSplit model = new lgk.Model.tb_StockSplit(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SplitID"].ToString() != "") { model.SplitID = long.Parse(ds.Tables[0].Rows[0]["SplitID"].ToString()); } if (ds.Tables[0].Rows[0]["SplitPrice"].ToString() != "") { model.SplitPrice = decimal.Parse(ds.Tables[0].Rows[0]["SplitPrice"].ToString()); } if (ds.Tables[0].Rows[0]["SplitPriceB"].ToString() != "") { model.SplitPriceB = decimal.Parse(ds.Tables[0].Rows[0]["SplitPriceB"].ToString()); } if (ds.Tables[0].Rows[0]["SplitPriceL"].ToString() != "") { model.SplitPriceL = decimal.Parse(ds.Tables[0].Rows[0]["SplitPriceL"].ToString()); } model.SplitRate = ds.Tables[0].Rows[0]["SplitRate"].ToString(); if (ds.Tables[0].Rows[0]["SplitTimes"].ToString() != "") { model.SplitTimes = int.Parse(ds.Tables[0].Rows[0]["SplitTimes"].ToString()); } if (ds.Tables[0].Rows[0]["SplitDate"].ToString() != "") { model.SplitDate = DateTime.Parse(ds.Tables[0].Rows[0]["SplitDate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_StockSplit GetModel(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SplitID, SplitPrice, SplitPriceB, SplitPriceL, SplitRate, SplitTimes, SplitDate"); strSql.Append(" from tb_StockSplit "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } lgk.Model.tb_StockSplit model = new lgk.Model.tb_StockSplit(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SplitID"].ToString() != "") { model.SplitID = long.Parse(ds.Tables[0].Rows[0]["SplitID"].ToString()); } if (ds.Tables[0].Rows[0]["SplitPrice"].ToString() != "") { model.SplitPrice = decimal.Parse(ds.Tables[0].Rows[0]["SplitPrice"].ToString()); } if (ds.Tables[0].Rows[0]["SplitPriceB"].ToString() != "") { model.SplitPriceB = decimal.Parse(ds.Tables[0].Rows[0]["SplitPriceB"].ToString()); } if (ds.Tables[0].Rows[0]["SplitPriceL"].ToString() != "") { model.SplitPriceL = decimal.Parse(ds.Tables[0].Rows[0]["SplitPriceL"].ToString()); } model.SplitRate = ds.Tables[0].Rows[0]["SplitRate"].ToString(); if (ds.Tables[0].Rows[0]["SplitTimes"].ToString() != "") { model.SplitTimes = int.Parse(ds.Tables[0].Rows[0]["SplitTimes"].ToString()); } if (ds.Tables[0].Rows[0]["SplitDate"].ToString() != "") { model.SplitDate = DateTime.Parse(ds.Tables[0].Rows[0]["SplitDate"].ToString()); } return(model); } else { return(null); } }
protected void lbtnSubmit_Click(object sender, EventArgs e) { decimal dSplitPriceL = getParamAmount("Shares2"); //原始股价 decimal dSplitPriceB = getParamAmount("Shares3"); //当前股价 decimal dSplitPrice = getParamAmount("Shares6"); //股票拆分价格(系统拆分价格) lgk.Model.tb_StockSplit model = new lgk.Model.tb_StockSplit(); model.SplitPrice = dSplitPrice; model.SplitPriceB = dSplitPriceB; model.SplitPriceL = dSplitPriceL; model.SplitRate = "1:" + getParamVarchar("Shares9").Trim(); model.SplitTimes = Convert.ToInt32(getParamAmount("shares8") + 1); model.SplitDate = DateTime.Now; if (getParamInt("Shares") == 1) { MessageBox.MyShow(this, "请将参数设置中的[MDD金币设置>>是否开启]改成0再拆分!"); return; } if (stockIssueBLL.GetSurplusAmount() > 0 || stockorderBLL.GetSurplusAmount() > 0) { MessageBox.MyShow(this, "MDD金币未销售完,不能拆分!"); return; } if (dSplitPriceB == dSplitPrice) { model.SplitID = stockSplitBLL.Add(model); if (model.SplitID > 1) { stockSplitDetailBLL.SplitProcDetail(model); UpdateParamVarchar("ParamVarchar", model.SplitTimes.ToString(), "Shares8"); //将发行期数更新成1。 ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('拆分成功!');window.location.href='SplitStock.aspx';", true); //股票拆分成功 BindData(); } } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('当前MDD金币价必须等于MDD金币拆分价格才能拆分!');", true); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_StockSplit model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_StockSplit set "); strSql.Append(" SplitPrice = @SplitPrice,"); strSql.Append(" SplitPriceB = @SplitPriceB,"); strSql.Append(" SplitPriceL = @SplitPriceL,"); strSql.Append(" SplitRate = @SplitRate,"); strSql.Append(" SplitTimes = @SplitTimes,"); strSql.Append(" SplitDate = @SplitDate "); strSql.Append(" where SplitID=@SplitID "); SqlParameter[] parameters = { new SqlParameter("@SplitID", SqlDbType.BigInt, 8), new SqlParameter("@SplitPrice", SqlDbType.Decimal, 9), new SqlParameter("@SplitPriceB", SqlDbType.Decimal, 9), new SqlParameter("@SplitPriceL", SqlDbType.Decimal, 9), new SqlParameter("@SplitRate", SqlDbType.VarChar, 50), new SqlParameter("@SplitTimes", SqlDbType.Int, 4), new SqlParameter("@SplitDate", SqlDbType.DateTime) }; parameters[0].Value = model.SplitID; parameters[1].Value = model.SplitPrice; parameters[2].Value = model.SplitPriceB; parameters[3].Value = model.SplitPriceL; parameters[4].Value = model.SplitRate; parameters[5].Value = model.SplitTimes; parameters[6].Value = model.SplitDate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(lgk.Model.tb_StockSplit model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_StockSplit("); strSql.Append("SplitPrice,SplitPriceB,SplitPriceL,SplitRate,SplitTimes,SplitDate"); strSql.Append(") values ("); strSql.Append("@SplitPrice,@SplitPriceB,@SplitPriceL,@SplitRate,@SplitTimes,@SplitDate"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SplitPrice", SqlDbType.Decimal, 9), new SqlParameter("@SplitPriceB", SqlDbType.Decimal, 9), new SqlParameter("@SplitPriceL", SqlDbType.Decimal, 9), new SqlParameter("@SplitRate", SqlDbType.VarChar, 50), new SqlParameter("@SplitTimes", SqlDbType.Int, 4), new SqlParameter("@SplitDate", SqlDbType.DateTime) }; parameters[0].Value = model.SplitPrice; parameters[1].Value = model.SplitPriceB; parameters[2].Value = model.SplitPriceL; parameters[3].Value = model.SplitRate; parameters[4].Value = model.SplitTimes; parameters[5].Value = model.SplitDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }