public string GetStaffPosition(string idIn) { string pstn = ""; NGEsysDB dbConn = new NGEsysDB("Server = STEVEN-PC; Database = NGEsysDB; Integrated Security = SSPI"); var getPosition = from stf in dbConn.Staff where stf.StaffID == idIn select stf.StfPstn; foreach (var position in getPosition) { pstn += position; } return(pstn); }
public string LoginAccountName(string idIn) { string nameInDB = ""; NGEsysDB dbConn = new NGEsysDB("Server = STEVEN-PC; Database = NGEsysDB; Integrated Security = SSPI"); var getName = from stf in dbConn.Staff where stf.StaffID == idIn select stf.StfName; foreach (var name in getName) { nameInDB += name; } dbConn.Dispose(); return(nameInDB); }
public bool Login(string idIn, string pwdIn) { bool ifPass = false; NGEsysDB dbConn = new NGEsysDB("Server = STEVEN-PC; Database = NGEsysDB; Integrated Security = SSPI"); var pwdInDB = from stf in dbConn.Staff where stf.StaffID == idIn select stf.Password; foreach (var pwd in pwdInDB) { if (pwdIn == pwd) { ifPass = true; } else { ifPass = false; } } dbConn.Dispose(); return(ifPass); }
//新建报导时 public static void SetArticleInDB(string stfID, string path) { string id_temp = ""; NGEsysDB dbConn = new NGEsysDB("Server = STEVEN-PC; Database = NGEsysDB; Integrated Security = SSPI"); NGEServiceWithLinq.Article atcl = new NGEServiceWithLinq.Article(); NGEServiceWithLinq.Staff author = new NGEServiceWithLinq.Staff(); string[] dptName = new string[] { "文娱体育部", "政治与时事部", "社会热点部", "教育与科技部", "广告部" }; DateTime date = DateTime.Today; id_temp += string.Format("{0:yyyyMMdd}", date); string getDptName = ""; string getPstn = ""; var dpts = from stf in dbConn.Staff where stf.StaffID == stfID select stf.StfDpt; foreach (var dpt in dpts) { getDptName += dpt; } int dptNo = 0; for (int i = 0; i < dptName.Length - 1; i++) { if (dptName[i] == getDptName) { dptNo = i + 1; } } if (dptNo < 10) { id_temp += "0"; id_temp += dptNo.ToString(); } else if (dptNo < 100) { id_temp += dptNo.ToString(); } var pstns = from stf in dbConn.Staff where stf.StaffID == stfID select stf.StfPstn; foreach (var pstn in pstns) { getPstn += pstn; } atcl.APubDate = date; atcl.Author = stfID; atcl.Department = getDptName; atcl.AStatus = 1; atcl.APath = path; string lastExistId = null; var existArtciles = from ea in dbConn.Article where ea.APubDate == date && ea.Department == getDptName select ea.ArticleID; foreach (var existAtcl in existArtciles) { lastExistId = existAtcl; } if (lastExistId != null) { id_temp = (Convert.ToInt64(lastExistId) + 1).ToString(); } else { id_temp += "01"; } atcl.ArticleID = id_temp; dbConn.Article.InsertOnSubmit(atcl); dbConn.SubmitChanges(); dbConn.Dispose(); }
static void Main(string[] args) { NGEsysDB db = new NGEsysDB("Server = STEVEN-PC; Database = NGEsysDB; Integrated Security = SSPI"); string id_temp = ""; string[] id_56 = new string[] { "01", "02", "03", "04", "05" }; string[] dptName = new string[] { "文娱体育部", "政治与时事部", "社会热点部", "教育与科技部", "广告部" }; string[] chiefName = new string[] { "张三", "李四", "王五", "赵六", "周七" }; string[] degree = new string[] { "小学文化", "初中文化", "高中及中专", "专科", "学士", "硕士", "博士" }; string[] school = new string[] { "清华大学", "北京大学", "中国传媒大学", "北京师范大学", "华东师范大学", "东北师范大学", "北京外国语大学", "大连理工大学", "东北财经大学" }; string[] yearIn = new string[] { "05", "06", "07", "08", "09", "10", "11", "12", "13" }; string[] chnNum = new string[] { "一", "二", "三" }; //每一个部门添加一个部门主任 //for (int i = 0; i < 5; i++) //{ // Staff stf = new Staff(); // id_temp += "04"; // id_temp += "05"; // id_temp += id_56[i]; // id_temp += "00"; // stf.StaffID = id_temp; // stf.StfName = chiefName[i]; // stf.StfYearIn = 2005; // stf.StfPstn = "部门主任"; // stf.StfDpt = dptName[i]; // stf.StfDgr = degree[5]; // Random rdm = new Random(); // int schNo = rdm.Next(0, 6); // stf.StfGrdtdFrm = school[schNo]; // stf.Password = id_temp; // db.Staff.InsertOnSubmit(stf); // db.SubmitChanges(); // id_temp = ""; // Console.WriteLine("number {0} data inserted. ", i); //} //for(int i = 3; i < 5; i++) //{ // //为每个部门添加两个编辑 // for (int j = 0; j < 2; j++) // { // Staff stf = new Staff(); // id_temp += "03"; // Random rdm = new Random(); // int yearRdm = rdm.Next(0, 9); // id_temp += yearIn[yearRdm]; // id_temp += id_56[i]; // id_temp += '0' + (j + 1).ToString(); // stf.StaffID = id_temp; // stf.StfName = chiefName[i] + "编" + chnNum[j]; // stf.StfYearIn = int.Parse("20" + yearIn[yearRdm]); // stf.StfPstn = "编辑"; // stf.StfDpt = dptName[i]; // int degreeRdm = rdm.Next(4, 6); // stf.StfDgr = degree[degreeRdm]; // int schNo = rdm.Next(0, 9); // stf.StfGrdtdFrm = school[schNo]; // stf.Password = id_temp; // db.Staff.InsertOnSubmit(stf); // db.SubmitChanges(); // id_temp = ""; // Console.WriteLine("Added editor {0}", j + 1); // } // //为每个部门添加两个校对 // for (int j = 0; j < 2; j++) // { // Staff stf = new Staff(); // id_temp += "02"; // Random rdm = new Random(); // int yearRdm = rdm.Next(0, 9); // id_temp += yearIn[yearRdm]; // id_temp += id_56[i]; // id_temp += '0' + (j + 3).ToString(); // stf.StaffID = id_temp; // stf.StfName = chiefName[i] + "校" + chnNum[j]; // stf.StfYearIn = int.Parse("20" + yearIn[yearRdm]); // stf.StfPstn = "校对"; // stf.StfDpt = dptName[i]; // int degreeRdm = rdm.Next(4, 6); // stf.StfDgr = degree[degreeRdm]; // int schNo = rdm.Next(0, 9); // stf.StfGrdtdFrm = school[schNo]; // stf.Password = id_temp; // db.Staff.InsertOnSubmit(stf); // db.SubmitChanges(); // id_temp = ""; // Console.WriteLine("Added proof-reader {0}", j + 1); // } // //为每个部门添加三个记者 // for (int j = 0; j < 3; j++) // { // Staff stf = new Staff(); // id_temp += "01"; // Random rdm = new Random(); // int yearRdm = rdm.Next(0, 9); // id_temp += yearIn[yearRdm]; // id_temp += id_56[i]; // id_temp += '0' + (j + 5).ToString(); // stf.StaffID = id_temp; // stf.StfName = chiefName[i] + "记" + chnNum[j]; // stf.StfYearIn = int.Parse("20" + yearIn[yearRdm]); // stf.StfPstn = "记者"; // stf.StfDpt = dptName[i]; // int degreeRdm = rdm.Next(4, 6); // stf.StfDgr = degree[degreeRdm]; // int schNo = rdm.Next(0, 9); // stf.StfGrdtdFrm = school[schNo]; // stf.Password = id_temp; // db.Staff.InsertOnSubmit(stf); // db.SubmitChanges(); // id_temp = ""; // Console.WriteLine("Added journalist {0}", j + 1); // } //} Console.WriteLine("end"); db.Dispose(); Console.ReadKey(); }