/// <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));
}
}
