/// <summary>
/// 修改记录
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="p">要修改的字段（参数值），数组的第一个值作为主键条件</param>
/// <returns></returns>
public static int UpdateData(string tableName, SqlParameter[] p)
{
if (p == null || p.Length == 0 || string.IsNullOrEmpty(tableName))
{
return(0);
}
string strSql = "update " + tableName + " set ";
string key = p[0].ParameterName;
string pName = "";
for (int i = 1; i < p.Length; i++)
{
pName = p[i].ParameterName;
strSql += pName.Substring(1) + "=" + pName + ",";
}
strSql = strSql.TrimEnd(new char[] { ',' });
strSql += " where " + key.Substring(1) + "=" + key;
try
{
return(ado.ExecuteSqlNonQuery(strSql, p));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ModMenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into IACenter_Menu(");
strSql.Append("menuName,menuTarget,parentMenuId,orderIndex,isShow)");
strSql.Append(" values (");
strSql.Append("@menuName,@menuTarget,@parentMenuId,@orderIndex,@isShow)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@menuName", SqlDbType.VarChar, 50),
new SqlParameter("@menuTarget", SqlDbType.VarChar, 500),
new SqlParameter("@parentMenuId", SqlDbType.Int, 4),
new SqlParameter("@orderIndex", SqlDbType.Int, 4),
new SqlParameter("@isShow", SqlDbType.Int, 4)
};
parameters[0].Value = model.menuName;
parameters[1].Value = model.menuTarget;
parameters[2].Value = model.parentMenuId;
parameters[3].Value = model.orderIndex;
parameters[4].Value = model.isShow;
adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(GoodsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Goods_Service(");
strSql.Append("serviceId,serviceName,serviceContext,orderby,remark)");
strSql.Append(" values (");
strSql.Append("@serviceId,@serviceName,@serviceContext,@orderby,@remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@serviceId", SqlDbType.VarChar, 50),
new SqlParameter("@serviceName", SqlDbType.VarChar, 50),
new SqlParameter("@serviceContext", SqlDbType.VarChar, 100),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.serviceId;
parameters[1].Value = model.serviceName;
parameters[2].Value = model.serviceContext;
parameters[3].Value = model.orderby;
parameters[4].Value = model.remark;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if ((decimal.Parse(lbMoney.Text) > decimal.Parse(lbYE.Text)) && ddlIfDeal.SelectedValue == "1")
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('余额不足');location.href=location.href;</script>");
return;
}
string sql = "update T_Member_ApplayCashBank set DealAdmin='" + this.UserName + "',DealTime=getdate(), IfDeal=" + ddlIfDeal.SelectedValue + ",DealRemarks='" + lbDealRemarks.Text.Replace("'", "’") + "' where sysnumber='" + id + "'";
if (this.ddlIfDeal.SelectedValue == "0")
{
sql = "update T_Member_ApplayCashBank set DealAdmin='" + this.UserName + "',DealTime=getdate(),DealRemarks='" + lbDealRemarks.Text.Replace("'", "’") + "' where sysnumber='" + id + "'";
}
adoHelper.ExecuteSqlNonQuery(sql);
if (this.ddlIfDeal.SelectedValue == "-1")
{
//电子钱包记录
MoneyBagTools.DelMoneyBagDetail(ViewState["MemberId"].ToString(), id);
Common.AddLogMsg(ViewState["MemberId"].ToString(), "提现审核失败", lbDealRemarks.Text.Replace("'", "’"), "#", 0);
}
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('提交成功');location.href=location.href;</script>");
}
/// <summary>
/// 创建用户提现、收入明细数据（提现：xf，收入：cz）,fromsourceid数据写入源编号
/// </summary>
/// <param name="memberId"></param>
/// <param name="moeny"></param>
/// <param name="type"></param>
/// <returns></returns>
public static int CreateMoneyBagDetail(string memberId, decimal moeny, string type, string fromsourceid)
{
AdoHelper ado = AdoHelper.CreateHelper(Startech.Utils.AppConfig.DBInstance);
object obj = ado.ExecuteSqlScalar("select account_id from T_Moneybag_AccountInfo where member_id='" + memberId + "'");
string account_id = obj == null ? "" : obj.ToString();
if (account_id == "")
{
//create
account_id = Guid.NewGuid().ToString();
string sqla = "INSERT INTO [T_Moneybag_AccountInfo]([account_id],[account_money],[account_state],[member_id],[createtime]) ";
sqla += " VALUES('" + account_id + "',0,'Normal','" + memberId + "',getdate())";
ado.ExecuteSqlNonQuery(sqla);
}
string sql = "INSERT INTO [T_Moneybag_AccountDetail]([detail_id],[account_id],[detail_type],[money],[from_source_id],[createtime])";
sql += " VALUES('" + Guid.NewGuid().ToString() + "','" + account_id + "','" + type + "'," + moeny + ",'" + fromsourceid + "',getdate())";
if (ado.ExecuteSqlNonQuery(sql) > 0)
{
//update total
ado.ExecuteSqlNonQuery("update T_Moneybag_AccountInfo set account_money=(select isnull(sum(money),0) from T_Moneybag_AccountDetail where account_id='" + account_id + "')");
}
return(1);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FlagModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Base_Flag(");
strSql.Append("flag_id,flag_name,if_use)");
strSql.Append(" values (");
strSql.Append("@flag_id,@flag_name,@if_use)");
SqlParameter[] parameters =
{
new SqlParameter("@flag_id", SqlDbType.NVarChar, 50),
new SqlParameter("@flag_name", SqlDbType.NVarChar, 100),
new SqlParameter("@if_use", SqlDbType.Int, 4)
};
parameters[0].Value = model.flag_id;
parameters[1].Value = model.flag_name;
parameters[2].Value = model.if_use;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 确定提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
model = GetModel();
if (_Pid != "SysError")
{
if (!_Pid.Equals(model.area_id))
{
bll.UpdateId(model.area_id, _Pid); //先更新编号
}
if (bll.Update(model))
{
adohelper.ExecuteSqlNonQuery("update T_Base_Area set ishot=" + (this.cbHot.Checked ? "1" : "0") + " where area_id='" + model.area_id + "'");
this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>");
}
}
else
{
model.area_id = IdCreator.CreateId("T_Base_Area", "area_id");
if (bll.Add(model))
{
adohelper.ExecuteSqlNonQuery("update T_Base_Area set ishot=" + (this.cbHot.Checked ? "1" : "0") + " where area_id='" + model.area_id + "'");
JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString());
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GoodsFormateModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Goods_Formate(");
strSql.Append("sysnumber,GoodsId,GoodsCode,GoodsFormateNames,GoodsFormateValues,Price,Stock,vipPrice1,vipPrice2,postage)");
strSql.Append(" values (");
strSql.Append("@sysnumber,@GoodsId,@GoodsCode,@GoodsFormateNames,@GoodsFormateValues,@Price,@Stock,@vipPrice1,@vipPrice2,@postage)");
SqlParameter[] parameters =
{
new SqlParameter("@sysnumber", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsCode", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsFormateNames", SqlDbType.NVarChar, 500),
new SqlParameter("@GoodsFormateValues", SqlDbType.VarChar, 500),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Stock", SqlDbType.Int, 4),
new SqlParameter("@vipPrice1", SqlDbType.Decimal, 18),
new SqlParameter("@vipPrice2", SqlDbType.Decimal, 18),
new SqlParameter("@postage", SqlDbType.Decimal, 18)
};
parameters[0].Value = model.sysnumber;
parameters[1].Value = model.GoodsId;
parameters[2].Value = model.GoodsCode;
parameters[3].Value = model.GoodsFormateNames;
parameters[4].Value = model.GoodsFormateValues;
parameters[5].Value = model.Price;
parameters[6].Value = model.Stock;
parameters[7].Value = model.vipPrice1;
parameters[8].Value = model.vipPrice2;
parameters[9].Value = model.Postage;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(AreaModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Base_Area(");
strSql.Append("area_id,area_name,area_pid,area_level,orderby)");
strSql.Append(" values (");
strSql.Append("@area_id,@area_name,@area_pid,@area_level,@orderby)");
SqlParameter[] parameters =
{
new SqlParameter("@area_id", SqlDbType.VarChar, 50),
new SqlParameter("@area_name", SqlDbType.VarChar, 200),
new SqlParameter("@area_pid", SqlDbType.VarChar, 50),
new SqlParameter("@area_level", SqlDbType.Int, 4),
new SqlParameter("@orderby", SqlDbType.Int, 4)
};
parameters[0].Value = model.area_id;
parameters[1].Value = model.area_name;
parameters[2].Value = model.area_pid;
parameters[3].Value = model.area_level;
parameters[4].Value = model.orderby;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Goods_ServiceDetailModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Goods_ServiceDetail(");
strSql.Append("sysnumber,serviceId,value,Price,Remark,isDefault)");
strSql.Append(" values (");
strSql.Append("@sysnumber,@serviceId,@value,@Price,@Remark,@isDefault)");
SqlParameter[] parameters =
{
new SqlParameter("@sysnumber", SqlDbType.VarChar, 50),
new SqlParameter("@serviceId", SqlDbType.VarChar, 50),
new SqlParameter("@value", SqlDbType.VarChar, 50),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@isDefault", SqlDbType.Int, 4)
};
parameters[0].Value = model.sysnumber;
parameters[1].Value = model.serviceId;
parameters[2].Value = model.value;
parameters[3].Value = model.Price;
parameters[4].Value = model.Remark;
parameters[5].Value = model.IsDefault;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MorePropertyConfigSetModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Goods_MorePropertySet(");
strSql.Append("propertyId,tableName,moreFiledName,propertyName,porpertyFlag,propertyOptions,orderBy,remarks)");
strSql.Append(" values (");
strSql.Append("@propertyId,@tableName,@moreFiledName,@propertyName,@porpertyFlag,@propertyOptions,@orderBy,@remarks)");
SqlParameter[] parameters =
{
new SqlParameter("@propertyId", SqlDbType.VarChar, 50),
new SqlParameter("@tableName", SqlDbType.VarChar, 50),
new SqlParameter("@moreFiledName", SqlDbType.VarChar, 50),
new SqlParameter("@propertyName", SqlDbType.VarChar, 50),
new SqlParameter("@porpertyFlag", SqlDbType.VarChar, 50),
new SqlParameter("@propertyOptions", SqlDbType.VarChar, 2000),
new SqlParameter("@orderBy", SqlDbType.Int, 4),
new SqlParameter("@remarks", SqlDbType.VarChar, 2000)
};
parameters[0].Value = model.propertyId;
parameters[1].Value = model.tableName;
parameters[2].Value = model.moreFiledName;
parameters[3].Value = model.propertyName;
parameters[4].Value = model.porpertyFlag;
parameters[5].Value = model.propertyOptions;
parameters[6].Value = model.orderBy;
parameters[7].Value = model.remarks;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
public static string CreateId(string tableName, string fieldName)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(Startech.Utils.AppConfig.DBInstance);
DataTable dt = adoHelper.ExecuteSqlDataset("select * from T_System_IdCreator where tableName='" + tableName + "' and fieldName='" + fieldName + "'").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["flag"].ToString().ToUpper() == "TIME_RANDOM_RESET")
{
System.Threading.Thread.Sleep(50);
int idValue = Int32.Parse(dt.Rows[0]["currentIdValue"].ToString()) + 1;
if (idValue < 99)
{
adoHelper.ExecuteSqlNonQuery("update T_System_IdCreator set currentIdValue=" + idValue + " where tableName='" + tableName + "' and fieldName='" + fieldName + "' ");
}
else
{
adoHelper.ExecuteSqlNonQuery("update T_System_IdCreator set currentIdValue=10 where tableName='" + tableName + "' and fieldName='" + fieldName + "' ");
}
return(DateTime.Now.ToString("yyMMddHHmmss") + new Random().Next(1000, 9999).ToString() + idValue);
}
else
{
int idValue = Int32.Parse(dt.Rows[0]["currentIdValue"].ToString()) + 1;
adoHelper.ExecuteSqlNonQuery("update T_System_IdCreator set currentIdValue=" + idValue + " where tableName='" + tableName + "' and fieldName='" + fieldName + "' ");
return(dt.Rows[0]["flag"].ToString() + idValue);
}
}
else
{
return("");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModStamp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into N_Stamp(");
strSql.Append("StampNo,Password,IsUsed,StampMoney,StampOutTime,StampType,AddTime)");
strSql.Append(" values (");
strSql.Append("@StampNo,@Password,@IsUsed,@StampMoney,@StampOutTime,@StampType,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StampNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
new SqlParameter("@IsUsed", SqlDbType.Int, 4),
new SqlParameter("@StampMoney", SqlDbType.Int, 4),
new SqlParameter("@StampOutTime", SqlDbType.DateTime),
new SqlParameter("@StampType", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.StampNo;
parameters[1].Value = model.Password;
parameters[2].Value = model.IsUsed;
parameters[3].Value = model.StampMoney;
parameters[4].Value = model.StampOutTime;
parameters[5].Value = model.StampType;
parameters[6].Value = model.AddTime;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MarketModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Base_Market(");
strSql.Append("Market_id,Market_name,Area_id,Map_x,Map_y,orderby)");
strSql.Append(" values (");
strSql.Append("@Market_id,@Market_name,@Area_id,@Map_x,@Map_y,@orderby)");
SqlParameter[] parameters =
{
new SqlParameter("@Market_id", SqlDbType.VarChar, 50),
new SqlParameter("@Market_name", SqlDbType.VarChar, 200),
new SqlParameter("@Area_id", SqlDbType.VarChar, 50),
new SqlParameter("@Map_x", SqlDbType.VarChar, 100),
new SqlParameter("@Map_y", SqlDbType.VarChar, 100),
new SqlParameter("@orderby", SqlDbType.Int, 4)
};
parameters[0].Value = model.Market_id;
parameters[1].Value = model.Market_name;
parameters[2].Value = model.Area_id;
parameters[3].Value = model.Map_x;
parameters[4].Value = model.Map_y;
parameters[5].Value = model.orderby;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <SqlParameter> p = new List <SqlParameter>();
p.Add(new SqlParameter("@node_sn", node_sn.Value));
p.Add(new SqlParameter("@node_name", node_name.Value));
p.Add(new SqlParameter("@yb_value", yb_value.Value));
p.Add(new SqlParameter("@jyz_value_set", jyz_value_set.Value));
p.Add(new SqlParameter("@cs_value_set", cs_value_set.Value));
p.Add(new SqlParameter("@rq_value_set", rq_value_set.Value));
p.Add(new SqlParameter("@node_para", node_para.Value));
p.Add(new SqlParameter("@remarks", remarks.Value));
p.Add(new SqlParameter("@if_use", if_use.SelectedValue));
if (string.IsNullOrWhiteSpace(node_id.Value))
{
string id = IdCreator.CreateId("t_task_node_config", "node_id");
//add
p.Add(new SqlParameter("@node_id", id));
p.Add(new SqlParameter("@node_code", "cd" + new Random().Next(1000, 9999)));
p.Add(new SqlParameter("@task_id", task_id.Value));
string sql = "insert into t_task_node_config(node_id,task_id,node_code,node_sn,node_name,node_para,remarks,if_use) values(@node_id,@task_id,@node_code,@node_sn,@node_name,@node_para,@remarks,@if_use);";
int result = ado.ExecuteSqlNonQuery(sql, p.ToArray());
if (result == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增成功');layer_close_refresh();</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增失败');</script>");
}
}
else
{
//update
p.Add(new SqlParameter("@node_id", node_id.Value));
string sql = "update t_task_node_config set node_sn=@node_sn,node_name=@node_name,node_para=@node_para,remarks=@remarks,if_use=@if_use where node_id=@node_id;";
int result = ado.ExecuteSqlNonQuery(sql, p.ToArray());
if (result == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改失败');</script>");
}
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('提交失败');</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
List <SqlParameter> p = new List <SqlParameter>();
p.Add(new SqlParameter("@activity_title", activity_title.Value));
p.Add(new SqlParameter("@activity_desc", activity_desc.Value));
p.Add(new SqlParameter("@activity_status", activity_status.SelectedValue));
p.Add(new SqlParameter("@remarks", remarks.Value));
p.Add(new SqlParameter("@if_approved", if_approved.SelectedValue));
p.Add(new SqlParameter("@manager_id", manager_id.Value));
p.Add(new SqlParameter("@job_ids", job_ids.Value));
p.Add(new SqlParameter("@activity_person", activity_person.Value));
if (string.IsNullOrWhiteSpace(activity_id.Value))
{
string id = IdCreator.CreateId("t_activity_info", "activity_id");
//add
p.Add(new SqlParameter("@activity_id", id));
p.Add(new SqlParameter("@create_time", DateTime.Now));
p.Add(new SqlParameter("@create_person", this.TrueName));
string sql = "insert into t_activity_info(activity_id,activity_title,activity_desc,activity_status,create_time,create_person,if_approved,manager_id,job_ids,activity_person,remarks) values(@activity_id,@activity_title,@activity_desc,@activity_status,@create_time,@create_person,@if_approved,@manager_id,@job_ids,@activity_person,@remarks);";
int result = ado.ExecuteSqlNonQuery(sql, p.ToArray());
if (result == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增成功');layer_close_refresh();</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增失败');</script>");
}
}
else
{
//update
p.Add(new SqlParameter("@activity_id", activity_id.Value));
string sql = "update t_activity_info set activity_title=@activity_title,activity_desc=@activity_desc,activity_status=@activity_status,remarks=@remarks,if_approved=@if_approved,manager_id=@manager_id,job_ids=@job_ids,activity_person=@activity_person where activity_id=@activity_id;";
int result = ado.ExecuteSqlNonQuery(sql, p.ToArray());
if (result == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改失败');</script>");
}
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('提交失败');</script>");
}
}
public string Delete(string sysNums)
{
AdoHelper adohelper = AdoHelper.CreateHelper("DBInstance");
string sys = sysNums.Replace(",", "','");
int result = adohelper.ExecuteSqlNonQuery("delete from T_Test_Queston where sysnumber in ('" + sys + "') and orwner <> '1'");
string sysN = sysNums.Split(',')[0].ToString();
int a = adohelper.ExecuteSqlNonQuery("delete from T_Test_QuestonAnswer where questionSysnumber='" + sysNums.Split(',')[0].ToString() + "'");
return(result.ToString());
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModOrderDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Order_InfoDetail(");
strSql.Append("sysnumber,OrderId,OrderType,GoodsId,GoodsCode,GoodsName,GoodsFormate,GoodsPic,Quantity,Price,AllMoney,OneWeight,AllWeight,MarketPrice,CBPrice,Remarks,FreightByWeight,ProviderInfo,DataFrom)");
strSql.Append(" values (");
strSql.Append("@sysnumber,@OrderId,@OrderType,@GoodsId,@GoodsCode,@GoodsName,@GoodsFormate,@GoodsPic,@Quantity,@Price,@AllMoney,@OneWeight,@AllWeight,@MarketPrice,@CBPrice,@Remarks,@FreightByWeight,@ProviderInfo,@DataFrom)");
SqlParameter[] parameters =
{
new SqlParameter("@sysnumber", SqlDbType.VarChar, 50),
new SqlParameter("@OrderId", SqlDbType.VarChar, 50),
new SqlParameter("@OrderType", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsId", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsCode", SqlDbType.VarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsFormate", SqlDbType.VarChar, 500),
new SqlParameter("@GoodsPic", SqlDbType.VarChar, 500),
new SqlParameter("@Quantity", SqlDbType.Int, 4),
new SqlParameter("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@AllMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OneWeight", SqlDbType.Int, 4),
new SqlParameter("@AllWeight", SqlDbType.Int, 4),
new SqlParameter("@MarketPrice", SqlDbType.Decimal, 9),
new SqlParameter("@CBPrice", SqlDbType.Decimal, 9),
new SqlParameter("@Remarks", SqlDbType.VarChar, 500),
new SqlParameter("@FreightByWeight", SqlDbType.Decimal, 9),
new SqlParameter("@ProviderInfo", SqlDbType.VarChar, 500),
new SqlParameter("@DataFrom", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.sysnumber;
parameters[1].Value = model.OrderId;
parameters[2].Value = model.OrderType;
parameters[3].Value = model.GoodsId;
parameters[4].Value = model.GoodsCode;
parameters[5].Value = model.GoodsName;
parameters[6].Value = model.GoodsFormate;
parameters[7].Value = model.GoodsPic;
parameters[8].Value = model.Quantity;
parameters[9].Value = model.Price;
parameters[10].Value = model.AllMoney;
parameters[11].Value = model.OneWeight;
parameters[12].Value = model.AllWeight;
parameters[13].Value = model.MarketPrice;
parameters[14].Value = model.CBPrice;
parameters[15].Value = model.Remarks;
parameters[16].Value = model.FreightByWeight;
parameters[17].Value = model.ProviderInfo;
parameters[18].Value = model.DataFrom;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
public string DeleteQues(string testId, string questionSys, string groupsysnumber)
{
object objQ = adohelper.ExecuteSqlScalar("select Questions from T_Test_day_item where sysnumber='" + groupsysnumber + "'");
if (objQ != null)
{
string newids = objQ.ToString().Replace(questionSys, "").Replace(",,", ",");
adohelper.ExecuteSqlNonQuery("update T_Test_day_item set Questions='" + newids + "',num=num-1 where sysnumber='" + groupsysnumber + "' ");
}
return("1");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModelTestQueston model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Test_Queston(");
strSql.Append("sysnumber,questionType,questionTitle,questionAnswer,orwner,description,personFlag,levelFlag,categoryFlag,categorypath,ifCourseQuestion,createTime,createPerson,shFlag,orderBy,courseId,isSubQuestion,mainQuestionSysnumber,levelPoint)");
strSql.Append(" values (");
strSql.Append("@sysnumber,@questionType,@questionTitle,@questionAnswer,@orwner,@description,@personFlag,@levelFlag,@categoryFlag,@categorypath,@ifCourseQuestion,@createTime,@createPerson,@shFlag,@orderBy,@courseId,@isSubQuestion,@mainQuestionSysnumber,@levelPoint)");
SqlParameter[] parameters =
{
new SqlParameter("@sysnumber", SqlDbType.NVarChar, 255),
new SqlParameter("@questionType", SqlDbType.NVarChar, 255),
new SqlParameter("@questionTitle", SqlDbType.NVarChar, 4000),
new SqlParameter("@questionAnswer", SqlDbType.NVarChar, 550),
new SqlParameter("@orwner", SqlDbType.NVarChar, 550),
new SqlParameter("@description", SqlDbType.NVarChar, 4000),
new SqlParameter("@personFlag", SqlDbType.VarChar, 50),
new SqlParameter("@levelFlag", SqlDbType.VarChar, 50),
new SqlParameter("@categoryFlag", SqlDbType.VarChar, 50),
new SqlParameter("@categorypath", SqlDbType.VarChar, 500),
new SqlParameter("@ifCourseQuestion", SqlDbType.Int, 4),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@createPerson", SqlDbType.VarChar, 50),
new SqlParameter("@shFlag", SqlDbType.Int, 4),
new SqlParameter("@orderBy", SqlDbType.Int, 4),
new SqlParameter("@courseId", SqlDbType.VarChar, 50),
new SqlParameter("@isSubQuestion", SqlDbType.Int, 4),
new SqlParameter("@mainQuestionSysnumber", SqlDbType.VarChar, 50),
new SqlParameter("@levelPoint", SqlDbType.Decimal)
};
parameters[0].Value = model.sysnumber;
parameters[1].Value = model.questionType;
parameters[2].Value = model.questionTitle;
parameters[3].Value = model.questionAnswer;
parameters[4].Value = model.Orner;
parameters[5].Value = model.Description;
parameters[6].Value = model.personFlag;
parameters[7].Value = model.levelFlag;
parameters[8].Value = model.categoryFlag;
parameters[9].Value = model.categorypath;
parameters[10].Value = model.ifCourseQuestion;
parameters[11].Value = model.createTime;
parameters[12].Value = model.createPerson;
parameters[13].Value = model.shFlag;
parameters[14].Value = model.orderBy;
parameters[15].Value = model.courseId;
parameters[16].Value = model.isSubQuestion;
parameters[17].Value = model.mainQuestionSysnumber;
parameters[18].Value = model.LevelPoint;
return(adohelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
public static string SaveFile(string table, string key, string value, string prop, HttpPostedFile uploadFile)
{
try
{
if (uploadFile.FileName != ".jpeg" && uploadFile.FileName != ".jpg" && uploadFile.FileName != ".png" && uploadFile.FileName != ".bmp" && uploadFile.FileName != ".gif")
{
return("图片格式不正确");
}
//if (uploadFile.ContentLength > 1024000)
//{
// return "图片不能大于1M";
//}
//保存文件
string path = "/upload/";
switch (table.ToLower())
{
case "t_member_pic":
path += "seller";
break;
case "t_member_info":
path += "headimg";
break;
case "t_goods_pic":
path += "goods";
break;
default:
path += "default";
break;
}
path += "/" + DateTime.Now.ToString("yyyy") + "/" + DateTime.Now.ToString("MMdd") + "/";
if (!Directory.Exists(HttpContext.Current.Server.MapPath(path)))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath(path));
}
path += DateTime.Now.ToString("HHmmssffff") + uploadFile.FileName;
uploadFile.SaveAs(HttpContext.Current.Server.MapPath(path));
//修改数据库
string strSql = string.Format("update {0} set {1}='{2}' where {3}='{4}'", table, prop, path, key, value);
return(ado.ExecuteSqlNonQuery(strSql).ToString());
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 创建我的题库记录
/// </summary>
/// <param name="memberId"></param>
/// <param name="courseId"></param>
/// <param name="ids"></param>
public static void CreateMyQuestions(string memberId, string courseId, string ids)
{
AdoHelper ado = AdoHelper.CreateHelper("DB_Instance");
//读取我的原有题库
DataTable dtOld = ado.ExecuteSqlDataset("select QuestionId,IfPass,getScore,userAnswer from T_Test_ErrorRecord where MemberId='" + memberId + "' and CourseId='" + courseId + "'").Tables[0];
//读取题库信息
DataTable dtAll = ado.ExecuteSqlDataset("select sysnumber,questionType,questionAnswer from T_Test_Queston where categoryFlag='" + courseId + "'").Tables[0];
//删除题目
ado.ExecuteSqlNonQuery("delete T_Test_ErrorRecord where MemberId='" + memberId + "' and CourseId='" + courseId + "'");
int index = 1;
foreach (string id in ids.Split(','))
{
if (id != "")
{
string questionType = "";
string questionAnswer = "";
DataRow[] rowQ = dtAll.Select("sysnumber='" + id + "'");
if (rowQ.Length > 0)
{
questionType = rowQ[0]["questionType"].ToString();
questionAnswer = rowQ[0]["questionAnswer"].ToString().Replace(",", "").TrimEnd(',');
}
string IfPass = "******";
string getScore = "0";
string userAnswer = "";
DataRow[] rowMy = dtOld.Select("QuestionId='" + id + "'");
if (rowMy.Length > 0)
{
IfPass = rowMy[0]["IfPass"].ToString();
getScore = rowMy[0]["getScore"].ToString();
userAnswer = rowMy[0]["userAnswer"].ToString();
}
string sql = "INSERT INTO [T_Test_ErrorRecord]([MemberId],[CourseId],[QuestionId],[CreateTime],[IfPass],[showIndex],[questionType],[questionAnswer],[userAnswer],[getScore])";
sql += "VALUES('" + memberId + "','" + courseId + "','" + id + "',getdate()," + IfPass + "," + index + ",'" + questionType + "','" + questionAnswer + "','" + userAnswer + "'," + getScore + ")";
if (ado.ExecuteSqlNonQuery(sql) > 0)
{
index++;
}
}
}
}
/// <summary>
/// 审核信息保存
/// </summary>
protected void SaveSH(string sysnumber)
{
AdoHelper adohelper = AdoHelper.CreateHelper("DBInstance");
string sql = "update T_Test_Queston set shFlag=" + this.ddlSH.SelectedValue + ", shReamrks='" + this.txtSHRemarks.Text.Replace("'", "") + "', shPerson='" + this.UserName + "', shTime=getdate() where sysnumber='" + sysnumber + "'";
adohelper.ExecuteSqlNonQuery(sql);
}
/// <summary>
/// 批量删除数据
/// </summary>
public int Util_DeleteBat(string filter)
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
string sql = "delete " + CurrentTableName() + " where " + filter + "";
return(adoHelper.ExecuteSqlNonQuery(sql));
}
/// <summary>
/// 批量更新数据
/// </summary>
public int Util_UpdateBat(string updateDesc, string updateFilter)
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
string sql = "update " + CurrentTableName() + " set " + updateDesc + " where " + updateFilter + "";
return(adoHelper.ExecuteSqlNonQuery(sql));
}
protected void Page_Load(object sender, EventArgs e)
{
//Ajax方法
AjaxPro.Utility.RegisterTypeForAjax(typeof(AppModules_Goods_T_Forms_Resource));
if (Request.QueryString["del"] != null)
{
string strSQL = "delete T_Goods_Pic where sysnumber='" + KillSqlIn.Form_ReplaceByString(Request.QueryString["del"], 100) + "';";
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
int row = adohelper.ExecuteSqlNonQuery(strSQL);
Response.Clear();
if (row > 0)
{
Response.Write("success");
}
else
{
Response.Write("fail");
}
Response.End();
}
this.goodsId = (Request["goodsId"] == null) ? "" : StarTech.KillSqlIn.Url_ReplaceByString(Request["goodsId"], 50);
if (!IsPostBack)
{
InitForm();
BindVideoAndPic();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//ModGoodsPic modPic = new ModGoodsPic();
//modPic.GoodsId = goodsId;
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
ArrayList list = batUpload();
if (list == null || list.Count == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('请选择图片');</script>");
return;
}
int i = 1;
string strSQL = "";
foreach (object obj in list)
{
if (imgNum + i > 6)
{
if (i == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('最多可上传6张');toClose();</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('已上传" + (i - 1) + "张，最多可上传6张');toClose();</script>");
}
break;
}
//modPic.Sysnumber = Guid.NewGuid().ToString();
string sysnumber = Guid.NewGuid().ToString();
int orderby = 1;
string picPath = "";
try
{
Control control = Page.FindControl("txtOrder" + i);
orderby = Int32.Parse(((HtmlInputText)(control)).Value.Trim());
}
catch
{
orderby = 0;
}
i++;
string[] arr = obj.ToString().Split('|');
picPath = arr[2];
strSQL += "insert into T_Goods_Pic([Sysnumber],[GoodsId],[PicPath],[IsDefault],[Orderby]) values('" + sysnumber + "','" + goodsId + "','" + picPath + "',0," + orderby + ");";
//modPic.PicPath = arr[2];
//new BllGoodsPic().Add(modPic);
}
int row = adohelper.ExecuteSqlNonQuery(strSQL);
if (row > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('上传成功');toClose();</script>");
BindVideoAndPic();
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public int Util_DeleteBat(string filter)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(AppConfig.DBInstance);
string sql = "delete " + this._tableName + " where " + filter + "";
return(adoHelper.ExecuteSqlNonQuery(sql));
}
/// <summary>
/// 批量更新数据
/// </summary>
public int Util_UpdateBat(string updateDesc, string updateFilter)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(AppConfig.DBInstance);
string sql = "update " + this._tableName + " set " + updateDesc + " where " + updateFilter + "";
return(adoHelper.ExecuteSqlNonQuery(sql));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtOrignalPwd.Text.Trim(), "MD5");
string newPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtNewPwd.Text.Trim(), "MD5");
string uid = Session["UserId"].ToString();
if (Session["UserId"] != null && Session["UserId"].ToString() != "")
{
DataTable dt = DalBase.Util_GetList("select * from IACenter_User where password='******' and uniqueId='" + Session["UserId"].ToString() + "' ").Tables[0];
if (dt.Rows.Count > 0)
{
int i = ado.ExecuteSqlNonQuery("update IACenter_User set password='******' where uniqueId='" + Session["UserId"].ToString() + "'");
if (i > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "lk", "<script>alert('密码修改成功');</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "lk", "<script>alert('修改失败');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "lk", "<script>alert('原始密码错误，修改失败');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "lk", "<script>alert('修改失败');</script>");
}
}
