void edit(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.GeneralAssemblyGEBEntity _geb) { strSql = new StringBuilder( ); strSql.Append("UPDATE MOXGEB SET "); strSql.Append("GEB002=@GEB002,"); strSql.Append("GEB003=@GEB003,"); strSql.Append("GEB004=@GEB004,"); strSql.Append("GEB005=@GEB005,"); strSql.Append("GEB007=@GEB007 "); strSql.Append("WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@GEB002", SqlDbType.NVarChar, 50), new SqlParameter("@GEB003", SqlDbType.NVarChar, 200), new SqlParameter("@GEB004", SqlDbType.NVarChar, 200), new SqlParameter("@GEB005", SqlDbType.NVarChar, 50), new SqlParameter("@GEB007", SqlDbType.Date, 3), new SqlParameter("@idx", SqlDbType.NVarChar, 50) }; parameter [0].Value = _geb.GEB002; parameter [1].Value = _geb.GEB003; parameter [2].Value = _geb.GEB004; parameter [3].Value = _geb.GEB005; parameter [4].Value = _geb.GEB007; parameter [5].Value = _geb.idx; SQLString.Add(strSql, parameter); }
void add_geb(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.GeneralAssemblyGEBEntity _geb) { strSql = new StringBuilder( ); strSql.Append("INSERT INTO MOXGEB ("); strSql.Append("GEB001,GEB002,GEB003,GEB004,GEB005,GEB006,GEB007,GEB008) "); strSql.Append("VALUES ("); strSql.Append("@GEB001,@GEB002,@GEB003,@GEB004,@GEB005,@GEB006,@GEB007,@GEB008) "); SqlParameter [] parameteer = { new SqlParameter("@GEB001", SqlDbType.NVarChar, 50), new SqlParameter("@GEB002", SqlDbType.NVarChar, 50), new SqlParameter("@GEB003", SqlDbType.NVarChar, 200), new SqlParameter("@GEB004", SqlDbType.NVarChar, 200), new SqlParameter("@GEB005", SqlDbType.NVarChar, 50), new SqlParameter("@GEB006", SqlDbType.Int, 4), new SqlParameter("@GEB007", SqlDbType.Date, 3), new SqlParameter("@GEB008", SqlDbType.NVarChar, 50) }; parameteer [0].Value = _geb.GEB001; parameteer [1].Value = _geb.GEB002; parameteer [2].Value = _geb.GEB003; parameteer [3].Value = _geb.GEB004; parameteer [4].Value = _geb.GEB005; parameteer [5].Value = _geb.GEB006; parameteer [6].Value = _geb.GEB007; parameteer [7].Value = _geb.GEB008; SQLString.Add(strSql, parameteer); }
/// <summary> /// edit data to database /// </summary> /// <param name="table"></param> /// <returns></returns> public bool Save(DataTable table) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); ProductionErpEntity.GeneralAssemblyGEAEntity _gea = new ProductionErpEntity.GeneralAssemblyGEAEntity( ); ProductionErpEntity.GeneralAssemblyGEBEntity _geb = new ProductionErpEntity.GeneralAssemblyGEBEntity( ); for (int i = 0; i < table.Rows.Count; i++) { _geb.GEB001 = table.Rows [i] ["GEB001"].ToString( ); _geb.GEB002 = table.Rows [i] ["GEB002"].ToString( ); _geb.GEB003 = table.Rows [i] ["GEB003"].ToString( ); _geb.GEB004 = table.Rows [i] ["GEB004"].ToString( ); _geb.GEB005 = table.Rows [i] ["GEB005"].ToString( ); if (table.Rows [i] ["GEB007"] == null) { _geb.GEB007 = null; } else { _geb.GEB007 = Convert.ToDateTime(table.Rows [i] ["GEB007"].ToString( )); } _geb.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( )); if (Exists(_geb.idx)) { edit(SQLString, strSql, _geb); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// add data to database /// </summary> /// <param name="codeNum"></param> /// <returns></returns> public bool Add(string codeNum) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); ProductionErpEntity.GeneralAssemblyGEAEntity _gea = new ProductionErpEntity.GeneralAssemblyGEAEntity( ); ProductionErpEntity.GeneralAssemblyGEBEntity _geb = new ProductionErpEntity.GeneralAssemblyGEBEntity( ); _gea.GEA001 = _geb.GEB001 = codeNum; DataTable table = getWinBase(codeNum); if (table != null && table.Rows.Count > 0) { _gea.GEA002 = table.Rows [0] ["SRT003"].ToString( ); _gea.GEA003 = table.Rows [0] ["SRT004"].ToString( ); _gea.GEA004 = table.Rows [0] ["SRT005"].ToString( ); _gea.GEA005 = table.Rows [0] ["SRT010"].ToString( ); add_gea(SQLString, strSql, _gea); } else { return(false); } _geb.GEB003 = string.Empty; _geb.GEB004 = string.Empty; _geb.GEB005 = null; _geb.GEB007 = null; add_geb_para(SQLString, strSql, _geb); return(SqlHelper.ExecuteSqlTran(SQLString)); }
void edit_geb(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.GeneralAssemblyGEBEntity _geb) { strSql = new StringBuilder( ); strSql.Append("UPDATE MOXGEB SET "); strSql.Append("GEB002=@GEB002 "); strSql.Append("WHERE GEB001=@GEB001 AND GEB003=@GEB003"); SqlParameter [] parameteer = { new SqlParameter("@GEB001", SqlDbType.NVarChar, 50), new SqlParameter("@GEB002", SqlDbType.NVarChar, 50), new SqlParameter("@GEB003", SqlDbType.NVarChar, 200) }; parameteer [0].Value = _geb.GEB001; parameteer [1].Value = _geb.GEB002; parameteer [2].Value = _geb.GEB003; SQLString.Add(strSql, parameteer); }
public FormGeneralAssembly( ) { InitializeComponent( ); _gea = new ProductionErpEntity.GeneralAssemblyGEAEntity( ); _geb = new ProductionErpEntity.GeneralAssemblyGEBEntity( ); _bll = new ProductionErpBll.Bll.GeneralAssemblyBll( ); tableView = new DataTable( ); Utility.GridViewMoHuSelect.SetFilter(gridView1); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); barMenu.LinksPersistInfo.RemoveAt(toolExport.Id); barMenu.LinksPersistInfo.RemoveAt(toolDelete.Id); barMenu.LinksPersistInfo.RemoveAt(toolAdd.Id); wait.Hide( ); gridView1.OptionsBehavior.Editable = false; }
void readResult(string codeNum) { StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("SELECT GEC005,GEC006,GEC007,GEC008,GEC009,GEC010,GEC011,GEC012,GEC013,GEC014,GEC015,GEC017,GEC018,GEC019,GEC020,GEC023,GEC024,GEC025,GEC026,GEC027 FROM MOXGEC WHERE GEC001='{0}'", codeNum); DataTable table = SqlHelper.ExecuteDataTable(strSql.ToString( )); if (table == null || table.Rows.Count < 1) { return; } Hashtable SQLString = new Hashtable( ); ProductionErpEntity.GeneralAssemblyGEBEntity model = new ProductionErpEntity.GeneralAssemblyGEBEntity( ); model.GEB001 = codeNum; string result = table.Rows [0] ["GEC005"].ToString( ); model.GEB003 = "耐压(电机线圈对机壳)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC006"].ToString( ); model.GEB003 = "耐压(制动器线圈对机壳)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC007"].ToString( ); model.GEB003 = "绝缘(电机线圈对机壳)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC008"].ToString( ); model.GEB003 = "绝缘(制动器线圈对机壳)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC009"].ToString( ); model.GEB003 = "直流电阻UV(V)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC010"].ToString( ); model.GEB003 = "直流电阻UW(V)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC011"].ToString( ); model.GEB003 = "直流电阻VW(V)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC012"].ToString( ); model.GEB003 = "直流电阻平均值(V)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC013"].ToString( ); model.GEB003 = "直流电阻判定结果"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC014"].ToString( ); model.GEB003 = "制动器电阻数值1"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC015"].ToString( ); model.GEB003 = "制动器电阻数值2"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC017"].ToString( ); model.GEB003 = "振动速度(mm/s)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC018"].ToString( ); model.GEB003 = "制动器最低启动电压能吸合"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC019"].ToString( ); model.GEB003 = "检测制动器开关动作次数(次)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC023"].ToString( ); model.GEB003 = "制动力矩(电流法)1"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC024"].ToString( ); model.GEB003 = "制动力矩(电流法)2"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC025"].ToString( ); model.GEB003 = "空载电流(A)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC026"].ToString( ); model.GEB003 = "空载电压(V)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : Convert.ToInt32(result) == 0 ? "不合格" : "合格"; edit_geb(SQLString, strSql, model); result = table.Rows [0] ["GEC027"].ToString( ); model.GEB003 = "空载功率(KW)"; model.GEB004 = string.IsNullOrEmpty(result) == true ? null : result; edit_geb(SQLString, strSql, model); SqlHelper.ExecuteSqlTran(SQLString); }
void add_geb_para(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.GeneralAssemblyGEBEntity _geb) { _geb.GEB002 = "装曳引轮和转子"; _geb.GEB003 = "曳引轮条码"; _geb.GEB006 = 1; _geb.GEB008 = "压轴承"; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "转子条码"; _geb.GEB006 = 2; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "贴磁钢"; _geb.GEB003 = "磁钢条码"; _geb.GEB006 = 3; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "压轴承"; _geb.GEB003 = "大轴承条码"; _geb.GEB006 = 4; add_geb(SQLString, strSql, _geb); //_geb . GEB003 = "转轴条码"; //_geb . GEB006 = 5; //add_geb ( SQLString ,strSql ,_geb ); _geb.GEB003 = "小轴承条码"; _geb.GEB006 = 5; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "转轴条码"; _geb.GEB006 = 6; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "压线圈"; _geb.GEB003 = "机座条码"; _geb.GEB006 = 7; _geb.GEB008 = "压线圈"; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "压线圈"; _geb.GEB003 = "定子绕组条码"; _geb.GEB006 = 8; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "总装合成"; _geb.GEB003 = "编码器条码"; _geb.GEB006 = 9; _geb.GEB008 = "静音房"; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "装制动器"; _geb.GEB003 = "制动器左条码"; _geb.GEB006 = 10; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动器右条码"; _geb.GEB006 = 11; add_geb(SQLString, strSql, _geb); _geb.GEB002 = "检验"; _geb.GEB003 = "耐压(电机线圈对机壳)"; _geb.GEB006 = 12; _geb.GEB008 = ""; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "耐压(制动器线圈对机壳)"; _geb.GEB006 = 13; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "绝缘(电机线圈对机壳)"; _geb.GEB006 = 14; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "绝缘(制动器线圈对机壳)"; _geb.GEB006 = 15; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "直流电阻UV(V)"; _geb.GEB006 = 16; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "直流电阻UW(V)"; _geb.GEB006 = 17; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "直流电阻VW(V)"; _geb.GEB006 = 18; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "直流电阻平均值(V)"; _geb.GEB006 = 19; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "直流电阻判定结果"; _geb.GEB006 = 20; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动器电阻数值1"; _geb.GEB006 = 21; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动器电阻数值2"; _geb.GEB006 = 22; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "噪音(dB)"; _geb.GEB006 = 23; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "振动速度(mm/s)"; _geb.GEB006 = 24; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动器最低启动电压能吸合"; _geb.GEB006 = 25; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "检测制动器开关动作次数(次)"; _geb.GEB006 = 26; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动器吸合噪音(dB)"; _geb.GEB006 = 27; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动器释放噪音(dB)"; _geb.GEB006 = 28; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动力矩(电流法)1"; _geb.GEB006 = 29; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "制动力矩(电流法)2"; _geb.GEB006 = 30; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "空载电流(A)"; _geb.GEB006 = 31; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "空载电压(V)"; _geb.GEB006 = 32; add_geb(SQLString, strSql, _geb); _geb.GEB003 = "空载功率(KW)"; _geb.GEB006 = 33; add_geb(SQLString, strSql, _geb); }