/// <summary>
/// 查找不存在的文件并删除已删除的附件及数据
/// </summary>
public void DeleteList(SqlConnection conn, SqlTransaction trans, List <Model.download_attach> models, int article_id)
{
StringBuilder idList = new StringBuilder();
if (models != null)
{
foreach (Model.download_attach modelt in models)
{
if (modelt.id > 0)
{
idList.Append(modelt.id + ",");
}
}
}
string id_list = HotoUtils.DelLastChar(idList.ToString(), ",");
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,file_path from dt_download_attach where article_id=" + article_id);
if (!string.IsNullOrEmpty(id_list))
{
strSql.Append(" and id not in(" + id_list + ")");
}
DataSet ds = DbHelperSQL.Query(conn, trans, strSql.ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
int rows = DbHelperSQL.ExecuteSql(conn, trans, "delete from dt_download_attach where id=" + dr["id"].ToString()); //删除数据库
if (rows > 0)
{
HotoUtils.DeleteFile(dr["file_path"].ToString()); //删除文件
}
}
}
/// <summary>
/// ²éÕÒ²»´æÔÚµÄͼƬ²¢É¾³ýÒÑɾ³ýµÄͼƬ¼°Êý¾Ý
/// </summary>
public void DeleteList(SqlConnection conn, SqlTransaction trans, List <Model.article_albums> models, int article_id)
{
StringBuilder idList = new StringBuilder();
if (models != null)
{
foreach (Model.article_albums modelt in models)
{
if (modelt.id > 0)
{
idList.Append(modelt.id + ",");
}
}
}
string id_list = HotoUtils.DelLastChar(idList.ToString(), ",");
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,big_img,small_img from dt_article_albums where article_id=" + article_id);
if (!string.IsNullOrEmpty(id_list))
{
strSql.Append(" and id not in(" + id_list + ")");
}
DataSet ds = DbHelperSQL.Query(conn, trans, strSql.ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
int rows = DbHelperSQL.ExecuteSql(conn, trans, "delete from dt_article_albums where id=" + dr["id"].ToString()); //ɾ³ýÊý¾Ý¿â
if (rows > 0)
{
HotoUtils.DeleteFile(dr["big_img"].ToString()); //ɾ³ýÔͼ
HotoUtils.DeleteFile(dr["small_img"].ToString()); //ɾ³ýËõÂÔͼ
}
}
}
/// <summary>
/// 获取OAuth配置信息
/// </summary>
/// <param name="oauth_name"></param>
public static oauth_config get_config(string oauth_name)
{
//读取接口配置信息
Model.app_oauth model = new BLL.app_oauth().GetModel(oauth_name);
if (model != null)
{
//读取站点配置信息
Model.siteconfig siteConfig = new BLL.siteconfig().loadConfig(HotoKeys.FILE_SITE_XML_CONFING);
//赋值
oauth_config config = new oauth_config();
config.oauth_name = model.api_path.Trim();
config.oauth_app_id = model.app_id.Trim();
config.oauth_app_key = model.app_key.Trim();
config.return_uri = HotoUtils.DelLastChar(siteConfig.weburl, "/") + siteConfig.webpath + "api/oauth/" + model.api_path + "/return_url.aspx";
return(config);
}
return(null);
}
public static string tenpay_notify = ""; //支付完成后的回调处理页面;
static TenpayUtil()
{
//读取XML配置信息
string fullPath = HotoUtils.GetMapPath("~/xmlconfig/tenpay.config");
XmlDocument doc = new XmlDocument();
doc.Load(fullPath);
XmlNode _bargainor_id = doc.SelectSingleNode(@"Root/bargainor_id");
XmlNode _tenpay_key = doc.SelectSingleNode(@"Root/tenpay_key");
XmlNode _tenpay_return = doc.SelectSingleNode(@"Root/tenpay_return");
XmlNode _tenpay_notify = doc.SelectSingleNode(@"Root/tenpay_notify");
//读取站点配置信息
Model.siteconfig model = new BLL.siteconfig().loadConfig(HotoKeys.FILE_SITE_XML_CONFING);
bargainor_id = _bargainor_id.InnerText;
tenpay_key = _tenpay_key.InnerText;
tenpay_return = HotoUtils.DelLastChar(model.weburl, "/") + _tenpay_return.InnerText;
tenpay_notify = HotoUtils.DelLastChar(model.weburl, "/") + _tenpay_notify.InnerText;
}
static Config()
{
//↓↓↓↓↓↓↓↓↓↓请在这里配置您的基本信息↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
//读取XML配置信息
string fullPath = HotoUtils.GetMapPath("~/xmlconfig/alipay.config");
XmlDocument doc = new XmlDocument();
doc.Load(fullPath);
XmlNode _partner = doc.SelectSingleNode(@"Root/partner");
XmlNode _key = doc.SelectSingleNode(@"Root/key");
XmlNode _seller_email = doc.SelectSingleNode(@"Root/seller_email");
XmlNode _return_url = doc.SelectSingleNode(@"Root/return_url");
XmlNode _notify_url = doc.SelectSingleNode(@"Root/notify_url");
//读取站点配置信息
Model.siteconfig model = new BLL.siteconfig().loadConfig(HotoKeys.FILE_SITE_XML_CONFING);
//合作身份者ID，以2088开头由16位纯数字组成的字符串
partner = _partner.InnerText;
//交易安全检验码，由数字和字母组成的32位字符串
key = _key.InnerText;
//签约支付宝账号或卖家支付宝帐户
seller_email = _seller_email.InnerText;
//页面跳转同步返回页面文件路径 要用 http://格式的完整路径，不允许加?id=123这类自定义参数
return_url = HotoUtils.DelLastChar(model.weburl, "/") + _return_url.InnerText;
//服务器通知的页面文件路径 要用 http://格式的完整路径，不允许加?id=123这类自定义参数
notify_url = HotoUtils.DelLastChar(model.weburl, "/") + _notify_url.InnerText;
//↑↑↑↑↑↑↑↑↑↑请在这里配置您的基本信息↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑
//字符编码格式 目前支持 gbk 或 utf-8
input_charset = "utf-8";
//签名方式 不需修改
sign_type = "MD5";
}
/// <summary>
/// 查找不存在的商品并删除
/// </summary>
private void DeleteGoodsList(SqlConnection conn, SqlTransaction trans, List <Model.order_goods> models, int order_id)
{
StringBuilder idList = new StringBuilder();
if (models != null)
{
foreach (Model.order_goods modelt in models)
{
if (modelt.id > 0)
{
idList.Append(modelt.id + ",");
}
}
}
string id_list = HotoUtils.DelLastChar(idList.ToString(), ",");
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from dt_order_goods where order_id=" + order_id);
if (!string.IsNullOrEmpty(id_list))
{
strSql.Append(" and id not in(" + id_list + ")");
}
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString());
}
/// <summary>
/// 更新一条数据及其子表
/// </summary>
public bool Update(Model.manager_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_manager_role set ");
strSql.Append("role_name=@role_name,");
strSql.Append("role_type=@role_type");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@role_name", SqlDbType.NVarChar, 100),
new SqlParameter("@role_type", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.id;
parameters[1].Value = model.role_name;
parameters[2].Value = model.role_type;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//删除权限
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from dt_manager_role_value where role_id=@role_id ");
StringBuilder idList = new StringBuilder();
if (model.manager_role_values != null)
{
foreach (Model.manager_role_value models in model.manager_role_values)
{
if (models.id > 0)
{
idList.Append(models.id + ",");
}
}
string id_list = HotoUtils.DelLastChar(idList.ToString(), ",");
if (!string.IsNullOrEmpty(id_list))
{
strSql2.Append(" and id not in(" + id_list + ")");
}
}
SqlParameter[] parameters2 =
{
new SqlParameter("@role_id", SqlDbType.Int, 4)
};
parameters2[0].Value = model.id;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
//添加权限
if (model.manager_role_values != null)
{
StringBuilder strSql3;
foreach (Model.manager_role_value models in model.manager_role_values)
{
strSql3 = new StringBuilder();
if (models.id == 0)
{
strSql3.Append("insert into dt_manager_role_value(");
strSql3.Append("role_id,channel_name,channel_id,action_type)");
strSql3.Append(" values (");
strSql3.Append("@role_id,@channel_name,@channel_id,@action_type)");
SqlParameter[] parameters3 =
{
new SqlParameter("@role_id", SqlDbType.Int, 4),
new SqlParameter("@channel_name", SqlDbType.NVarChar, 255),
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@action_type", SqlDbType.NVarChar, 100)
};
parameters3[0].Value = model.id;
parameters3[1].Value = models.channel_name;
parameters3[2].Value = models.channel_id;
parameters3[3].Value = models.action_type;
cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(cmd);
}
}
}
int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}