//保存题目类别 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"); }