public static void InitTabs() { Tuple <E_DbRState, MySqlDataReader, Exception> QRes; C_Db.Exec("create table if not exists grims.adminPwd(pwd varchar(255) not null) default charset=utf8mb4;"); QRes = C_Db.Query("select * from grims.adminPwd;"); if (QRes.Item1 == E_DbRState.Success) { if (!QRes.Item2.HasRows) { C_Db.Exec("insert into grims.AdminPwd (pwd) values('" + C_Md5.GetHash("123456") + "');"); } } }
//OUT public static Tuple <E_DbRState, List <string>, Exception> Get() { List <string> res = new List <string>(); Tuple <E_DbRState, MySqlDataReader, Exception> QRes = C_Db.Query("select * from grims.dept;"); if (QRes.Item1 == E_DbRState.Failed) { return(new Tuple <E_DbRState, List <string>, Exception>(QRes.Item1, null, QRes.Item3)); } while (QRes.Item2.Read()) { res.Add(QRes.Item2.GetString("deptName")); } return(new Tuple <E_DbRState, List <string>, Exception>(E_DbRState.Success, res, null)); }
public static Tuple <E_DbRState, Exception> ResetPwd(string oldPwd, string newPwd) { Tuple <E_DbRState, MySqlDataReader, Exception> QRes = C_Db.Query("select * from grims.adminPwd;"); if (QRes.Item1 == E_DbRState.Failed) { return(new Tuple <E_DbRState, Exception>(QRes.Item1, QRes.Item3)); } QRes.Item2.Read(); if (oldPwd == QRes.Item2.GetString("pwd")) { return(C_Db.Exec("update grims.adminPwd set pwd='" + newPwd + "';")); } else { return(new Tuple <E_DbRState, Exception>(E_DbRState.ErrorPwd, null)); } }
public static Tuple <E_DbRState, List <C_User>, Exception> Get() { List <C_User> res = new List <C_User>(); C_User tmp = new C_User(); Tuple <E_DbRState, MySqlDataReader, Exception> QRes = C_Db.Query("select grims.user.id,grims.user.pwd,grims.user.name,grims.dept.deptName,grims.user.tel,grims.user.email from grims.user left outer join grims.dept on grims.user.deptId = grims.dept.id ;"); while (QRes.Item2.Read()) { tmp.Id = QRes.Item2.GetInt32("id"); tmp.Name = QRes.Item2.GetString("name"); tmp.Pwd = QRes.Item2.GetString("pwd"); tmp.DeptName = QRes.Item2.GetString("deptName"); tmp.Tel = QRes.Item2.GetString("tel"); tmp.Email = QRes.Item2.GetString("email"); res.Add(tmp); } return(new Tuple <E_DbRState, List <C_User>, Exception>(E_DbRState.Success, res, null)); }
public static Tuple <E_DbRState, string, Exception> GetIdByName(string name) { Tuple <E_DbRState, MySqlDataReader, Exception> QRes = C_Db.Query("select * from grims.dept;"); if (QRes.Item1 == E_DbRState.Failed) { return(new Tuple <E_DbRState, string, Exception>(QRes.Item1, null, QRes.Item3)); } while (QRes.Item2.Read()) { if (QRes.Item2.GetString("deptName") == name) { return(new Tuple <E_DbRState, string, Exception>(E_DbRState.Success, QRes.Item2.GetString("id"), null)); } } return(new Tuple <E_DbRState, string, Exception>(E_DbRState.Success, null, null)); }
public static Tuple <E_DbRState, Exception> Login(string pwd) { Tuple <E_DbRState, MySqlDataReader, Exception> QRes = C_Db.Query("select * from grims.adminPwd;"); if (QRes.Item1 == E_DbRState.Failed) { return(new Tuple <E_DbRState, Exception>(QRes.Item1, QRes.Item3)); } QRes.Item2.Read(); if (pwd == QRes.Item2.GetString("pwd")) { return(new Tuple <E_DbRState, Exception>(E_DbRState.Success, null)); } else { return(new Tuple <E_DbRState, Exception>(E_DbRState.ErrorPwd, null)); } }
public static Tuple <E_DbRState, C_WellParas, Exception> Get() { Tuple <E_DbRState, MySqlDataReader, Exception> QRes; List <C_WellPara> res = new List <C_WellPara>(); QRes = C_Db.Query("select * from grims.wellpara;"); if (QRes.Item1 == E_DbRState.Success) { while (QRes.Item2.Read()) { C_WellPara tmp = new C_WellPara(); tmp.Type = (E_WellParaType)Enum.Parse(typeof(E_WellParaType), QRes.Item2.GetString("paraType"), true); tmp.Value = QRes.Item2.GetString("paraValue"); res.Add(tmp); } C_WellParas wps = new C_WellParas(res); return(new Tuple <E_DbRState, C_WellParas, Exception>(QRes.Item1, wps, QRes.Item3)); } else { return(new Tuple <E_DbRState, C_WellParas, Exception>(QRes.Item1, null, QRes.Item3)); } }
public static Tuple <E_DbRState, List <C_Well>, Exception> Get(string filter) { List <C_Well> res = new List <C_Well>(); Tuple <E_DbRState, MySqlDataReader, Exception> QRes; if (filter == null || filter == "") { QRes = C_Db.Query("select * from grims.well;"); } else { QRes = C_Db.Query("select * from grims.well where (" + "TsOrSt LIKE '%" + filter + "%' OR " + "Village LIKE '%" + filter + "%' OR " + "UnitCat LIKE '%" + filter + "%' OR " + "Loc LIKE '%" + filter + "%' OR " + "Lng LIKE '%" + filter + "%' OR " + "Lat LIKE '%" + filter + "%' OR " + "Usefor LIKE '%" + filter + "%' OR " + "DigTime LIKE '%" + filter + "%' OR " + "WellDepth LIKE '%" + filter + "%' OR " + "TubeMat LIKE '%" + filter + "%' OR " + "TubeIr LIKE '%" + filter + "%' OR " + "StanWaterDepth LIKE '%" + filter + "%' OR " + "SaltWaterFloorDepth LIKE '%" + filter + "%' OR " + "FilterLocLow LIKE '%" + filter + "%' OR " + "FilterLocHigh LIKE '%" + filter + "%' OR " + "StillWaterLoc LIKE '%" + filter + "%' OR " + "PumpMode LIKE '%" + filter + "%' OR " + "PumpPower LIKE '%" + filter + "%' OR " + "CoverArea LIKE '%" + filter + "%' OR " + "SupPeopleNum LIKE '%" + filter + "%' OR " + "IsWaterLevelOp LIKE '%" + filter + "%' OR " + "IsMfInstalled LIKE '%" + filter + "%' OR " + "LinkWellNo LIKE '%" + filter + "%' OR " + "IsSeepChnLinked LIKE '%" + filter + "%' OR " + "SeepChnLength LIKE '%" + filter + "%' OR " + "Remark LIKE '%" + filter + "%' " + ");"); } while (QRes.Item2.Read()) { C_Well well = new C_Well(); well.Id = QRes.Item2.GetInt32("Id"); well.TsOrSt = QRes.Item2.GetString("TsOrSt"); well.Village = QRes.Item2.GetString("Village"); well.UnitCat = QRes.Item2.GetString("UnitCat"); well.Loc = QRes.Item2.GetString("Loc"); well.Lng = QRes.Item2.GetString("Lng");//5 well.Lat = QRes.Item2.GetString("Lat"); well.Usefor = QRes.Item2.GetString("Usefor"); well.DigTime = QRes.Item2.GetDateTime("DigTime"); well.WellDepth = QRes.Item2.GetFloat("WellDepth"); well.TubeMat = QRes.Item2.GetString("TubeMat");//10 well.TubeIr = QRes.Item2.GetFloat("TubeIr"); well.StanWaterDepth = QRes.Item2.GetFloat("StanWaterDepth"); well.SaltWaterFloorDepth = QRes.Item2.GetFloat("SaltWaterFloorDepth"); well.FilterLocLow = QRes.Item2.GetFloat("FilterLocLow"); well.FilterLocHigh = QRes.Item2.GetFloat("FilterLocHigh"); well.StillWaterLoc = QRes.Item2.GetFloat("StillWaterLoc"); well.PumpMode = QRes.Item2.GetString("PumpMode"); well.PumpPower = QRes.Item2.GetFloat("PumpPower"); well.CoverArea = QRes.Item2.GetFloat("CoverArea"); well.SupPeopleNum = QRes.Item2.GetInt32("SupPeopleNum"); well.IsWaterLevelOp = QRes.Item2.GetBoolean("IsWaterLevelOp"); well.IsMfInstalled = QRes.Item2.GetBoolean("IsMfInstalled"); well.LinkWellNo = QRes.Item2.GetInt32("LinkWellNo"); well.IsSeepChnLinked = QRes.Item2.GetBoolean("IsSeepChnLinked"); well.SeepChnLength = QRes.Item2.GetFloat("SeepChnLength"); well.Remark = QRes.Item2.GetString("Remark"); res.Add(well); } return(new Tuple <E_DbRState, List <C_Well>, Exception>(E_DbRState.Changed, res, null)); }
public static Tuple <E_DbRState, List <C_EntWell>, Exception> Get(string filter) { List <C_EntWell> res = new List <C_EntWell>(); Tuple <E_DbRState, MySqlDataReader, Exception> QRes; if (filter == null || filter == "") { QRes = C_Db.Query("select * from grims.entwell;"); } else { QRes = C_Db.Query("select * from grims.entwell where (" + "TsOrSt LIKE '%" + filter + "%' OR " + //1 "EntName LIKE '%" + filter + "%' OR " + //2 "UnitCat LIKE '%" + filter + "%' OR " + //3 "Loc LIKE '%" + filter + "%' OR " + //4 "Lng LIKE '%" + filter + "%' OR " + //5 "Lat LIKE '%" + filter + "%' OR " + //6 "Usefor LIKE '%" + filter + "%' OR " + //7 "DigTime LIKE '%" + filter + "%' OR " + //8 "FetchWaterId LIKE '%" + filter + "%' OR " + //9 "IsPaid LIKE '%" + filter + "%' OR " + //10 "WellDepth LIKE '%" + filter + "%' OR " + //11 "TubeMat LIKE '%" + filter + "%' OR " + //12 "TubeIr LIKE '%" + filter + "%' OR " + //13 "StanWaterDepth LIKE '%" + filter + "%' OR " + //14 "SaltWaterFloorDepth LIKE '%" + filter + "%' OR " + //15 "FilterLocLow LIKE '%" + filter + "%' OR " + //16 "FilterLocHigh LIKE '%" + filter + "%' OR " + //17 "StillWaterLoc LIKE '%" + filter + "%' OR " + //18 "PumpMode LIKE '%" + filter + "%' OR " + //19 "PumpPower LIKE '%" + filter + "%' OR " + //20 "IsWaterLevelOp LIKE '%" + filter + "%' OR " + //21 "IsMfInstalled LIKE '%" + filter + "%' OR " + //22 "Remark LIKE '%" + filter + "%' " + ");"); } while (QRes.Item2.Read()) { C_EntWell well = new C_EntWell(); well.Id = QRes.Item2.GetInt32("Id"); well.TsOrSt = QRes.Item2.GetString("TsOrSt"); well.EntName = QRes.Item2.GetString("EntName"); well.UnitCat = QRes.Item2.GetString("UnitCat"); well.Loc = QRes.Item2.GetString("Loc"); well.Lng = QRes.Item2.GetString("Lng");//5 well.Lat = QRes.Item2.GetString("Lat"); well.Usefor = QRes.Item2.GetString("Usefor"); well.DigTime = QRes.Item2.GetDateTime("DigTime"); well.FetchWaterId = QRes.Item2.GetString("FetchWaterId"); well.IsPaid = QRes.Item2.GetBoolean("IsPaid"); well.WellDepth = QRes.Item2.GetFloat("WellDepth"); //11 well.TubeMat = QRes.Item2.GetString("TubeMat"); //12 well.TubeIr = QRes.Item2.GetFloat("TubeIr"); well.StanWaterDepth = QRes.Item2.GetFloat("StanWaterDepth"); well.SaltWaterFloorDepth = QRes.Item2.GetFloat("SaltWaterFloorDepth"); well.FilterLocLow = QRes.Item2.GetFloat("FilterLocLow");//16 well.FilterLocHigh = QRes.Item2.GetFloat("FilterLocHigh"); well.StillWaterLoc = QRes.Item2.GetFloat("StillWaterLoc"); well.PumpMode = QRes.Item2.GetString("PumpMode"); well.PumpPower = QRes.Item2.GetFloat("PumpPower");//20 well.IsWaterLevelOp = QRes.Item2.GetBoolean("IsWaterLevelOp"); well.IsMfInstalled = QRes.Item2.GetBoolean("IsMfInstalled"); well.Remark = QRes.Item2.GetString("Remark"); res.Add(well); } return(new Tuple <E_DbRState, List <C_EntWell>, Exception>(E_DbRState.Changed, res, null)); }