protected void Repeater2_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
string name = e.CommandName.ToString();
if (name == "update")
{
int value = 0;
HtmlInputRadioButton valueInt = (HtmlInputRadioButton)e.Item.FindControl("ropen");
if (valueInt.Checked == true)
{
value = 1;
}
lgk.Model.gp_globeParam item_param = gpBLL.GetModel(id);
if (item_param != null)
{
item_param.ParamInt = value;
if (gpBLL.Update(item_param))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改失败!');", true);
}
}
bindrdo();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.gp_globeParam GetModel(long Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, ParamName, ParamAmount, ParamInt, ParamVarchar, Remark, ParamType, EndRemark, IsEdit ");
strSql.Append(" from gp_globeParam ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.BigInt)
};
parameters[0].Value = Id;
lgk.Model.gp_globeParam model = new lgk.Model.gp_globeParam();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = long.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.ParamName = ds.Tables[0].Rows[0]["ParamName"].ToString();
if (ds.Tables[0].Rows[0]["ParamAmount"].ToString() != "")
{
model.ParamAmount = decimal.Parse(ds.Tables[0].Rows[0]["ParamAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["ParamInt"].ToString() != "")
{
model.ParamInt = int.Parse(ds.Tables[0].Rows[0]["ParamInt"].ToString());
}
model.ParamVarchar = ds.Tables[0].Rows[0]["ParamVarchar"].ToString();
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
if (ds.Tables[0].Rows[0]["ParamType"].ToString() != "")
{
model.ParamType = int.Parse(ds.Tables[0].Rows[0]["ParamType"].ToString());
}
model.EndRemark = ds.Tables[0].Rows[0]["EndRemark"].ToString();
if (ds.Tables[0].Rows[0]["IsEdit"].ToString() != "")
{
model.IsEdit = int.Parse(ds.Tables[0].Rows[0]["IsEdit"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.gp_globeParam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gp_globeParam set ");
strSql.Append(" ParamName = @ParamName , ");
strSql.Append(" ParamAmount = @ParamAmount , ");
strSql.Append(" ParamInt = @ParamInt , ");
strSql.Append(" ParamVarchar = @ParamVarchar , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" ParamType = @ParamType , ");
strSql.Append(" EndRemark = @EndRemark , ");
strSql.Append(" IsEdit = @IsEdit ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.BigInt, 8),
new SqlParameter("@ParamName", SqlDbType.VarChar, 50),
new SqlParameter("@ParamAmount", SqlDbType.Decimal, 9),
new SqlParameter("@ParamInt", SqlDbType.Int, 4),
new SqlParameter("@ParamVarchar", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, -1),
new SqlParameter("@ParamType", SqlDbType.Int, 4),
new SqlParameter("@EndRemark", SqlDbType.VarChar, -1),
new SqlParameter("@IsEdit", SqlDbType.Int, 4)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.ParamName;
parameters[2].Value = model.ParamAmount;
parameters[3].Value = model.ParamInt;
parameters[4].Value = model.ParamVarchar;
parameters[5].Value = model.Remark;
parameters[6].Value = model.ParamType;
parameters[7].Value = model.EndRemark;
parameters[8].Value = model.IsEdit;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.gp_globeParam GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, ParamName, ParamAmount, ParamInt, ParamVarchar, Remark, ParamType, EndRemark, IsEdit ");
strSql.Append(" from gp_globeParam ");
if (strWhere.Trim() == "")
{
strSql.Append(" where " + strWhere);
}
lgk.Model.gp_globeParam model = new lgk.Model.gp_globeParam();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = long.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.ParamName = ds.Tables[0].Rows[0]["ParamName"].ToString();
if (ds.Tables[0].Rows[0]["ParamAmount"].ToString() != "")
{
model.ParamAmount = decimal.Parse(ds.Tables[0].Rows[0]["ParamAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["ParamInt"].ToString() != "")
{
model.ParamInt = int.Parse(ds.Tables[0].Rows[0]["ParamInt"].ToString());
}
model.ParamVarchar = ds.Tables[0].Rows[0]["ParamVarchar"].ToString();
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
if (ds.Tables[0].Rows[0]["ParamType"].ToString() != "")
{
model.ParamType = int.Parse(ds.Tables[0].Rows[0]["ParamType"].ToString());
}
model.EndRemark = ds.Tables[0].Rows[0]["EndRemark"].ToString();
if (ds.Tables[0].Rows[0]["IsEdit"].ToString() != "")
{
model.IsEdit = int.Parse(ds.Tables[0].Rows[0]["IsEdit"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.gp_globeParam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gp_globeParam(");
strSql.Append("ParamName,ParamAmount,ParamInt,ParamVarchar,Remark,ParamType,EndRemark,IsEdit");
strSql.Append(") values (");
strSql.Append("@ParamName,@ParamAmount,@ParamInt,@ParamVarchar,@Remark,@ParamType,@EndRemark,@IsEdit");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParamName", SqlDbType.VarChar, 50),
new SqlParameter("@ParamAmount", SqlDbType.Decimal, 9),
new SqlParameter("@ParamInt", SqlDbType.Int, 4),
new SqlParameter("@ParamVarchar", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.VarChar, -1),
new SqlParameter("@ParamType", SqlDbType.Int, 4),
new SqlParameter("@EndRemark", SqlDbType.VarChar, -1),
new SqlParameter("@IsEdit", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParamName;
parameters[1].Value = model.ParamAmount;
parameters[2].Value = model.ParamInt;
parameters[3].Value = model.ParamVarchar;
parameters[4].Value = model.Remark;
parameters[5].Value = model.ParamType;
parameters[6].Value = model.EndRemark;
parameters[7].Value = model.IsEdit;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
private bool UpdateParam(int id, HtmlInputText valuemoney, out string msg)
{
decimal value = 0;
lgk.Model.gp_globeParam paramInfo = gpBLL.GetModel(id);
if (paramInfo != null)
{
string strRemark = paramInfo.Remark.Replace("</font>", "").Replace("<font color=\"red\">", "").Replace(">", ">");
msg = "更新完成[" + strRemark + "]\\n";
if (valuemoney.Value == "")
{
msg = "请输入参数值[" + strRemark + "]\\n"; return(false);
}
if (paramInfo.ParamType == 1)//Decimal
{
try
{
value = Convert.ToDecimal(valuemoney.Value);
}
catch
{
msg = "参数格式错误[" + strRemark + "]\\n"; return(false);
}
if (value < 0)
{
msg = "请输入大于等于0的参数[" + strRemark + "]\\n"; return(false);
}
}
else if (paramInfo.ParamType == 2)//Int
{
try
{
value = Convert.ToInt32(valuemoney.Value);
}
catch
{
msg = "请输入整数[" + strRemark + "]\\n"; return(false);
}
}
else if (paramInfo.ParamType == 3)//Decimal
{
value = Convert.ToDecimal(valuemoney.Value);
if (value > 100)
{
msg = "比率不能大于100%的参数[" + strRemark + "]\\n"; return(false);
}
}
if (paramInfo.ParamType <= 3)
{
paramInfo.ParamVarchar = value.ToString();
}
else if (paramInfo.ParamType == 4)
{
paramInfo.ParamVarchar = valuemoney.Value;
}
//paramInfo.ParamVarchar = paramInfo.ParamType == 1 ? valuemoney.Value : value.ToString();
if (!gpBLL.Update(paramInfo))
{
msg = "更新出错[" + strRemark + "]\\n";
}
return(false);
}
else
{
msg = "数据不存在，无法更新！";
}
return(true);
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
string name = e.CommandName.ToString();
if (name == "update")
{
decimal value = 0;
HtmlInputText valuemoney = (HtmlInputText)e.Item.FindControl("paramValue");
if (valuemoney.Value == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请输入参数值!');", true);
return;
}
try
{
value = Convert.ToDecimal(valuemoney.Value);
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请输入数字格式参数!');", true);
return;
}
if (value <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请输入大于0的参数!');", true);
return;
}
lgk.Model.gp_globeParam item_param = gpBLL.GetModel(id);
if (item_param != null)
{
if (item_param.ParamType == 1)
{
if (value > 100)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('比率不能大于100%!');", true);
return;
}
}
item_param.ParamAmount = value;
if (item_param.ParamName == "gp_rate")
{
DbHelperSQL.Query("update gp_globeParam set ParamAmount=" + (100 - value) + " where ParamName='hg_rate'");
}
if (item_param.ParamName == "hg_rate")
{
DbHelperSQL.Query("update gp_globeParam set ParamAmount=" + (100 - value) + " where ParamName='gp_rate'");
}
if (gpBLL.Update(item_param))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改失败!');", true);
}
}
bind();
}
}
