public static Tuple <E_DbRState, Exception> Change(C_EntWell well) { return(C_Db.Exec("update grims.entwell set TsOrSt='" + well.TsOrSt + "', EntName='" + well.EntName + "', UnitCat='" + well.UnitCat + "', Loc='" + well.Loc + "', Lng='" + well.Lng + "', Lat='" + well.Lat + "', Usefor='" + well.Usefor + "', DigTime='" + well.DigTime.ToString("yyyy-MM-dd") + "', FetchWaterId='" + well.FetchWaterId + "', IsPaid=" + well.IsPaid + ", WellDepth=" + well.WellDepth + ", TubeMat='" + well.TubeMat + "', TubeIr=" + well.TubeIr + ", StanWaterDepth=" + well.StanWaterDepth + ", SaltWaterFloorDepth=" + well.SaltWaterFloorDepth + ", FilterLocLow=" + well.FilterLocLow + ", FilterLocHigh=" + well.FilterLocHigh + ", StillWaterLoc=" + well.StillWaterLoc + ", PumpMode='" + well.PumpMode + "', PumpPower=" + well.PumpPower + ", IsWaterLevelOp=" + well.IsWaterLevelOp + ", IsMfInstalled=" + well.IsMfInstalled + ", Remark='" + well.Remark + "' where Id = '" + well.Id + "';" )); }
public override void ExecuteCommand(GRSession session, StringRequestInfo requestInfo) { string req = string.Join("", requestInfo.Parameters); C_EntWell ac = JsonConvert.DeserializeObject <C_EntWell>(req); C_DbTabEntWell.Delete(ac); }
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)); }
public static Tuple <E_DbRState, Exception> Delete(C_EntWell well) { return(C_Db.Exec("delete from grims.entwell where Id='" + well.Id.ToString() + "';")); }