public List<Maintenance> GetControl() { List<Maintenance> list = new List<Maintenance>(); String command = "SELECT dzid,sbdm,bddm,ywmz,zwmz,dzlb,jtms FROM CW_YBdz_ygyb where ztbz=1 order by dzid desc"; using (OracleConnection con = new OracleConnection(connectionString)) { con.Open(); OracleCommand queryCommand = new OracleCommand(command, con); //OracleCacheDependency dependency = new OracleCacheDependency(queryCommand); var reader = queryCommand.ExecuteReader(); while (reader.Read()) { Maintenance maintenance = new Maintenance(); maintenance.ControlID = reader.GetInt32(0); maintenance.SocialSecurityCode = reader.GetValue(1).ToString(); maintenance.LocalCode = reader.GetValue(2).ToString(); maintenance.EnglishName = reader.GetValue(3).ToString(); maintenance.ChineseName = reader.GetValue(4).ToString(); maintenance.Type = reader.GetValue(5).ToString(); maintenance.Description = reader.GetValue(6).ToString(); list.Add(maintenance); } } return list; }
public int SaveControl(Maintenance maintenance) { int result = 0; int controlID = GetControlID(); String command = ""; if (maintenance.ControlID == 0 || maintenance.ControlID == null) { command = @"insert into cw_ybdz_ygyb(dzid,sbdm,bddm,ywmz,zwmz,dzlb,jtms,ztbz) values(" + controlID + ",'" + maintenance.SocialSecurityCode + "','" + maintenance.LocalCode + "','" + maintenance.EnglishName + "','" + maintenance.ChineseName + "','" + maintenance.Type + "','" + maintenance.Description + "',1)"; } else { command = @"update cw_ybdz_ygyb set sbdm='" + maintenance.SocialSecurityCode + "',bddm='" + maintenance.LocalCode + "',ywmz='" + maintenance.EnglishName + "',zwmz='" + maintenance.ChineseName + "',dzlb='" + maintenance.Type + "',jtms='" + maintenance.Description + "' where dzid=" + maintenance.ControlID; } using (OracleConnection con = new OracleConnection(connectionString)) { con.Open(); OracleCommand updateCommand = new OracleCommand(command, con); result = updateCommand.ExecuteNonQuery(); } if (result != 0 && (maintenance.ControlID == 0 || maintenance.ControlID == null)) { result = controlID; } return result; }