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>
/// 创建用户提现、收入明细数据（提现：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);
}
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();
}
}
/// <summary>
/// 绑定栏目信息
/// </summary>
/// author:郭仁欣
/// <param name="reptname"></param>
/// <param name="cateid">栏目编号</param>
public void BindMenuItem(string sql, DataList reptname, string cateid)
{
try
{
string sql1 = string.Empty;
if (sql != null)
{
sql1 = sql;
}
else
{
sql1 = "select top 8 categoryid,title,newsid,releaseDate from T_news where categoryid ='" + cateid + "' and Approved=1 order by releaseDate desc";
}
StringBuilder sb = new StringBuilder(sql1);
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
DataSet ds = adoHelper.ExecuteSqlDataset(sb.ToString()); //得到改栏目的信息的结果集
reptname.DataSource = ds.Tables[0];
reptname.DataBind(); //绑定栏目详细信息
ds.Clear(); //清空缓冲，Modify by:Tu Kequan,2008-9-3
}
catch (Exception ex)
{
throw ex;
}
}
protected void BindTotalNum(string testSysnumber)
{
AdoHelper ado = AdoHelper.CreateHelper("DB_Instance");
DataSet ds = ado.ExecuteSqlDataset("select categoryId,Questions,qtype from T_Test_day_item where testSysnumber='" + testSysnumber + "'");
int total = 0;
string info = "";
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
string question = row["Questions"].ToString().TrimEnd(',').TrimStart(',');
int one = question.Length > 1 ? question.Split(',').Length : 0;
if (row["qtype"].ToString() == "A3/A4型题")
{
object objNum = ado.ExecuteSqlScalar("select count(*) as c from T_Test_Queston where isSubQuestion=1 and mainQuestionSysnumber in('" + question.Replace(",", "','") + "') ");
one = objNum == null ? 0 : int.Parse(objNum.ToString());
}
total += one;
//info += GetCategoryName(row["categoryId"].ToString()) + " " + one + "；";
}
this.txtQuestionTotalNum.Text = total + "";
}
else
{
this.txtQuestionTotalNum.Text = "0";
}
}
/// <summary>
/// 用户操作后插入日志
/// </summary>
/// <param name="model"></param>
public void InsertLog(Startech.Log.LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Log(");
strSql.Append("ApplicationName,FirstItem,SecondItem,ActionType,Description,UserId,OperationDate,Url,IP)");
strSql.Append(" values (");
strSql.Append("@ApplicationName,@FirstItem,@SecondItem,@ActionType,@Description,@UserId,@OperationDate,@Url,@IP)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ApplicationName", SqlDbType.VarChar, 50),
new SqlParameter("@FirstItem", SqlDbType.VarChar, 50),
new SqlParameter("@SecondItem", SqlDbType.VarChar, 50),
new SqlParameter("@ActionType", SqlDbType.VarChar, 50),
new SqlParameter("@Description", SqlDbType.Text),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@OperationDate", SqlDbType.DateTime),
new SqlParameter("@Url", SqlDbType.VarChar, 150),
new SqlParameter("@IP", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ApplicationName;
parameters[1].Value = model.FirstItem;
parameters[2].Value = model.SecondItem;
parameters[3].Value = model.ActionType;
parameters[4].Value = model.Description;
parameters[5].Value = model.UserId;
parameters[6].Value = model.OperationDate;
parameters[7].Value = model.Url;
parameters[8].Value = model.IP;
AdoHelper.CreateHelper("DB_Instance").ExecuteSqlNonQuery(strSql.ToString(), parameters);
}
/// <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>
protected void GetData()
{
string strSQL = "select * from T_Base_Coupon where couponId='" + couponId + "';";
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
DataSet ds = adoHelper.ExecuteSqlDataset(strSQL);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
lbCouponId.Text = dt.Rows[0][1].ToString();
ddlCouponType.SelectedValue = dt.Rows[0][2].ToString();
txtValue.Text = dt.Rows[0][3].ToString();
txtContext.Text = dt.Rows[0][4].ToString();
this.txtDay.Text = dt.Rows[0]["CouponDay"].ToString();
txtStartTime.Text = dt.Rows[0][5].ToString();
txtEndTime.Text = dt.Rows[0][6].ToString();
QRCodeUrl.ImageUrl = dt.Rows[0][7].ToString();
QRCodeUrl.Visible = true;
cbEffect.Checked = dt.Rows[0][8].ToString() == "1"?true:false;
lbUse.Text = dt.Rows[0][9].ToString() == "1"?"已使用":"未使用";
txtRemark.Text = dt.Rows[0][10].ToString();
if (ds.Tables[0].Rows[0]["CouponType"].ToString() == "DJ")
{
lbMember.Text = dt.Rows[0]["memberId"].ToString();
ddlMember.SelectedValue = ds.Tables[0].Rows[0]["postObject"].ToString();
cbQF.Checked = ds.Tables[0].Rows[0]["isPost"].ToString() == "0" ? false : true;
isShow = "style='dispaly:block' ";
}
}
}
//protected void GetFormInfo(ref ModGoodsType mod)
//{
// // mod.typeName = this.txtTitle.Value.Trim();
// // mod.orderby = this.ChangeToIntValue(this.txtOrder.Value.Trim());
// //mod.remarks = this.txtRemarks.Text.Trim();
//}
protected void GetFormateInfo()
{
string strSQL = "delete T_Goods_Formate where goodsId='" + goodsId + "';";
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
adohelper.ExecuteSqlNonQuery(strSQL);
//new TableObject("T_Goods_Formate").Util_DeleteBat("goodsId='" + this.goodsId + "'");
GoodsFormateBll bll = new GoodsFormateBll();
for (int i = 1; i < 100; i++)
{
if (Request["formate_code_" + i] == null)
{
break;
}
GoodsFormateModel mod = new GoodsFormateModel();
mod.sysnumber = Guid.NewGuid().ToString();
mod.GoodsCode = Request["formate_code_" + i];
mod.GoodsId = this.goodsId;
mod.Price = decimal.Parse(Request["formate_price_" + i]);
mod.Stock = int.Parse(Request["formate_stock_" + i]);
mod.GoodsFormateValues = Request["formate_info_" + i];
mod.GoodsFormateNames = Request["formateAllNames"];
bll.Add(mod);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public static int Util_DeleteBat(string filter, string tableName)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(DBInstance);
string sql = "delete " + tableName + " where " + filter + "";
return(adoHelper.ExecuteSqlNonQuery(sql));
}
/// <summary>
/// 获得数据列表
/// </summary>
public static DataSet Util_GetList(string strSql)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(DBInstance);
DataSet ds = adoHelper.ExecuteSqlDataset(strSql);
return(ds);
}
public static int UpdateOptin(int titleId, int optionId, string strOption)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(DBInstance);
string strSql = " ";
switch (strOption)
{
case "A":
strSql = "update T_Form_Comment set OptionA=OptionA+1 where titleId=" + titleId + " and id=" + optionId + "";
break;
case "B":
strSql = "update T_Form_Comment set OptionB=OptionB+1 where titleId=" + titleId + " and id=" + optionId + "";
break;
case "C":
strSql = "update T_Form_Comment set OptionC=OptionC+1 where titleId=" + titleId + " and id=" + optionId + "";
break;
case "D":
strSql = "update T_Form_Comment set OptionD=OptionD+1 where titleId=" + titleId + " and id=" + optionId + "";
break;
default:
strSql = "update T_Form_Comment set OptionA=OptionA+1 where titleId=" + titleId + " and id=" + optionId + "";
break;
}
return(adoHelper.ExecuteSqlNonQuery(strSql));
}
public static string GetTypeName_Hzzlw(string strTypeId)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(DBInstance_hzzlw);
string strSql = string.Format(@"select DirNameChs from T_Directory where DirectoryID='" + strTypeId + "'");
return(adoHelper.ExecuteSqlScalar(strSql).ToString());
}
/// <summary>
/// 批量更新数据
/// </summary>
public static int Util_hzzlw_UpdateBat(string updateDesc, string updateFilter, string tableName)
{
AdoHelper adoHelper = AdoHelper.CreateHelper(DBInstance_hzzlw);
string sql = "update " + tableName + " set " + updateDesc + " where " + updateFilter + "";
return(adoHelper.ExecuteSqlNonQuery(sql));
}
/// <summary>
/// 通过微信openid登录
/// </summary>
/// <param name="WXOpenId"></param>
/// <returns></returns>
private int LoginByOpenId(string WXOpenId)
{
AdoHelper ado = AdoHelper.CreateHelper("DB_Instance");
string strSql = @"select * from T_Member_Info where WXOpenId=@WXOpenId";
SqlParameter[] p = new SqlParameter[] {
new SqlParameter("@WXOpenId", WXOpenId)
};
DataTable dt = ado.ExecuteSqlDataset(strSql, p).Tables[0];
NG.WeiXin.Log.Debug(this.GetType().ToString(), "【YqxkjOAuth2.aspx】【LoginByOpenId】WXOpenId=" + WXOpenId + ";dt.Rows.Count=" + dt.Rows.Count);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["isUse"].ToString() == "0")
{
return(-1);
}
Session["MemberId"] = dt.Rows[0]["MemberId"].ToString();
return(1);
}
else
{
return(0);
}
}
public int AjaxDelete(string sysnumber)
{
string strSQL = "delete T_Goods_Formate where sysnumber='" + sysnumber + "';";
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
return(adohelper.ExecuteSqlNonQuery(strSQL));
}
protected void ltSourceId_TextChanged(object sender, EventArgs e)
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
DataSet dsSource = adoHelper.ExecuteSqlDataset("select * from IACenter_Menu where uniqueId=" + this.ltSourceId.Text + " ");
this.Literal2.Text = dsSource.Tables[0].Rows.Count > 0 ? dsSource.Tables[0].Rows[0]["menuName"].ToString() : "";
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
string signname = KillSqlIn.Form_ReplaceByString(txtSignName.Text, 20);
string remark = KillSqlIn.Form_ReplaceByString(txtRemark.Text, 20);
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
string strSQL = "";
if (id == "")
{
DateTime atime = DateTime.Now;
strSQL = "insert T_Goods_Sign values('" + signname + "','" + remark + "','" + atime + "');";
}
else
{
strSQL = "update T_Goods_Sign set signName='" + signname + "',remark='" + remark + "' where signid='" + id + "';";
}
int rows = adohelper.ExecuteSqlNonQuery(strSQL);
if (rows > 0)
{
if (id == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('添加成功');layer_close_refresh();</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('修改成功');layer_close_refresh();</script>");
}
}
}
/// <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));
}
/// <summary>
/// 审核信息初始化
/// </summary>
protected void SHInit(string sysnumber)
{
AdoHelper adohelper = AdoHelper.CreateHelper("DBInstance");
DataSet ds = adohelper.ExecuteSqlDataset("select * from T_Test_Queston where sysnumber='" + sysnumber + "'");
if (ds.Tables[0].Rows.Count > 0)
{
this.ddlSH.SelectedValue = ds.Tables[0].Rows[0]["shFlag"].ToString();
this.txtSHRemarks.Text = ds.Tables[0].Rows[0]["shReamrks"].ToString();
this.txtSHPerson.Text = ds.Tables[0].Rows[0]["shPerson"].ToString();
if (this.txtSHPerson.Text == "")
{
this.txtSHPerson.Text = this.UserName;
}
try
{
this.txtSHTime.Text = DateTime.Parse(ds.Tables[0].Rows[0]["shTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
catch { this.txtSHTime.Text = this.txtSHTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); }
}
else
{
this.txtSHPerson.Text = this.UserName;
this.txtSHTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
}
/// <summary>
/// 根据goodsid编号获取自定义属性集合(新型),判断是否null返回
/// </summary>
public DataTable GetMorePropertyInfo(string goodsId)
{
GoodsModel mod = dal.GetModel(goodsId);
if (mod != null)
{
GoodsTypeModel modCate = new GoodsTypeBll().GetModel(mod.CategoryId);
if (modCate != null)
{
//DataTable dt = new TableObject("T_Goods_MorePropertySet").Util_GetList("*", "propertyId in(select morePropertyId from T_Goods_Category_MoreProperty where categoryId='" + modCate.CategoryId + "')");
string strSQL = "select * from T_Goods_MorePropertySet where propertyId in(select morePropertyId from T_Goods_Category_MoreProperty where categoryId='" + modCate.CategoryId + "');";
AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance);
DataTable dt = adohelper.ExecuteSqlDataset(strSQL).Tables[0];
return(dt);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
/// <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);
}
//protected void btnSave_Click(object sender, EventArgs e)
//{
//}
/// <summary>
/// 报价详情
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
protected string GetMemberPrice(string GoodsId)
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
string s = "";
string sql = @"SELECT [PriceId]
,[JobType]
,[GoodsId]
,[MemberMobile]
,[MemberPrice]
,[CreateTime]
,[IsLast]
,[IsEmployerSelect]
,[EmployerSelectTime]
,[IsMemberConfirm]
,[MemberConfirmTime]
,b.TrueName
FROM T_Goods_MemberPrice a,T_Member_Info b
where a.MemberId=b.MemberId and a.GoodsId='" + GoodsId + "'";
sql += " order by a.MemberId";
//Response.Write(sql);
DataSet ds = adoHelper.ExecuteSqlDataset(sql);
if (ds.Tables[0].Rows.Count > 0)
{
s += "<table>";
foreach (DataRow row in ds.Tables[0].Rows)
{
s += "<tr><td>" + row["TrueName"] + "</td><td>" + row["CreateTime"] + "</td><td>" + row["MemberPrice"] + "</td><td>" + ((row["IsLast"].ToString() == "1") ? "最新" : "历史") + "</td><td>" + (row["IsEmployerSelect"].ToString() == "1" ? "选择" : "") + "</td></tr>";
}
s += "</table>";
}
return(s);
}
/// <summary>
/// 获取下个学习任务(支持多课程)
/// </summary>
/// <param name="memberId"></param>
/// <returns></returns>
protected ArrayList GetNextGoodsInfo(string memberId)
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
ArrayList list = new ArrayList();
//获取目前所有的课程
DataTable dtGroup = adoHelper.ExecuteSqlDataset("select GoodsToTypeId from V_Member_StudyRecord where MemberId='" + memberId + "' group by GoodsToTypeId").Tables[0];
foreach (DataRow row in dtGroup.Rows)
{
//获取最新的任务
DataTable curGoods = adoHelper.ExecuteSqlDataset("select top 1 * from V_Member_StudyRecord where GoodsToTypeId='" + row["GoodsToTypeId"] + "' and MemberId='" + memberId + "' order by Orderby desc").Tables[0];
if (curGoods.Rows.Count > 0)
{
//当前已完成的课程
if (curGoods.Rows[0]["IfReachedTotalTime"].ToString() == "1" && curGoods.Rows[0]["IfPassExamination"].ToString() == "1")
{
DataTable dtNext = adoHelper.ExecuteSqlDataset("select * from T_Goods_Info where GoodsToTypeId='" + row["GoodsToTypeId"] + "' and Orderby>" + curGoods.Rows[0]["Orderby"] + " order by Orderby asc").Tables[0];
if (dtNext.Rows.Count > 0)
{
string GoodsDesc = PubFunction.CheckStr(dtNext.Rows[0]["GoodsDesc"].ToString());
list.Add(dtNext.Rows[0]["GoodsId"] + "$" + dtNext.Rows[0]["GoodsName"] + "$" + GoodsDesc);
}
}
else
{
//当前未完成的课程
string GoodsDesc = PubFunction.CheckStr(curGoods.Rows[0]["GoodsDesc"].ToString());
list.Add(curGoods.Rows[0]["GoodsId"] + "$" + curGoods.Rows[0]["GoodsName"] + "$" + GoodsDesc);
}
}
}
return(list);
}
