public int CreateLayerDetail(int dDID,int dLID,int dSID,int dOrder) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO LayerDetail(DID,LID,SID,Order) VALUES({0},{1},{2},{3})",dDID,dLID,dSID,dOrder); return common_DataBase.ExecuteNonQuery_Text(); }
public void DeleteSingleMaterial(string strIDs) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("SELECT * FROM SingleMeterial Where SID = {0}",strIDs); common_DataBase.ExecuteNonQuery_Text(); }
public int CreateMultiMeterial(int LID,string Name,string TotalThick) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO SingleMeterial(LID,Name,TotalThick) VALUES({0},'{1}',{2})",LID,strEmptyCheck(Name), strEmptyCheck(TotalThick)); return common_DataBase.ExecuteNonQuery_Text(); }
public void DeleteMultiMaterial(string strIDs) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("SELECT * FROM MultiLayer Where LID = {0}",strIDs); common_DataBase.ExecuteNonQuery_Text(); }
public int CreateSingleMaterialGraph(int SGID,int SID,string Name,string Measured,string Temperature,string Incidence,string IncAngle,string FreqBand, string GraphType,string X_Axis,string Y_RigidBacking,string Y_AnechoicTermination,string Y_TransmissionLoss) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO SingleMeterialGraph(SGID,SID,Name,Measured,Temperature,Incidence,IncAngle,FreqBand,GraphType,X_Axis," + " Y_RigidBacking,Y_AnechoicTermination,Y_TransmissionLoss)" + " VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')" ,SGID,SID,Name,Measured,Temperature,Incidence,IncAngle,FreqBand,GraphType,X_Axis,Y_RigidBacking,Y_AnechoicTermination,Y_TransmissionLoss); return common_DataBase.ExecuteNonQuery_Text(); }
public int CreateSingleMaterialGraph(int SGID,int SID,string Name,string Measured,string Temperature,string Incidence,string IncAngle,string FreqBand, string GraphType,string X_Axis,string Y_RigidBacking,string Y_AnechoicTermination,string Y_TransmissionLoss) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO SingleMeterialGraph(SGID,SID,Name,Measured,Temperature,Incidence,IncAngle,FreqBand,GraphType,X_Axis," + " Y_RigidBacking,Y_AnechoicTermination,Y_TransmissionLoss)" + " VALUES({0},{1},'{2}',{3},{4},{5},{6},{7},{8},'{9}','{10}','{11}','{12}')" ,SGID,SID,strEmptyCheck(Name),strEmptyCheck(Measured),strEmptyCheck(Temperature),strEmptyCheck(Incidence), strEmptyCheck(IncAngle),strEmptyCheck(FreqBand),strEmptyCheck(GraphType),strEmptyCheck(X_Axis),strEmptyCheck(Y_RigidBacking), strEmptyCheck(Y_AnechoicTermination),strEmptyCheck(Y_TransmissionLoss)); return common_DataBase.ExecuteNonQuery_Text(); }
public int CreateSingleMeterial(int SID,string Name,string MID,string Thick,string BulkDens,string FlowRes,string Sfactor,string Prosity,string ViscousCL, string ThermalCL,string Ymodulus,string PoissionR,string LossFactor,string HP1,string DensityP1,string EmP1,string PRatioP1,string HP2,string DensityP2, string EmP2,string PRatioP2) { // DateTime date = DateTime.Parse(strDate); // strDate = date.ToString("yyyy-MM-dd"); common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO SingleMeterial(SID,Name,MID,Thick,BulkDens,FlowRes,Sfactor,Prosity,ViscousCL,ThermalCL,Ymodulus," + "PoissionR,LossFactor,HP1,DensityP1,EmP1,PRatioP1,HP2,DensityP2,EmP2,PRatioP2) " + " VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}')" ,SID,Name,MID,Thick,BulkDens,FlowRes,Sfactor,Prosity,ViscousCL,ThermalCL,Ymodulus,PoissionR,LossFactor, HP1,DensityP1,EmP1,PRatioP1,HP2,DensityP2,EmP2,PRatioP2); return common_DataBase.ExecuteNonQuery_Text(); }
public int CreateSingleMeterial(int SID,string Name,string MID,string Thick,string BulkDens,string FlowRes,string Sfactor,string Prosity,string ViscousCL, string ThermalCL,string Ymodulus,string PoissionR,string LossFactor,string HP1,string DensityP1,string EmP1,string PRatioP1,string HP2,string DensityP2, string EmP2,string PRatioP2,string strVendor,string strProducing,string strRemark,string strDate) { DateTime date = DateTime.Parse(strDate); strDate = date.ToString("yyyy-MM-dd"); common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO SingleMeterial(SID,Name,MID,Thick,BulkDens,FlowRes,Sfactor,Prosity,ViscousCL,ThermalCL,Ymodulus," + "PoissionR,LossFactor,HP1,DensityP1,EmP1,PRatioP1,HP2,DensityP2,EmP2,PRatioP2,Vendor,Producing,Remark,Occurred_Date) " + " VALUES({0},'{1}',{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},'{21}','{22}','{23}','{24}')" ,SID,Name,strEmptyCheck(MID),strEmptyCheck(Thick),strEmptyCheck(BulkDens),strEmptyCheck(FlowRes),strEmptyCheck(Sfactor),strEmptyCheck(Prosity), strEmptyCheck(ViscousCL),strEmptyCheck(ThermalCL),strEmptyCheck(Ymodulus),strEmptyCheck(PoissionR),strEmptyCheck(LossFactor),strEmptyCheck(HP1), strEmptyCheck(DensityP1),strEmptyCheck(EmP1),strEmptyCheck(PRatioP1),strEmptyCheck(HP2),strEmptyCheck(DensityP2),strEmptyCheck(EmP2), strEmptyCheck(PRatioP2),strVendor,strProducing,strRemark,strDate); return common_DataBase.ExecuteNonQuery_Text(); }
public int CreateSingleMeterial(int SID,string Name,string MID,string Thick,string BulkDens,string FlowRes,string Sfactor,string Prosity,string ViscousCL, string ThermalCL,string Ymodulus,string PoissionR,string LossFactor,string HP1,string DensityP1,string EmP1,string PRatioP1,string HP2,string DensityP2, string EmP2,string PRatioP2) { common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("INSERT INTO SingleMeterial(SID,Name,MID,Thick,BulkDens,FlowRes,Sfactor,Prosity,ViscousCL,ThermalCL,Ymodulus," + "PoissionR,LossFactor,HP1,DensityP1,EmP1,PRatioP1,HP2,DensityP2,EmP2,PRatioP2) " + " VALUES({0},'{1}',{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20})" ,SID,Name,strEmptyCheck(MID),strEmptyCheck(Thick),strEmptyCheck(BulkDens),strEmptyCheck(FlowRes),strEmptyCheck(Sfactor),strEmptyCheck(Prosity), strEmptyCheck(ViscousCL),strEmptyCheck(ThermalCL),strEmptyCheck(Ymodulus),strEmptyCheck(PoissionR),strEmptyCheck(LossFactor),strEmptyCheck(HP1), strEmptyCheck(DensityP1),strEmptyCheck(EmP1),strEmptyCheck(PRatioP1),strEmptyCheck(HP2),strEmptyCheck(DensityP2),strEmptyCheck(EmP2), strEmptyCheck(PRatioP2)); return common_DataBase.ExecuteNonQuery_Text(); }
public void ModifySingleMaterial(string strIDs,string Thick,string BulkDens,string FlowRes,string Sfactor,string Prosity,string ViscousCL,string ThermalCL, string Ymodulus,string PoissionR,string LossFactor,string strM_ID,string strVendor,string strProducing,string strRemark,string strDate) { DateTime date = DateTime.Parse(strDate); strDate = date.ToString("yyyy-MM-dd"); common_DataBase = new Common_DataBase(); common_DataBase.Query = String.Format("UPDATE SingleMeterial SET Thick = {1},BulkDens = {2},FlowRes = {3},Sfactor = {4},Prosity = {5},ViscousCL = {6}," + "ThermalCL = {7},Ymodulus = {8},PoissionR = {9},LossFactor = {10},MID = {11} ,Vendor = '{12}',Producing = '{13}',Remark = '{14}'," + "Occurred_Date = '{15}' WHERE SID = {0}", strIDs,strEmptyCheck(Thick),strEmptyCheck(BulkDens),strEmptyCheck(FlowRes),strEmptyCheck(Sfactor),strEmptyCheck(Prosity),strEmptyCheck(ViscousCL), strEmptyCheck(ThermalCL),strEmptyCheck(Ymodulus),strEmptyCheck(PoissionR),strEmptyCheck(LossFactor),strEmptyCheck(strM_ID), strVendor,strProducing,strRemark,strDate); common_DataBase.ExecuteNonQuery_Text(); }