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();
}