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