public void GotAuthorityItem(Dictionary <string, string> AutorityDict, string AutorityName, string dbPath)
{
//search database
//
string SearchStr = "select * from Role where Authority = '" + AutorityName + "' ";
DbHelp dbmanage;
dbmanage = new DbHelp(EnumDbType.DbSqlServer, "server=NOLAN-DEBUG-PC\\SQLEXPRESS1;database=test;Integrated Security=True;");
//DataBase SearchData = new DataBase();
//string pathDataBase = System.Web.HttpContext.Current.Server.MapPath(dbPath);
//OleDbDataAdapter rd = SearchData.bindData(SearchStr, pathDataBase);
DataSet ds = dbmanage.QueryToDs(SearchStr);
// int count = rd.Fill(ds, "Role");
int TotleColumn = ds.Tables[0].Columns.Count;
//int test = ds.Tables[0].Rows.Count;
//if(ds.Tables[0].Rows.Count <=0)
// return ;//something error
for (int i = 0; i < TotleColumn; i++)
{
AutorityDict.Add(ds.Tables[0].Columns[i].ToString(), ds.Tables[0].Rows[0][i].ToString());
}
// SearchData.CloseConnect();
}
private void FromCaiPu()
{
string sql;
sql = "select ProName from vgCaiPu_Info where ProSN=" + id;
title = DbHelp.First(sql);
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ProSN,ProName,PicS";
sqlFrom = " from vgCaiPu_Info";
sqlWhere = " where ProSN in (select FK_CaiPu from CaiPu_Pro where FK_Pro in (select FK_Pro from CaiPu_Pro where FK_CaiPu=" + id + "))";
sqlOrder = " order by EditDate desc";
pkName = "ProSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(24));//页记录 16
pg.load();
this.rpList.dt = pg.GetDataTable();
this.rpList.listEvent = new CycleEvent(CaiPuLay.list1);
this.ucPS1.f = pg;
}
protected void gridviewbind()
{
string strrole = Request.QueryString["Authority"];
if (strrole == null || strrole == "" || strrole == "选择角色")
{
gridview1.DataSource = null;
gridview2.DataSource = null;
gridview1.DataBind();
gridview2.DataBind();
return;
}
DbHelp dbmanage;
dbmanage = new DbHelp(EnumDbType.DbSqlServer, "server=NOLAN-DEBUG-PC\\SQLEXPRESS1;database=test;Trusted_Connection=SSPI;");
string strSQL = "select * from AccountInf where Authority='" + strrole + "'";
DataSet ds1 = dbmanage.QueryToDs(strSQL);
gridview1.DataSource = ds1.Tables[0];
gridview1.DataBind();
strSQL = "select * from AccountInf where Authority='undefined'or Authority is NULL";
DataSet ds2 = dbmanage.QueryToDs(strSQL);
gridview2.DataSource = ds2.Tables[0];
gridview2.DataBind();
}
public static bool UpdateUser(Users user)
{
#region 更新用户信息
string sql = @"UPDATE Users SET LoginId=@LoginId,LoginPwd=@LoginPwd,Name=@Name,Address=@Address,Phone=@Phone,Mail=@Mail,UserRoleId=@UserRoleId,UserStateId=@UserStateId WHERE Id=@Id";
SqlParameter[] para =
{
new SqlParameter("@LoginId", user.LoginId),
new SqlParameter("@LoginPwd", user.LoginPwd),
new SqlParameter("@Address", user.Address),
new SqlParameter("@Phone", user.Phone),
new SqlParameter("@Mail", user.Mail),
new SqlParameter("@Name", user.Name),
new SqlParameter("@UserRoleId", user.UserRoles.Id),
new SqlParameter("@UserStateId", user.UserStates.Id),
new SqlParameter("@Id", user.ID)
};
int count = DbHelp.ExecuteCommand(sql, para);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
public static bool AddUser(Users user)
{
#region 注册用户
if (user.UserRoles == null)
{
user.UserRoles = UserRolesServer.GetUserRolesById(1);
}
if (user.UserStates == null)
{
user.UserStates = UserStatesServer.GetUserStatesById(1);
}
string sql = @"INSERT INTO Users(LoginId,LoginPwd,Name,Address,Phone,Mail,UserRoleId,UserStateId)
VALUES(@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserRoleId,@UserStateId)";
SqlParameter[] para =
{
new SqlParameter("@LoginId", user.LoginId),
new SqlParameter("@LoginPwd", user.LoginPwd),
new SqlParameter("@Address", user.Address),
new SqlParameter("@Phone", user.Phone),
new SqlParameter("@Mail", user.Mail),
new SqlParameter("@Name", user.Name),
new SqlParameter("@UserRoleId", user.UserRoles.Id),
new SqlParameter("@UserStateId", user.UserStates.Id)
};
int count = DbHelp.ExecuteCommand(sql, para);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
/// <summary>
/// 添加单条记录并返回ID
/// </summary>
/// <param name="pMod"></param>
/// <param name="pFields"></param>
/// <returns></returns>
public static int AddReturnID(object pMod, string pFields)
{
string tableName = GetTableName(pMod);
if (pFields == null || pFields.Length == 0)
{
throw new Exception("字段 " + pFields + " 不能为空");
}
string[] aFields = pFields.Split(',');
int arrN = aFields.Length;
IDataParameter[] aDp = DbHelp.Def.GetArrParam(arrN);
string str = string.Empty;
string str1 = string.Empty;
string s;
for (int i = 0; i < arrN; i++)
{
s = aFields[i];
str += s + ",";
str1 += "@" + s + ",";
aDp[i] = DbHelp.Def.AddParam("@" + s, GetModelFieldValue(s, pMod));
}
str = str.TrimEnd(',');
str1 = str1.TrimEnd(',');
string sSQL = "insert into " + tableName + "(" + str + ") values(" + str1 + ");select SCOPE_IDENTITY()";
return(Convert.ToInt32(DbHelp.Scalar(sSQL, aDp)));
}
public static OrderBook GetOrderbookByOrderid(int orderid)
{
#region 通过订单Id获取订单详细信息
OrderBook orderbook = new OrderBook();
string sql = "SELECT * FROM OrderBook WHERE OrderID=" + orderid;
using (SqlDataReader dr = DbHelp.GetReader(sql))
{
if (dr.Read())
{
orderbook.Id = Convert.ToInt32(dr["Id"]);
orderbook.Quantity = Convert.ToInt32(dr["Quantity"]);
orderbook.UnitPrice = Convert.ToDecimal(dr["UnitPrice"]);
int OrderId = Convert.ToInt32(dr["OrderID"]);
int bookid = Convert.ToInt32(dr["BookId"]);
dr.Close();
orderbook.Book = BookServer.GetBookDetailById(bookid);
orderbook.Order = OrdersServer.GetOrderById(OrderId);
}
else
{
orderbook = null;
}
}
return(orderbook);
#endregion
}
//添加 菜谱 套餐
private void Add1(string pSql)
{
//---获取此 菜谱或套餐 下的所有产品id
string proIDs = string.Empty;
string sSql = pSql;
using (IDataReader dr = DbHelp.Read(sSql))
{
while (dr.Read())
{
proIDs += dr[0].ToString() + ",";
}
}
if (proIDs.Length > 0)
{
proIDs = proIDs.TrimEnd(',');
}
else
{
msgAjax.Error("没有商品放入购物车");
return;
}
//---end
AddCart(Fn.StrToIntArr(proIDs));
}
private void LL()
{
string sSQL = "select TeamName,RealName,Area,Address,Tel,FixTel,Email,Detail " + User_InfoL.SQL_UserLJTeam() + " where UserSN=" + userID + " and OpenIdentity&8=8";
string sArea = string.Empty;
using (IDataReader dr = DbHelp.Read(sSQL))
{
if (dr.Read())
{
this.cName1.Text = dr["TeamName"].ToString();
this.cName.Text = dr["RealName"].ToString();
this.cTel.Text = dr["Tel"].ToString();
this.cFixTel.Text = dr["FixTel"].ToString();
this.cAddress.Text = dr["Address"].ToString();
this.cEmail.Text = dr["Email"].ToString();
pageDetail = dr["Detail"].ToString();
sArea = dr["Area"].ToString();
this.cArea.Text = sArea;
}
else
{
new MessageGeneral().Error("不存此用户");
}
}
}
private void GetClassAttr()
{
DataTable dtClassAttr = PubData.GetDataTable("caipu_classattr");
string sql = "select FK_Info_ClassAttr1,FK_Info_ClassAttr2 from CaiPu_ClassAttrInfo where FK_Info=" + id;
DataTable dt = DbHelp.GetDataTable(sql);
foreach (DataRow drw in dt.Rows)
{
string a1 = string.Empty;
string a2 = string.Empty;
foreach (DataRow drw1 in dtClassAttr.Rows)
{
if (drw["FK_Info_ClassAttr1"].ToString() == drw1["ClassSN"].ToString())
{
a1 = "<span>" + drw1["ClassName"].ToString() + "</span>";
}
if (drw["FK_Info_ClassAttr2"].ToString() == drw1["ClassSN"].ToString())
{
a2 = "<a href=\"/search/caiPu.aspx?s=------" + drw1["ClassSN"] + "\" target=\"_blank\" title=\"搜索与'" + drw1["ClassName"].ToString() + "'相关的食谱\">" + drw1["ClassName"].ToString() + "</a>";
}
}
if (a1.Length > 0)
{
pageClassAttr.Append("<li>");
pageClassAttr.Append(a1);
pageClassAttr.Append(a2);
pageClassAttr.Append("</li>");
}
}
}
private void LL()
{
string sql;
DataTable dt;
sql = "select Title,Detail,Source,EditDate,Vote from News_Info where NewsSN=" + id;
d = new SqlDataSelect(sql);
//导航栏
curPath.Text += d.Eval("Title");
//投票
sql = "select ClassName,Str,PicS from Vote_Class where PClassSN=(select ClassSN from Vote_Class where Str='news') order by Taxis asc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpVoteList, false);
//hit +1
sql = "update News_Info set Hit=Hit+1 where NewsSN=" + id;
DbHelp.Update(sql);
//健康食品推荐
sql = "select top 10 ProSN,ProName,PicS,Price from vgPro_Info where JoinType=0 and Item&128=128 and Item&2=2 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
this.rpList.dt = dt;
this.rpList.listEvent = new CycleEvent(ProLay.d_list3);
List();
}
private void LL()
{
string sSQL = "select RealName,Sex,Area,Address,EMail,Tel from User_Info where UserSN=" + LoginInfo.UserID;
string sSex = "1";
string sArea = string.Empty;
using (IDataReader dr = DbHelp.Read(sSQL))
{
if (dr.Read())
{
this.cName.Text = dr["RealName"].ToString();
this.cEMail.Text = dr["EMail"].ToString();
this.cTel.Text = dr["Tel"].ToString();
this.cAddress.Text = dr["Address"].ToString();
sArea = dr["Area"].ToString();
this.cArea.Text = sArea;
sSex = dr["Sex"].ToString();
}
else
{
Message.Error("不存此用户");
}
}
this.cSex.Text = Bind.GetHtmlRadio(KeyPair.Sex, "cSex", sSex);
GetClassPath1 acp = new GetClassPath1();
ClassPath cp = new ClassPath(PubData.GetDataTable("Pub_Area"), acp);
cp.Exe(Fn.IsInt(sArea, 0));
this.cSelectSpanHidden.Text = acp.GetPath;
}
void getUnArranageCount()
{
String stringID = Request.QueryString["CustomerID"];
String[] Customeridstr = null;
if (stringID != null)
{
Customeridstr = Request.QueryString["CustomerID"].Split(',');
}
String querrySQL = Request.QueryString["querrySQL"];
if (querrySQL != null)
{
String CustomerID = "";
querrySQL = querrySQL.Replace(",", "'");
DbHelp dbmanage = new DbHelp(EnumDbType.DbSqlServer, "server=NOLAN-DEBUG-PC\\SQLEXPRESS1;database=test;Trusted_Connection=SSPI;");
DataSet ds = dbmanage.QueryToDs(querrySQL);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CustomerID += ds.Tables[0].Rows[i]["ID"].ToString() + ",";
}
CustomerID = CustomerID.Substring(0, CustomerID.Length - 1);
Customeridstr = CustomerID.Split(',');
}
//int elementcount = Customeridstr.Count();
fps.InnerText = Customeridstr.Count().ToString();
}
private void Ord_QX()
{
string sStatusCancelRemark = Server.HtmlEncode(Req.GetForm("content").Trim());
if (sStatusCancelRemark.Length == 0 || sStatusCancelRemark.Length > 600)
{
msgAjax.Error("请输入备注，不超过600字");
return;
}
string sql = "update Ord_Info set Status=@Status,StatusCancelRemark=@StatusCancelRemark where OrdSN=" + id + " and FK_User="******" and Status=10 and getdate()<dateadd(dd,0,convert(varchar(10),ToMinTime,120))";
//凌晨时间
DateTime lc = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"));
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@Status", 21),
DbHelp.Def.AddParam("@StatusCancelRemark", sStatusCancelRemark),
DbHelp.Def.AddParam("@AllowTime", lc),
};
if (DbHelp.Update(sql, dp) > 0)
{
msgAjax.Success("1");
return;
}
else
{
msgAjax.Error("提交失败");
return;
}
}
/// <summary>
/// 删除多条(包括删除文件) 复选框名为IsSel
/// </summary>
/// <param name="pTableName">表名</param>
/// <param name="pPKName">主键字段名(根据此字段删除记录)</param>
/// <param name="pDeleteFields">文件字段名 一条记录需要删除多个文件 用字段名并逗号隔开 如 PicS,PicB</param>
/// <param name="pPathFormat">文件相对路径 如 /upload_file/pic/ 必需以/开始 以/结束</param>
public static int DeleteMore(string pTableName, string pPKName, string pDeleteFields, string pPathFormat)
{
IMessage MessageG = new MessageGeneral();
string[] aSel = pDeleteFields.Split(',');
int aSelN = aSel.Length;
string sArrStr = Req.GetForm("IsSel");
if (!Fn.IsIntArrBool(sArrStr))
{
MessageG.Error("请选择要删除的记录.");
}
string sSQL = "select " + pDeleteFields + " from " + pTableName + " where " + pPKName + " in(" + sArrStr + ")";
DataTable dt = DbHelp.GetDataTable(sSQL);
foreach (DataRow drw in dt.Rows)
{
foreach (string s in aSel)
{
WZ.Common.OperationFile.FileCommon.Delete(string.Format(pPathFormat, drw[s]));
}
}
sSQL = "delete from " + pTableName + " where " + pPKName + " in(" + sArrStr + ")";
return(DbHelp.Update(sSQL));
//HttpContext.Current.Response.Redirect(HttpContext.Current.Request.Url.ToString());
}
public static bool SaveOrder(string shop, string user, string content)
{
bool isOk = false;
Dictionary <string, string> dataMap = new Dictionary <string, string>();
dataMap.Add("id", Guid.NewGuid().ToString());
dataMap.Add("UserId", userId);
dataMap.Add("OrderDate", DateTime.Now.ToString());
string[] strs = content.Split(';');
foreach (string kv in strs)
{
string[] strs2 = kv.Split('@');
string name = strs2[0];
if (name.Length < 1)
{
continue;
}
string num = strs2[1];
dataMap.Add(PinYinConverter.Get(name), num);
}
DbHelp db = new DbHelp();
db.InsertData("tb_orderFuding", dataMap);
return(isOk);
}
/// <summary>
/// 删除单条
/// </summary>
/// <param name="pTableName">表名</param>
/// <param name="pPKName">主键字段名(根据此字段删除记录)</param>
/// <param name="pID">要删除的对应主键值</param>
public static int Delete(string pTableName, string pPKName, int pID)
{
string sSQL = "delete from " + pTableName + " where " + pPKName + "=" + pID;
return(DbHelp.Update(sSQL));
//HttpContext.Current.Response.Redirect(HttpContext.Current.Request.Url.ToString());
}
protected void InitializeBaseInf(string strcustomerid)
{
string strsql = "select * from BaseInfo where ID=" + strcustomerid;
DbHelp dbmanage = new DbHelp(EnumDbType.DbSqlServer, "server=NOLAN-DEBUG-PC\\SQLEXPRESS1;database=test;Trusted_Connection=SSPI;");
DataSet ds = dbmanage.QueryToDs(strsql);
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
txtkh.Value = ds.Tables[0].Rows[0]["ClientName"].ToString();
txtchepai.Value = ds.Tables[0].Rows[0]["CarNumber"].ToString();
txtcpp.Value = txtchepai.Value;
txtchejia.Value = ds.Tables[0].Rows[0]["VehicleIdentification"].ToString();
txtpinpai.Value = ds.Tables[0].Rows[0]["VehicleBrand"].ToString();
txtchexing.Value = ds.Tables[0].Rows[0]["VehicleModel"].ToString();
txtfadongji.Value = ds.Tables[0].Rows[0]["EngineNumber"].ToString();
txtguding.Value = ds.Tables[0].Rows[0]["FixTelephone"].ToString();
txtshouj.Value = ds.Tables[0].Rows[0]["PhoneNum"].ToString();
txtshenfenz.Value = ds.Tables[0].Rows[0]["IDcard"].ToString();
txtdengj.Value = ds.Tables[0].Rows[0]["RegistrationTime"].ToString();
txtjiaoqiang.Value = ds.Tables[0].Rows[0]["JiaoQiangTine"].ToString();
txtshangyexian.Value = ds.Tables[0].Rows[0]["InsuranceTime"].ToString();
drtb.Value = ds.Tables[0].Rows[0]["InsuranceCompany"].ToString();
txtzuowei.Value = ds.Tables[0].Rows[0]["setNumber"].ToString();
txtkhlx.Value = ds.Tables[0].Rows[0]["CustomerType"].ToString();
txtlxdz.Value = ds.Tables[0].Rows[0]["Address"].ToString();
txtbz.Value = ds.Tables[0].Rows[0]["Addition"].ToString();
txtdaoqi.Value = ds.Tables[0].Rows[0]["Expiration"].ToString();
}
}
/// <summary>
/// 获取分值
/// Dictionary int(f_Type), int(f_Value)
/// </summary>
/// <param name="pType">事件类型 0:积分 1:经验</param>
/// <param name="pIdentifier">事件标识符</param>
/// <returns> </returns>
public Dictionary <int, int> GetFract(string pIdentifier)
{
string sql = "select f_Type,f_Value from User_Fract where f_Identifier=@f_Identifier";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@f_Identifier", pIdentifier),
};
DataTable dt = DbHelp.GetDataTable(sql, dp);
IList <int> lValue = new List <int>();
Dictionary <int, int> dValue = new Dictionary <int, int>();
foreach (DataRow drw in dt.Rows)
{
int ftype = int.Parse(drw["f_Type"].ToString());
int fvalue = int.Parse(drw["f_Value"].ToString());
if (!dValue.ContainsKey(ftype))
{
dValue.Add(ftype, fvalue);
}
}
return(dValue);
}
private void LL()
{
string sql;
DataTable dt;
//一级分类
dtC = PubData.GetDataTable("TaoCan_Class");
DataRow[] dr = dtC.Select("ClassLevel=1", "Taxis asc");
dt = dtC.Clone();
Fn.DrwToDt(dr, dt);
Bind.BGRepeater(dt, rpClass1);
//推荐1
sql = "select top 2 ProSN,ProName,PicS from vgTaoCan_Info where Item&2=2 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpTJ1);
//推荐2
sql = "select top 4 ProSN,ProName,PicS from vgTaoCan_Info where Item&4=4 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpTJ2);
//精品
sql = "select top 12 ProSN,ProName,PicS from vgTaoCan_Info where Item&1=1 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpJP);
}
public static void DeleteUserById(int Id)
{
#region 根据用户Id删除用户
string sql = "DELETE FROM Users WHERE Id=" + Id;
DbHelp.GetExecuteNonQuery(sql);
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select top 1 QuSN,ShowType,QuName from Questionnaire where IsOpen=1 order by Taxis asc,QuSN desc";
DataTable dt = DbHelp.GetDataTable(sql);
if (dt.Rows.Count == 0)
{
return;
}
QuSN = dt.Rows[0]["QuSN"].ToString();
QuName = dt.Rows[0]["QuName"].ToString();
ShowType = dt.Rows[0]["ShowType"].ToString();
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "ajax_page_msg":
MsgList_ajaxPage();
break;
}
Response.End();
}
if (!Page.IsPostBack)
{
LL();
}
}
public static Users GetUserById(int Id)
{
#region 通过用户Id返回用户信息
Users users = new Users();
string sql = "SELECT * FROM Users WHERE Id=" + Id;
using (SqlDataReader dr = DbHelp.GetReader(sql))
{
if (dr.Read())
{
users.ID = Convert.ToInt32(dr["ID"]);
users.LoginId = dr["LoginId"].ToString();
users.LoginPwd = dr["LoginPwd"].ToString();
users.Name = dr["Name"].ToString();
users.Phone = dr["Phone"].ToString();
users.Address = dr["Address"].ToString();
users.Mail = dr["Mail"].ToString();
int userroleid = Convert.ToInt32(dr["UserRoleId"]);
int userrolestate = Convert.ToInt32(dr["UserStateId"]);
dr.Close();
users.UserRoles = UserRolesServer.GetUserRolesById(userroleid);
users.UserStates = UserStatesServer.GetUserStatesById(userrolestate);
}
else
{
users = null;
}
}
return(users);
#endregion
}
private void GetHtml()
{
string sSql = "select top 5 ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName from TaoCan_Msg ev left join User_Info ui on ev.FK_User=ui.UserSN where Purview=1 and FK_Pro=" + id + " order by ev.AddDate desc";
DataTable dt = DbHelp.GetDataTable(sSql);
Bind.BGRepeater(dt, this.rpMsg);
}
/// <summary>
/// 判断邮箱是否存在
/// </summary>
/// <param name="pEmailName"></param>
/// <returns></returns>
public static bool IsEmail(string pEmailName)
{
if (pEmailName.Length > Constant.MaxCount_Email)
{
pEmailName = pEmailName.Substring(0, Constant.MaxCount_Email);
}
string sSQL = "select top 1 UserSN from User_Info where Email=@Email";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@Email", pEmailName)
};
bool b = false;
using (IDataReader dr = DbHelp.Read(sSQL, dp))
{
if (dr.Read())
{
b = true;
}
}
return(b);
}
public void InitContainer()
{
string sql = "";
DbHelp dbHelp = new DbHelp(ConnString);
try
{
sql = string.Format("SELECT [jobName] ,[jobGroup] ,[methodName] ,[methodParams] ,[cronExpression] FROM [dbo].[sys_job] WHERE jobName = '{0}';", JobName);
DataSet dataSet = dbHelp.SelectGet(sql);
if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
JobGroup = dataSet.Tables[0].Rows[0]["jobGroup"].ToString();
MethodName = dataSet.Tables[0].Rows[0]["methodName"].ToString();
MethodParams = dataSet.Tables[0].Rows[0]["methodParams"].ToString();
}
LastFireTime = TimeZoneInfo.ConvertTimeFromUtc(Context.FireTimeUtc.DateTime, TimeZoneInfo.Local);
NextFireTime = TimeZoneInfo.ConvertTimeFromUtc(Context.NextFireTimeUtc.Value.DateTime, TimeZoneInfo.Local);
}
catch (Exception ex)
{
ExceptionInfo = ex.Message;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string checkDate = context.Request.QueryString["checkDate"].ToString();
string factoryID = context.Request.QueryString["factoryID"].ToString();
string userID = context.Request.QueryString["userID"].ToString();
string zenrenID = context.Request.QueryString["zenrenID"].ToString();
string jianchajilu = context.Request.QueryString["jianchajilu"].ToString();
string cunzaiwenti = context.Request.QueryString["cunzaiwenti"].ToString();
string fangkui = context.Request.QueryString["fangkui"].ToString();
Dictionary <string, string> dataMap = new Dictionary <string, string>();
dataMap.Add("guid", Guid.NewGuid().ToString());
dataMap.Add("checkDate", checkDate);
dataMap.Add("factoryID", factoryID);
dataMap.Add("userID", userID);
dataMap.Add("zenrenID", zenrenID);
dataMap.Add("jianchajilu", jianchajilu);
dataMap.Add("cunzaiwenti", cunzaiwenti);
dataMap.Add("fangkui", fangkui);
DbHelp db = new DbHelp();
context.Response.Write(db.InsertData("[sde].[sde].sdjianchabiao", dataMap).ToString());
}
public bool setMail(string content, string fendian)
{
bool isok = false;
//string senderServerIp = "smtp.126.com";
string title = fendian + " 配货单;日期：" + DateTime.Now.ToLongDateString();
string fromMailAddress = System.Configuration.ConfigurationSettings.AppSettings["fromMail"];
string subjectInfo = title;
string bodyInfo = content; //正文
string mailUsername = System.Configuration.ConfigurationSettings.AppSettings["username"];
string mailPassword = System.Configuration.ConfigurationSettings.AppSettings["password"]; //发送邮箱的密
string mailPort = "25";
//获取接收的邮箱
DbHelp db = new DbHelp();
DataSet ds = db.Query("select Email from tb_email ");
if (null != ds && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string toMailAddress = dr["Email"].ToString();
CSendMail email = new CSendMail("", toMailAddress, fromMailAddress, subjectInfo, bodyInfo, mailUsername, mailPassword, mailPort, false, false);
isok = email.Send();
}
}
return(isok);
}
public void Execute(JobContainer jobContainer)
{
//string sql = "";
DbHelp dbHelp = new DbHelp(ConnString);
#region 执行任务语句
try
{
ApiRequest apiRequest = new ApiRequest("ICS", true);
Inventory filter = JsonHelper.Instance.Deserialize <Inventory>(jobContainer.MethodParams);
ICSResponse <List <Inventory> > _ICSResponse = apiRequest.Post <ICSResponse <List <Inventory> > >(JsonHelper.Instance.Serialize(filter), "IInventory/GetCurrentStock", "获取库存");
if (_ICSResponse.Result != null)
{
foreach (var item in _ICSResponse.Result)
{
//sql = string.Format("DELETE FROM [dbo].[sys_oper_log] WHERE createTime < '{0}';", DateTime.Now.AddDays(-1 * double.Parse(Days.ToString())));
//dbHelp.DataOperator(sql);
}
}
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
private void caipuPicList()
{
string sSql = "select PicS,PicB from CaiPu_Pic where FK_Pro=" + id;
DataTable dtPic = DbHelp.GetDataTable(sSql);
Bind.BGRepeater(dtPic, this.rpPic);
}
