public static SqlDataReader ReaderSelect(NIChannelSettingData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from NIChannelSetting ");
return(WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString()));
}
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
exInfo = DAL.ExInfoDataFactory.Construct(exDT.Rows[e.RowIndex]);
List <DAL.NIChannelSettingData> aiList = new List <DAL.NIChannelSettingData>();
aiNameList = exInfo.NI9188Mod.Split('|');
string strSQL = "select * from NIChannelSetting where ( ";
foreach (string ai in aiNameList)
{
strSQL += "ID=" + ai + " OR ";
}
strSQL = strSQL.Substring(0, strSQL.Length - 4);
strSQL += ")";
aidt = WFNetLib.ADO.SQLServerOP.DataTableSQL(strSQL);
for (int i = 0; i < aidt.Rows.Count; i++)
{
DAL.NIChannelSettingData ai = DAL.NIChannelSettingDataFactory.Construct(aidt.Rows[i]);
aiList.Add(ai);
}
strSQL = "select * from ExData where ExID=" + exInfo.ID.ToString();
exData = WFNetLib.ADO.SQLServerOP.DataTableSQL(strSQL);
ExcelEx = new ExcelExport(exData.Rows.Count);
ExcelEx.ExcelWorkbookCallbackProc = new ExcelExport.ExcelWorkbookCallback(ExcelWorkbookCallbackProc);
ExcelEx.ExcelExportProc();
}
public static DataTable DataTableSelect(NIChannelSettingData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from NIChannelSetting where ID=");
sql.Append("");
sql.Append(d.ID.ToString());
sql.Append("");
return(WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString()));
}
public static int Delete(NIChannelSettingData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from NIChannelSetting ");
sql.Append(" where ID=");
sql.Append("");
sql.Append(d.ID.ToString());
sql.Append("");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static int Update(NIChannelSettingData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("update NIChannelSetting set ");
sql.Append("物理通道=");
sql.Append("'");
sql.Append(d.物理通道.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("名称=");
sql.Append("'");
sql.Append(d.称.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("工位号=");
sql.Append("'");
sql.Append(d.工位号.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("规格型号=");
sql.Append("'");
sql.Append(d.规格型号.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("安装位置=");
sql.Append("'");
sql.Append(d.安装位置.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("厂家及项目来源=");
sql.Append("'");
sql.Append(d.厂家及项目来源.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("备注1=");
sql.Append("'");
sql.Append(d.备注1.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("备注2=");
sql.Append("'");
sql.Append(d.备注2.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("备注3=");
sql.Append("'");
sql.Append(d.备注3.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("是否远传=");
sql.Append("");
if (d.是否远传)
{
sql.Append("1");
}
else
{
sql.Append("0");
}
sql.Append("");
sql.Append(", ");
sql.Append("通道配置项=");
sql.Append("");
sql.Append(d.通道配置项.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("最小值=");
sql.Append("");
sql.Append(d.最小值.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("最大值=");
sql.Append("");
sql.Append(d.最大值.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("I_4mA=");
sql.Append("");
sql.Append(d.I_4mA.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("I_20mA=");
sql.Append("");
sql.Append(d.I_20mA.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("物理量单位=");
sql.Append("'");
sql.Append(d.物理量单位.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Calc_k=");
sql.Append("");
sql.Append(d.Calc_k.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("Calc_b=");
sql.Append("");
sql.Append(d.Calc_b.ToString());
sql.Append("");
sql.Append(" where ID=");
sql.Append("");
sql.Append(d.ID.ToString()); sql.Append("");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static int Insert(NIChannelSettingData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into NIChannelSetting (");
sql.Append("物理通道, ");
sql.Append("名称, ");
sql.Append("工位号, ");
sql.Append("规格型号, ");
sql.Append("安装位置, ");
sql.Append("厂家及项目来源, ");
sql.Append("备注1, ");
sql.Append("备注2, ");
sql.Append("备注3, ");
sql.Append("是否远传, ");
sql.Append("通道配置项, ");
sql.Append("最小值, ");
sql.Append("最大值, ");
sql.Append("I_4mA, ");
sql.Append("I_20mA, ");
sql.Append("物理量单位, ");
sql.Append("Calc_k, ");
sql.Append("Calc_b");
sql.Append(") values (");
sql.Append("'");
sql.Append(d.物理通道.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.称.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.工位号.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.规格型号.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.安装位置.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.厂家及项目来源.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.备注1.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.备注2.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.备注3.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("");
if (d.是否远传)
{
sql.Append("1");
}
else
{
sql.Append("0");
}
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.通道配置项.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.最小值.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.最大值.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.I_4mA.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.I_20mA.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("'");
sql.Append(d.物理量单位.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("");
sql.Append(d.Calc_k.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.Calc_b.ToString());
sql.Append("");
sql.Append(")");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static NIChannelSettingData Construct(DataRow dr)
{
NIChannelSettingData data = new NIChannelSettingData();
try { data.ID = Convert.ToInt32(dr["ID"]); }
catch { }
try { data.物理通道 = Convert.ToString(dr["物理通道"]); }
catch { }
try { data.称 = Convert.ToString(dr["名称"]); }
catch { }
try { data.工位号 = Convert.ToString(dr["工位号"]); }
catch { }
try { data.规格型号 = Convert.ToString(dr["规格型号"]); }
catch { }
try { data.安装位置 = Convert.ToString(dr["安装位置"]); }
catch { }
try { data.厂家及项目来源 = Convert.ToString(dr["厂家及项目来源"]); }
catch { }
try { data.备注1 = Convert.ToString(dr["备注1"]); }
catch { }
try { data.备注2 = Convert.ToString(dr["备注2"]); }
catch { }
try { data.备注3 = Convert.ToString(dr["备注3"]); }
catch { }
try { data.是否远传 = Convert.ToBoolean(dr["是否远传"]); }
catch { }
try { data.通道配置项 = Convert.ToInt32(dr["通道配置项"]); }
catch { }
try { data.最小值 = Convert.ToDouble(dr["最小值"]); }
catch { }
try { data.最大值 = Convert.ToDouble(dr["最大值"]); }
catch { }
try { data.I_4mA = Convert.ToDouble(dr["I_4mA"]); }
catch { }
try { data.I_20mA = Convert.ToDouble(dr["I_20mA"]); }
catch { }
try { data.物理量单位 = Convert.ToString(dr["物理量单位"]); }
catch { }
try { data.Calc_k = Convert.ToDouble(dr["Calc_k"]); }
catch { }
try { data.Calc_b = Convert.ToDouble(dr["Calc_b"]); }
catch { }
return(data);
}
public static NIChannelSettingData Construct(DataGridView dgv, int rowIndex)
{
NIChannelSettingData data = new NIChannelSettingData();
if (dgv.Rows.Count < rowIndex + 1)
{
return(null);
}
DataGridViewCellCollection dr = dgv.Rows[rowIndex].Cells;
if (dr == null)
{
return(null);
}
try { data.ID = Convert.ToInt32(dr["ID"]); }
catch { }
try { data.物理通道 = Convert.ToString(dr["物理通道"]); }
catch { }
try { data.称 = Convert.ToString(dr["名称"]); }
catch { }
try { data.工位号 = Convert.ToString(dr["工位号"]); }
catch { }
try { data.规格型号 = Convert.ToString(dr["规格型号"]); }
catch { }
try { data.安装位置 = Convert.ToString(dr["安装位置"]); }
catch { }
try { data.厂家及项目来源 = Convert.ToString(dr["厂家及项目来源"]); }
catch { }
try { data.备注1 = Convert.ToString(dr["备注1"]); }
catch { }
try { data.备注2 = Convert.ToString(dr["备注2"]); }
catch { }
try { data.备注3 = Convert.ToString(dr["备注3"]); }
catch { }
try { data.是否远传 = Convert.ToBoolean(dr["是否远传"]); }
catch { }
try { data.通道配置项 = Convert.ToInt32(dr["通道配置项"]); }
catch { }
try { data.最小值 = Convert.ToDouble(dr["最小值"]); }
catch { }
try { data.最大值 = Convert.ToDouble(dr["最大值"]); }
catch { }
try { data.I_4mA = Convert.ToDouble(dr["I_4mA"]); }
catch { }
try { data.I_20mA = Convert.ToDouble(dr["I_20mA"]); }
catch { }
try { data.物理量单位 = Convert.ToString(dr["物理量单位"]); }
catch { }
try { data.Calc_k = Convert.ToDouble(dr["Calc_k"]); }
catch { }
try { data.Calc_b = Convert.ToDouble(dr["Calc_b"]); }
catch { }
return(data);
}
