/// <summary> /// 通过对象增加数据库记录 /// </summary> /// <param name="mineral"></param> public static void Add(IMineral mineral) { if (mineral.mineralType == 1) //均质 { HomogeneousMineralInfo homogeneousMineral = (HomogeneousMineralInfo)mineral; string sql = String.Empty; if (!string.IsNullOrEmpty(homogeneousMineral.Rr)) { sql = String.Format( "INSERT INTO HomogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,Rr,DRr,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')", homogeneousMineral.ChineseName, homogeneousMineral.EnglishName, homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony, homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity, homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor, float.Parse(homogeneousMineral.Rr), homogeneousMineral.DRr, homogeneousMineral.InternalReflection, homogeneousMineral.Origin, homogeneousMineral.IMK); } else { sql = String.Format( "INSERT INTO HomogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,DRr,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", homogeneousMineral.ChineseName, homogeneousMineral.EnglishName, homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony, homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity, homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor, homogeneousMineral.DRr, homogeneousMineral.InternalReflection, homogeneousMineral.Origin, homogeneousMineral.IMK); } SqlHelper.ExecuteNonQuery(sql); } else if (mineral.mineralType == 2) //非均质 { HeterogeneousMineralInfo heterogeneousMineral = (HeterogeneousMineralInfo)mineral; string sql = String.Empty; if (!string.IsNullOrEmpty(heterogeneousMineral.Ar)) { sql = String.Format( "INSERT INTO HeterogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,Bireflection,Ar,DAr,Rs,Ps,DRr,ReflectionDAR,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')", heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName, heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony, heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity, heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor, heterogeneousMineral.Bireflection, heterogeneousMineral.Ar, heterogeneousMineral.DAr, heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr, heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection, heterogeneousMineral.Origin, heterogeneousMineral.IMK); } else { sql = String.Format( "INSERT INTO HeterogeneousMineral(ChineseName,EnglishName,ChemicalFormula,Syngony,NonUniformity,Reflectivity,Hardness,ReflectionColor,Bireflection,DAr,Rs,Ps,DRr,ReflectionDAR,InternalReflection,Origin,IMK) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}')", heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName, heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony, heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity, heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor, heterogeneousMineral.Bireflection, heterogeneousMineral.DAr, heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr, heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection, heterogeneousMineral.Origin, heterogeneousMineral.IMK); } SqlHelper.ExecuteNonQuery(sql); } }
/// <summary> /// 更新数据库 /// </summary> /// <param name="mineral"></param> public static void Update(IMineral mineral) { if (mineral.mineralType == 1) { HomogeneousMineralInfo homogeneousMineral = (HomogeneousMineralInfo)mineral; string sql = String.Empty; if (!string.IsNullOrEmpty(homogeneousMineral.Rr)) { sql = String.Format( "UPDATE HomogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',Rr='{8}',DRr='{9}',InternalReflection='{10}',Origin='{11}',IMK='{12}' WHERE ID={13}", homogeneousMineral.ChineseName, homogeneousMineral.EnglishName, homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony, homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity, homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor, homogeneousMineral.Rr, homogeneousMineral.DRr, homogeneousMineral.InternalReflection, homogeneousMineral.Origin, homogeneousMineral.IMK, homogeneousMineral.ID); } else { sql = String.Format( "UPDATE HomogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',DRr='{8}',InternalReflection='{9}',Origin='{10}',IMK='{11}' WHERE ID={12}", homogeneousMineral.ChineseName, homogeneousMineral.EnglishName, homogeneousMineral.ChemicalFormula, homogeneousMineral.Syngony, homogeneousMineral.NonUniformity, homogeneousMineral.Reflectivity, homogeneousMineral.Hardness, homogeneousMineral.ReflectionColor, homogeneousMineral.DRr, homogeneousMineral.InternalReflection, homogeneousMineral.Origin, homogeneousMineral.IMK, homogeneousMineral.ID); } SqlHelper.ExecuteNonQuery(sql); } else if (mineral.mineralType == 2) { HeterogeneousMineralInfo heterogeneousMineral = (HeterogeneousMineralInfo)mineral; string sql = String.Empty; if (!string.IsNullOrEmpty(heterogeneousMineral.Ar)) { sql = String.Format( "UPDATE HeterogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',Bireflection='{8}',Ar='{9}',DAr='{10}',Rs='{11}',Ps='{12}',DRr='{13}',ReflectionDAR='{14}',InternalReflection='{15}',Origin='{16}',IMK='{17}' WHERE ID={18}", heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName, heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony, heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity, heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor, heterogeneousMineral.Bireflection, heterogeneousMineral.Ar, heterogeneousMineral.DAr, heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr, heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection, heterogeneousMineral.Origin, heterogeneousMineral.IMK, heterogeneousMineral.ID); } else { sql = String.Format( "UPDATE HeterogeneousMineral SET ChineseName='{0}',EnglishName='{1}',ChemicalFormula='{2}',Syngony='{3}',NonUniformity='{4}',Reflectivity='{5}',Hardness='{6}',ReflectionColor='{7}',Bireflection='{8}',DAr='{9}',Rs='{10}',Ps='{11}',DRr='{12}',ReflectionDAR='{13}',InternalReflection='{14}',Origin='{15}',IMK='{16}' WHERE ID={17}", heterogeneousMineral.ChineseName, heterogeneousMineral.EnglishName, heterogeneousMineral.ChemicalFormula, heterogeneousMineral.Syngony, heterogeneousMineral.NonUniformity, heterogeneousMineral.Reflectivity, heterogeneousMineral.Hardness, heterogeneousMineral.ReflectionColor, heterogeneousMineral.Bireflection, heterogeneousMineral.DAr, heterogeneousMineral.Rs, heterogeneousMineral.Ps, heterogeneousMineral.DRr, heterogeneousMineral.ReflectionDAR, heterogeneousMineral.InternalReflection, heterogeneousMineral.Origin, heterogeneousMineral.IMK, heterogeneousMineral.ID); } SqlHelper.ExecuteNonQuery(sql); } }