public void EditRun(int p_id) { System.DateTime nowTime = System.DateTime.Now; var query = from d in db.CfProposalV where d.proposal == p_id select d; foreach (Models.CfProposalV cfp in query) { cfp.used = 1; cfp.status = 3; cfp.lastTime = nowTime; // Insert any additional changes to column values. } db.SaveChanges(); }
public void Upload_2(int id, System.DateTime nowTime) { this.lastid = id; var query2 = from d in db.CfDirFile select d; Models.CfDirFile dirfile = new Models.CfDirFile() { parentDir = 1, fileid = this.lastid }; db.CfDirFile.Add(dirfile); db.SaveChanges(); //return this.lastid; }
public String NewsAddRun(String title2, String content2) { System.DateTime nowTime = System.DateTime.Now; var query = from d in db.CfBulletin select d; Models.CfBulletin bulletin = new Models.CfBulletin() { id = new int(), title = title2, content = content2, status = 0, makeTime = nowTime, lastTime = nowTime, stEnable = "Y" }; db.CfBulletin.Add(bulletin); db.SaveChanges(); return(HttpUtility.HtmlDecode(content2)); }
/*前台 提案*/ //新增方案表單 public void DraftRunMen(String name, String phone, DateTime now_time) { var query = from d in db.CfMember select d; Models.CfMember cfm = new Models.CfMember(); cfm.name = name; cfm.phone = phone; cfm.makeTime = now_time; cfm.stEnable = "Y"; db.CfMember.Add(cfm); db.SaveChanges(); this.lastid = cfm.id; }
public int Upload(String fileName) { db = new CrowdfundingEntities(); String[] substrings = fileName.Split('.'); String firstname = ""; String secondname = ""; for (int i = 0; i < (substrings.Length - 1); i++) { if (i != 0) { firstname = firstname + "." + substrings[i]; } else { firstname = substrings[i]; } } secondname = substrings[(substrings.LongLength - 1)]; secondname = secondname.ToLower(); System.DateTime nowTime = System.DateTime.Now; this.mTime = nowTime; String datestrs = nowTime.ToString("yyyy/MM/dd hh:mm:ss"); this.temp_str_array = datestrs.Split(' '); this.temp_str_array = this.temp_str_array[0].Split('/'); var query = from d in db.CfFile select d; Models.CfFile qfile = new Models.CfFile(); qfile.firstName = firstname; qfile.secondName = secondname; qfile.makeTime = nowTime; qfile.stEnable = "Y"; db.CfFile.Add(qfile); db.SaveChanges(); this.lastid = qfile.id; return(this.lastid); }