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