//保存题目类别
public int SaveSort(Sort sort)
{
int res = 0;
//更新
if (sort.SortId != 0)
{
string updateSql = "update Sort set SortOrder ={0}, SortName = {1} where SortId = {2}";
res = db.ExecuteCommand(updateSql, new Object[] { sort.SortOrder, sort.SortName, sort.SortId });
}
else
{
Sort newSort = new Sort()
{
SortName = sort.SortName,
SortOrder = sort.SortOrder
};
db.Sort.InsertOnSubmit(newSort);
db.SubmitChanges();
if (newSort.SortId > 0)
{
res = 1;
}
}
return(res);
}
public static void DeleteAllLookups()
{
using (DataClassesDataContext dc = new DataClassesDataContext())
{
//dc.ExecuteCommand("DBCC CHECKIDENT('Unit', RESEED, 0);");
//dc.ExecuteCommand("DBCC CHECKIDENT('Category', RESEED, 0);");
//dc.ExecuteCommand("DBCC CHECKIDENT('Role', RESEED, 0);");
dc.ExecuteCommand("DBCC CHECKIDENT('Permission', RESEED, 0);");
dc.ExecuteCommand("DBCC CHECKIDENT('RolePermissions', RESEED, 0);");
//var units = dc.Units.ToList();
//dc.Units.DeleteAllOnSubmit(units);
//var categories = dc.Categories.ToList();
//dc.Categories.DeleteAllOnSubmit(categories);
//var roles = dc.Roles.ToList();
//dc.Roles.DeleteAllOnSubmit(roles);
var rp = dc.RolePermissions.ToList();
dc.RolePermissions.DeleteAllOnSubmit(rp);
var permissions = dc.Permissions.ToList();
dc.Permissions.DeleteAllOnSubmit(permissions);
dc.SubmitChanges();
}
}
//删除一级知识点
public int DeleteFirst(int id)
{
SqlParameter[] spa = { new SqlParameter("@id", id) };
int res = db.ExecuteCommand("delete from FirstPoint where FirstPointId =" + id);
return(res);
}
private static void Delete(long id)
{
string query = "delete from tblAllottee where id=" + id;
DataClassesDataContext datacontext = new DataClassesDataContext();
datacontext.ExecuteCommand(query, "");
}
/// <summary>
/// 关注按钮推荐
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void followbutton_Click(object sender, EventArgs e)
{
if (followbutton.Text == "关注此书")
{
DataClassesDataContext db = new DataClassesDataContext();
BookWarehouse bw = new BookWarehouse();
bw.UserID = Session["UserID"].ToString();
bw.BookID = Convert.ToInt16(Request["BookID"]);
bw.Type = "follow";
db.BookWarehouse.InsertOnSubmit(bw);
db.SubmitChanges();
//如果圈子不为空在新鲜事中记录
var tempuser = db.User.SingleOrDefault <User>(s => s.UserID == Session["UserID"].ToString());
if (tempuser.QuanZiID != null)
{
News n = new News();
n.QuanZiID = tempuser.QuanZiID;
n.Title = Session["Name"].ToString() + "关注了：" + Session["BookName"].ToString();
n.UserID = Session["UserID"].ToString();
n.DateTime = DateTime.Now;
n.HyperLink = "~/BookWareHouse/CheckBook.aspx?BookID=" + Request["BookID"].ToString();
db.News.InsertOnSubmit(n);
db.SubmitChanges();
}
Response.Write(" <script language=javascript>alert('关注成功');window.location.href=window.location.href;</script> ");
}
else if (followbutton.Text == "已关注该书，取消？")
{
DataClassesDataContext db = new DataClassesDataContext();
db.ExecuteCommand("delete from BookWarehouse where BookID = '" + Request["BookID"].ToString() + "' and UserID = '" + Session["UserID"].ToString() + "' and Type = 'follow'");
db.SubmitChanges();
Response.Write(" <script language=javascript>alert('已取消关注');window.location.href=window.location.href;</script> ");
}
}
public void addRealTimeInfo(IEnumerable <RealTimeInfoDeserialize> realTimeInfoSource)
{
_db.ExecuteCommand("TRUNCATE TABLE RealTime");
foreach (RealTimeInfoDeserialize item in realTimeInfoSource)
{
var newRealTime = new RealTime
{
region = item.region,
srcdetail = item.srcdetail,
areaNm = item.areaNm,
UID = item.UID,
direction = item.direction,
y1 = item.y1,
x1 = item.x1,
happendate = item.happendate,
roadtype = item.roadtype,
road = item.road,
modDttm = item.modDttm,
comment = item.comment,
happentime = item.happentime,
};
_db.RealTime.InsertOnSubmit(newRealTime);
}
_db.SubmitChanges();
}
public void AddAlertInfo(IEnumerable <AlertDeserialize> alertResource)
{
var count = 1;
_db.ExecuteCommand("TRUNCATE TABLE Alert");
foreach (AlertDeserialize item in alertResource)
{
Alert alertObj = new Alert();
alertObj.alertID = count;
alertObj.messageID = item.id;
alertObj.updated = item.updated;
alertObj.name = item.author.name;
if (item.summary.text != null)
{
alertObj.text = item.summary.text.Replace('\n', ' ').Trim();
}
;
alertObj.term = item.category.term;
count++;
_db.Alert.InsertOnSubmit(alertObj);
_db.SubmitChanges();
}
}
/// <summary>
/// 上传电子书按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void sourceuploadbutton_Click(object sender, EventArgs e)
{
if (bookupload.HasFile)
{
string fileExt = System.IO.Path.GetExtension(bookupload.FileName);
if (fileExt == ".doc" || fileExt == ".txt" || fileExt == ".pdf")
{
string path = Server.MapPath("../BookWareHouse/book/") + bookupload.FileName;
if (!File.Exists(path))
{
bookupload.PostedFile.SaveAs(path);
bookuploadinfolabel.Text = "上传电子书：" + bookupload.FileName + "成功";
//写入数据库
path = @"../BookWareHouse/book/" + bookupload.FileName;
DataClassesDataContext db = new DataClassesDataContext();
db.ExecuteCommand("update Book set SourcePath = '" + path + "' where BookID = {0}", Convert.ToInt32(Request["BookID"]));
db.SubmitChanges();
}
else
{
bookuploadinfolabel.Text = "服务器中已存在同名文件，不能上传！";
}
}
else
{
bookuploadinfolabel.Text = "只允许上传doc、txt、pdf格式文件！";
}
}
else
{
bookuploadinfolabel.Text = "没有选择要上传的文件！";
}
}
/// <summary>
/// 上传封面图片按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void coverimageuploadbutton_Click(object sender, EventArgs e)
{
if (coverimageupload.HasFile)
{
string fileExt = System.IO.Path.GetExtension(coverimageupload.FileName);
if (fileExt == ".jpg" || fileExt == ".bmp" || fileExt == ".JPG")
{
string path = Server.MapPath("../img/books_img/") + coverimageupload.FileName;
if (!File.Exists(path))
{
coverimageupload.PostedFile.SaveAs(path);
coverimageuploadinfolabel.Text = "上传图片：" + coverimageupload.FileName + "成功";
//写入数据库
path = @"../img/books_img/" + coverimageupload.FileName;
DataClassesDataContext db = new DataClassesDataContext();
db.ExecuteCommand("UPDATE Book SET CoverImagePath = '" + path + "' WHERE BookID = {0}", Convert.ToInt32(Request["BookID"]));
db.SubmitChanges();
}
else
{
coverimageuploadinfolabel.Text = "服务器中已存在同名文件，不能上传！";
}
}
else
{
coverimageuploadinfolabel.Text = "只允许上传jpg、bmp格式文件！";
}
}
else
{
coverimageuploadinfolabel.Text = "没有选择要上传的文件！";
}
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void publishbutton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
//如果输入合法将日志写入数据库
DataClassesDataContext db = new DataClassesDataContext();
db.ExecuteCommand("UPDATE BookReview SET Title = '" + titletextbox.Text + "' , DateTime = '" + DateTime.Now.ToString() + "' , Content = '" + contenttextbox.Text + "' WHERE BookReviewID = {0}", Convert.ToInt32(Request["BookReviewID"]));
db.SubmitChanges();
var tempuser = db.User.SingleOrDefault <User>(s => s.UserID == Session["UserID"].ToString());
if (tempuser.QuanZiID != null)
{
News n = new News();
n.QuanZiID = tempuser.QuanZiID;
n.Title = Session["Name"].ToString() + "修改书评：" + titletextbox.Text;
n.UserID = Session["UserID"].ToString();
n.DateTime = DateTime.Now;
n.HyperLink = "~/BookWareHouse/CheckBookReview.aspx?BookReviewID=" + Request["BookReviewID"];
db.News.InsertOnSubmit(n);
db.SubmitChanges();
}
Response.Write(" <script language=javascript>alert('修改成功');window.window.location.href='CheckBookReview.aspx?BookReviewID=" + Request["BookReviewID"] + "';</script> ");
}
}
public void AddUBikeInfo(IEnumerable <UBikeDeserialize> addUBikeResource)
{
_db.ExecuteCommand("TRUNCATE TABLE UBike");
foreach (UBikeDeserialize item in addUBikeResource)
{
var newUBikeInfo = new UBike
{
_id = item._id,
sarea = item.sarea,
sareaen = item.sareaen,
sna = item.sna,
aren = item.aren,
sno = item.sno,
tot = item.tot,
snaen = item.snaen,
bemp = item.bemp,
ar = item.ar,
act = item.act,
lat = item.lat,
lng = item.lng,
sbi = item.sbi,
mday = item.mday
};
_db.UBike.InsertOnSubmit(newUBikeInfo);
}
_db.SubmitChanges();
}
/// <summary>
/// 新增熱門關鍵字
/// </summary>
public void AddBusInfo(IEnumerable <BusDynamicDeserialize> AddBusDynamicSource)
{
var count = 1;
_db.ExecuteCommand("TRUNCATE TABLE BusDynamic");
foreach (BusDynamicDeserialize item in AddBusDynamicSource)
{
var newBusInfo = new BusDynamic
{
ID = count,
PlateNumb = item.PlateNumb,
OperatorID = item.OperatorID,
RouteUID = item.RouteUID,
RouteID = item.RouteID,
RouteName = item.RouteName.Zh_tw,
SubRouteUID = item.SubRouteUID,
SubRouteID = item.SubRouteID,
SubRouteName = item.SubRouteName.Zh_tw,
Direction = item.Direction,
Speed = item.Speed,
Azimuth = item.Azimuth,
DutyStatus = item.DutyStatus,
BusStatus = item.BusStatus,
MessageType = item.MessageType,
GPSTime = item.GPSTime,
SrcUpdateTime = item.SrcUpdateTime,
UpdateTime = item.UpdateTime,
PositionLat = item.BusPosition.PositionLat,
PositionLon = item.BusPosition.PositionLon
};
count++;
_db.BusDynamic.InsertOnSubmit(newBusInfo);
}
_db.SubmitChanges();
}
public static void UpdateAllottementStatus(long applicationid, AllotementStatus status)
{
string query = "update tblAllottee set Status=" + (int)status + " where ApplicationId=" + applicationid;
DataClassesDataContext datacontext = new DataClassesDataContext();
datacontext.ExecuteCommand(query, "");
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void deletebutton_Click(object sender, EventArgs e)
{
//在数据库中删除该书评记录，跳转到我的书评界面
DataClassesDataContext db = new DataClassesDataContext();
db.ExecuteCommand("delete from BookReview where BookReviewID = '" + Request["BookReviewID"].ToString() + "'");
db.SubmitChanges();
Response.Write(" <script language=javascript>alert('删除成功');window.window.location.href='BookReview.aspx';</script> ");
}
/// <summary>
/// 新增路線資料至資料庫
/// </summary>
/// <param name="traLineResource"></param>
public void AddTraLine(IEnumerable <TraLineDeserialize> traLineResource)
{
var count = 1;
_db.ExecuteCommand("TRUNCATE TABLE TraLine");
foreach (TraLineDeserialize item in traLineResource)
{
var newTraLine = new TraLine
{
LineNo = item.LineNo,
LineID = item.LineID,
LineNameEn = item.LineNameEn,
LineNameZh = item.LineNameZh,
LineSectionNameEn = item.LineSectionNameEn,
LineSectionNameZh = item.LineSectionNameZh,
IsBranch = item.IsBranch
};
count++;
_db.TraLine.InsertOnSubmit(newTraLine);
_db.SubmitChanges();
}
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void confirmbutton_Click(object sender, EventArgs e)
{
if (Page.IsValid)//如果当前页面输入合法
{
//将图书信息添加进数据库
DataClassesDataContext db = new DataClassesDataContext();
string tempname = titletextbox.Text;
if (tempname[0] != '《')
{
tempname = "《" + tempname + "》";
}
db.ExecuteCommand("UPDATE Book SET Title = '" + tempname + "' , Author = '" + authortextbox.Text +
"' , ISBN = '" + isbntextbox.Text + "' , Publisher = '" + publishertextbox.Text +
"' , DoubanLink = '" + doubanlinktextbox.Text + "' , BriefIntroduction = '" + introtextbox.Text + "' WHERE BookID = {0}", Convert.ToInt32(Request["BookID"]));
db.SubmitChanges();
Response.Write(" <script language=javascript>alert('修改成功');window.window.location.href='CheckBook.aspx?BookID=" + Request["BookID"] + "';</script> ");
}
}
public void UploadIiamge()
{
HttpPostedFile file = Request.Files["face"]; //获取提交的数据流
try
{
string fileExtension = Path.GetExtension(file.FileName); //获取文件的扩展名
if (fileExtension != ".jpg" && fileExtension != ".JPG")
{
alert("请上传jpg格式的图片！");
return;
}
else
{
//判断文件时候出阿来
string fileName = Path.GetFileName(file.FileName);//获取扩展名与文件名
string filePreName = "/StuImg/";
string newFileName = filePreName + SId + ".jpg";
string physicFileNaem = Server.MapPath(newFileName);
if (File.Exists(physicFileNaem))
{
File.Delete(physicFileNaem);
}
file.SaveAs(Server.MapPath(newFileName));
string sql = "update student set StuImage={0} where StudentId={1}";
DataClassesDataContext db = new DataClassesDataContext();
int res = db.ExecuteCommand(sql, new object[] { newFileName, SId });
db.SubmitChanges();
alert("上传成功", "WaitAuditManage.aspx");
}
}
catch (Exception ex)
{
alert("上传失败");
}
}
public void AddRestInfo(IEnumerable <RestDeserialize> addRestResource)
{
_db.ExecuteCommand("TRUNCATE TABLE Rest");
foreach (RestDeserialize item in addRestResource)
{
var newRestInfo = new Rest
{
_id = item._id,
OpenTime = item.營業時間,
PhoneNum = item.電話,
Class = item.類別,
Addr = item.地址,
Name = item.稱,
Vocation = item.休假日,
Area = item.區域,
};
_db.Rest.InsertOnSubmit(newRestInfo);
}
_db.SubmitChanges();
}
/// <summary>
/// 新增熱門關鍵字
/// </summary>
public void AddOutParking(IEnumerable <ParkingDeserialize> addParkingResource)
{
_db.ExecuteCommand("TRUNCATE TABLE Parking");
foreach (ParkingDeserialize item in addParkingResource)
{
var newParking = new Parking
{
parkName = item.parkName,
areaId = item.areaId,
wgsX = item.wgsX,
totalSpace = item.totalSpace,
introduction = item.introduction,
wgsY = item.wgsY,
parkId = item.parkId,
address = item.address,
payGuide = item.payGuide,
_id = item._id,
surplusSpace = item.surplusSpace,
areaName = item.areaName
};
_db.Parking.InsertOnSubmit(newParking);
}
_db.SubmitChanges();
}
public void clearWTTable()
{
_db.ExecuteCommand("TRUNCATE TABLE Weather");
}
public void clearBusRouteTable()
{
_db.ExecuteCommand("TRUNCATE TABLE BusRoute");
}
public static string DeletePolicy(int piID)
{
DataClassesDataContext dc = new DataClassesDataContext();
string retString = "Полисата е избришана.";
PolicyItem pi = PolicyItem.Get(piID);
Distribution d = Distribution.GetByNumberAndSubTypeAndCompany(pi.InsuranceSubTypeID, pi.PolicyNumber, pi.Policy.InsuranceCompanyID);
Policy p = Policy.Get(pi.PolicyID);
List <RollBackDistributionItem> listRDI = RollBackDistributionItem.Table.Where(c => c.PolicyItemID == pi.ID).ToList();
if (listRDI.Count > 0)
{
retString = "Полисата е раздолжена и не може да се брише!";
return(retString);
}
List <Rate> lstRates = Rate.GetByPolicyItemID(pi.ID);
if (lstRates.Count > 0)
{
List <Payment> lstPayments = Payment.GetByRateID(lstRates[0].ID);
if (lstPayments.Count > 0)
{
if (lstPayments[0].IsFactured)
{
retString = "Полисата е фактурирана за брокеража и не може да се брише!";
return(retString);
}
}
foreach (Rate r in lstRates)
{
List <Payment> lstP = Payment.GetByRateID(r.ID);
foreach (Payment pay in lstP)
{
List <PaymentsPerInsSubType> lstPPIST = PaymentsPerInsSubType.GetByPayment(pay.ID);
foreach (PaymentsPerInsSubType ppist in lstPPIST)
{
string queryppist = @"DELETE FROM PaymentsPerInsSubTypes WHERE ID = " + ppist.ID;
dc.ExecuteCommand(queryppist);
//ppist.Delete();
}
string queryppay = @"DELETE FROM Payments WHERE ID = " + pay.ID;
dc.ExecuteCommand(queryppay);
//pay.Delete();
}
string queryr = @"DELETE FROM Rates WHERE ID = " + r.ID;
dc.ExecuteCommand(queryr);
//r.Delete();
}
string querypei = @"DELETE FROM PolicyExtendInformations WHERE PolicyItemID = " + pi.ID;
dc.ExecuteCommand(querypei);
Broker.DataAccess.Facture facture = PolicyItemFactureItem.GetByPolicyItemID(pi.ID);
if (facture != null)
{
List <Broker.DataAccess.FactureItem> listFI = FactureItem.GetByFacture(facture.ID);
foreach (FactureItem fi in listFI)
{
string querypifi = @"DELETE FROM PolicyItemFactureItems WHERE FactureItemID = " + fi.ID;
dc.ExecuteCommand(querypifi);
string queryfi = @"DELETE FROM FactureItems WHERE ID = " + fi.ID;
dc.ExecuteCommand(queryfi);
}
string queryf = @"DELETE FROM Factures WHERE ID = " + facture.ID;
dc.ExecuteCommand(queryf);
}
string querypi = @"DELETE FROM PolicyItems WHERE ID = " + pi.ID;
dc.ExecuteCommand(querypi);
//pi.Delete();
string queryp = @"DELETE FROM Policies WHERE ID = " + p.ID;
dc.ExecuteCommand(queryp);
//p.Delete();
string queryd = @"UPDATE Distributions SET IsUsed = 0 WHERE ID = " + d.ID;
dc.ExecuteCommand(queryd);
//d.IsUsed = false;
//Distribution.Table.Context.SubmitChanges();
}
return(retString);
}
public void clearTidalTable()
{
_db.ExecuteCommand("TRUNCATE TABLE Tidal");
}
