/// <summary>
/// 用户中心 修改基础信息
/// </summary>
/// <param name="info"></param>
/// <param name="errmsg"></param>
/// <returns></returns>
internal static bool PutUserInfo(base_users info, out string errmsg)
{
MySqlTransactionHelper tran = new MySqlTransactionHelper();
if (!tran.TransactionBegin(out errmsg))
{
return(false);
}
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("@userid", info.userid));
pars.Add(new DataParameter("@nickname", info.nickname));
pars.Add(new DataParameter("@sex", info.sex));
pars.Add(new DataParameter("@birthday", info.birthday));
pars.Add(new DataParameter("@phone", info.phone));
pars.Add(new DataParameter("@email", info.email));
pars.Add(new DataParameter("@realname", info.realname)); //pars.Add(new DataParameter("@realname", info.degree));
pars.Add(new DataParameter("@photo", info.photo));
string sqlstr = "update base_users set nickname=@nickname,sex=@sex,birthday=@birthday,phone=@phone,email=@email,realname=@realname,photo=@photo where userid=@userid";
tran.TransactionExecuteCommand(sqlstr, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(false);
}
return(tran.TransactionCommit(out errmsg));
}
internal static bool PutUserInforname(int userid, string realname, string email, string phone, string opinion, int period, int grade, string classname, string school, out string errmsg)
{
MySqlTransactionHelper tran = new MySqlTransactionHelper();
if (!tran.TransactionBegin(out errmsg))
{
return(false);
}
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("@realname", realname));
pars.Add(new DataParameter("@email", email));
pars.Add(new DataParameter("@phone", phone));
pars.Add(new DataParameter("@userid", userid));
pars.Add(new DataParameter("@period", period));
pars.Add(new DataParameter("@grade", grade));
pars.Add(new DataParameter("@classname", classname));
pars.Add(new DataParameter("@school", school));
string sqlstr = "update base_users set realname=@realname,email=@email,phone=@phone,period=@period,grade=@grade,classname=@classname,school=@school where userid=@userid";
tran.TransactionExecuteCommand(sqlstr, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(false);
}
List <DataParameter> pars2 = new List <DataParameter>();
pars2.Add(new DataParameter("@opinion", opinion));
pars2.Add(new DataParameter("@userid", userid));
string sqlstr2 = "insert into chosen_feedback(userid,opinion) values (@userid,@opinion)";
tran.TransactionExecuteCommand(sqlstr2, out errmsg, pars2);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(false);
}
return(tran.TransactionCommit(out errmsg));
}
/// <summary>
/// 判断全文资源计费情况
/// </summary>
/// <param name="restype">资源库id</param>
/// <param name="seqid">资源id</param>
/// <param name="userid">用户id</param>
/// <param name="customerid">客户id</param>
/// <param name="userIp">用户ip</param>
/// <param name="tablename">资源库名</param>
/// <param name="costtype">计费类型 【0免费资源；1 客户计时订单；2 客户计量订单；3 用户订单；】</param>
/// <param name="m_price">单条价格</param>
/// <param name="m_discount">单条折扣</param>
/// <param name="serviceno">客户服务编号</param>
/// <param name="orderno">客户服务订单号</param>
/// <param name="errmsg"></param>
/// <returns></returns>
public static int GetFullPathResourceCheckCost(int restype, long seqid, int userid, int customerid, string userIp, out string tablename, out int costtype, out decimal m_price, out decimal m_discount, out string serviceno, out string orderno, out string errmsg)
{
errmsg = null;
tablename = null;
costtype = 0;
m_price = 0;
m_discount = 0;
serviceno = null;
orderno = null;
string sqlstr = string.Format("select mouldid,databasename,databasecname,isware from db_datalibrarys where databaseid={0}", restype);
db_datalibrarys dbinfo = MySqlHelper.GetDataInfo <db_datalibrarys>(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
errmsg = "查询资源库出错" + errmsg;
return(-1);
}
if (dbinfo == null)
{
errmsg = "资源库参数错误";
return(-1);
}
tablename = dbinfo.databasename;
DataTable dt;
//首先判断是否商品库中的资源，如果是，判断单条资源是否收费 如果是，资源是否在用户已完成的订单中 （以前购买过，可以直接使用）
string shopname = null;
if (dbinfo.isware == 1 && userid > 0)
{
sqlstr = string.Format("select m_price,m_discount,title from {0} where seqid={1}", tablename, seqid);
dt = MySqlHelper.GetDataTable(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg) || dt == null)
{
errmsg = "查询资源费用信息出错" + errmsg;
return(-1);
}
if (dt.Rows.Count == 0)
{
errmsg = "资源不存在";
return(-1);
}
if (!decimal.TryParse(dt.Rows[0][0].ToString(), out m_price) || !decimal.TryParse(dt.Rows[0][1].ToString(), out m_discount))
{
errmsg = "查询资源价格及折扣信息出错";
return(-1);
}
if (m_price * m_discount == 0) //免费资源，直接使用
{
costtype = 0;
return(1);
}
shopname = dt.Rows[0][2].ToString();
sqlstr = string.Format("select count(1) from chosen_orderinfo a,chosen_ordershop b where a.orderno=b.orderno and a.status=9 and a.userid={0} and b.restype='{1}' and rescode={2}", userid, tablename, seqid);
long count = MySqlHelper.GetRecCount(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
errmsg = "查询用户订单信息出错" + errmsg;
return(-1);
}
if (count > 0) //用户购买过，直接使用
{
costtype = 3;
return(1);
}
}
// 用户是否在客户已购买并有效的授权服务当中
if (customerid > 0)
{
sqlstr = string.Format("select a.orderno,a.serviceno,b.stype,b.starttime,b.endtime,b.maxnum,b.leftnum,d.rulename,d.rulevalue from chosen_orderinfo a,chosen_serviceinfo b,chosen_servicepermit c,chosen_servicecont d where a.serviceno=b.serviceno and a.serviceno=c.serviceno and a.serviceno=d.serviceno and a.status=9 and a.customerid={0} and d.restype='{1}' ", customerid, tablename);
dt = MySqlHelper.GetDataTable(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
errmsg = "查询资源服务信息出错" + errmsg;
return(-1);
}
if (dt != null && dt.Rows.Count > 0)
{
//资源是否在服务内容当中
orderno = dt.Rows[0]["orderno"].ToString();
serviceno = dt.Rows[0]["serviceno"].ToString();
costtype = int.Parse(dt.Rows[0]["stype"].ToString());
return(1);
}
}
//都不符合，生成用户订单，返回需要计费信息
if (m_price * m_discount > 0)
{
chosen_orderinfo order = new chosen_orderinfo();
order.GetNo();
order.ordername = string.Format("订购资源库 {0} 的资源 {1} 的全文", dbinfo.databasecname, seqid);
MySqlTransactionHelper tran = new MySqlTransactionHelper();
if (tran.TransactionBegin(out errmsg))
{
//写入用户订单
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("orderno", order.orderno));
pars.Add(new DataParameter("ordername", order.ordername));
pars.Add(new DataParameter("userid", userid));
pars.Add(new DataParameter("m_price", m_price));
pars.Add(new DataParameter("s_price", m_price * m_discount));
pars.Add(new DataParameter("ctype", 1));
pars.Add(new DataParameter("paytype", 1));
pars.Add(new DataParameter("status", 1));
pars.Add(new DataParameter("Creator", userid));
pars.Add(new DataParameter("createdtime", DateTime.Now));
string sqlor = "insert into chosen_orderinfo (orderno,ordername,userid,m_price,s_price,ctype,paytype,status,creator,createdtime) values (orderno,ordername,userid,m_price,s_price,ctype,paytype,status,creator,createdtime) ";
tran.TransactionExecuteCommand(sqlor, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(-1);
}
pars.Clear();
pars.Add(new DataParameter("shopname", string.IsNullOrEmpty(shopname) ? order.ordername : shopname));
pars.Add(new DataParameter("orderno", order.orderno));
pars.Add(new DataParameter("restype", restype));
pars.Add(new DataParameter("rescode", seqid));
pars.Add(new DataParameter("prices", m_price));
pars.Add(new DataParameter("thumbnail", null));
pars.Add(new DataParameter("shopnum", 1));
sqlstr = "insert into chosen_ordershop (shopname,orderno,restype,rescode,prices,thumbnail,shopnum) values (@shopname,@orderno,@restype,@rescode,@prices,@thumbnail,@shopnum) ";
tran.TransactionExecuteCommand(sqlstr, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(-1);
}
bool issuc = tran.TransactionCommit(out errmsg);
if (!string.IsNullOrEmpty(errmsg) || !issuc)
{
errmsg = "提交订单出错：" + errmsg;
return(-1);
}
costtype = 3;
orderno = order.orderno;
return(0);
}
return(-1);
}
else //免费资源
{
costtype = 0;
return(1);
}
}
internal static base_users GetUserInfoByOther(base_users user, out string errmsg)
{
string sqlstr = "select a.userid,a.username,a.nickname,a.realname,a.usertype,a.customerid,a.sourcetype,a.sourceremarks,a.photo from base_users a,base_otherloginbind b where a.UserID=b.userid and b.bindtype=@bindtype and b.code=@code";
DataParameter[] pars = new DataParameter[]
{
new DataParameter("bindtype", user.sourceremarks),
new DataParameter("code", user.sourcetypename)
};
base_users userinfo = MySqlHelper.GetDataInfo <base_users>(sqlstr, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
return(null);
}
if (userinfo != null && userinfo.userid > 0)
{
return(userinfo);
}
MySqlTransactionHelper tran = new MySqlTransactionHelper();
if (tran.TransactionBegin(out errmsg))
{
sqlstr = "insert into base_users (username,nickname,passwd,usertype,photo,sex,createdtime,sourcetype,sourceremarks,customerid,status) values (@username,@nickname,@passwd,@usertype,@photo,@sex,@createdtime,@sourcetype,@sourceremarks,0,1)";
pars = new DataParameter[]
{
new DataParameter("@username", user.username),
new DataParameter("@nickname", user.nickname),
new DataParameter("@passwd", user.passwd),
new DataParameter("@usertype", user.usertype),
new DataParameter("@photo", user.photo),
new DataParameter("@sex", user.sex),
new DataParameter("@createdtime", user.createdtime),
new DataParameter("@sourcetype", user.sourcetype),
new DataParameter("@sourceremarks", user.sourceremarks)
};
string userIdstr = tran.TransactionExecuteInsert(sqlstr, out errmsg, pars);
int userId;
if (!string.IsNullOrEmpty(errmsg) || !int.TryParse(userIdstr, out userId) || userId < 1)
{
string err;
tran.TransactionRollback(out err);
return(null);
}
user.userid = userId;
sqlstr = "insert into base_otherloginbind (bindtype,userid,code,token,createdtime) values (@bindtype,@userid,@code,@token,@createdtime)";
pars = new DataParameter[]
{
new DataParameter("@bindtype", user.sourceremarks),
new DataParameter("@userid", user.userid),
new DataParameter("@code", user.sourcetypename),
new DataParameter("@token", user.usertypename),
new DataParameter("@createdtime", user.createdtime)
};
tran.TransactionExecuteCommand(sqlstr, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(null);
}
bool issuc = tran.TransactionCommit(out errmsg);
if (!issuc)
{
string err;
tran.TransactionRollback(out err);
return(null);
}
return(user);
}
return(null);
}