public IActionResult Get() { try { string cmd = string.Format("execute facturas_selectAll "); DataSet Ds = SqlServerDbConn.Ejecutar(cmd); object[] data = new object[Ds.Tables[0].Rows.Count]; for (int i = 1; i <= Ds.Tables[0].Rows.Count; i++) { data[i - 1] = Ds.Tables[0].Rows[i - 1]; } string JSONresult; JSONresult = JsonConvert.SerializeObject(Ds.Tables[0]); string dataArray = "{\"Data\":" + JSONresult + "}"; return(Ok(dataArray)); } catch (Exception err) { string message = "[{\"status\":\"" + err.Message + "\"}]"; return(StatusCode(200, message)); } }
private SqlServerDbConn GetConnInfo(string sqlCommand) { SqlServerDbConn tmp = new SqlServerDbConn(); tmp.sqlConnection = SqlConn; tmp.sqlCommand = new SqlCommand(sqlCommand, tmp.sqlConnection); return(tmp); }
public static void Register(this System.Windows.Forms.ComboBox comboBox, string a_strSql, string s_strDisplay, string s_strValue) { SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(a_strSql)) { comboBox.Items.Clear(); comboBox.DataSource = SSD.Data.Tables[0]; comboBox.DisplayMember = s_strDisplay; comboBox.ValueMember = s_strValue; } }
public static void Register(this System.Windows.Forms.ComboBox comboBox, string a_strType) { string sqlStr = string.Format("select * from simple_code where simple_type ='{0}'", a_strType); SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(sqlStr)) { comboBox.Items.Clear(); comboBox.DataSource = SSD.Data.Tables[0]; comboBox.DisplayMember = "simple_name_cn"; comboBox.ValueMember = "simple_no"; } }
public static void Register(this QLComboBox comboBox, string a_strSql, string s_strDisplay, string s_strValue) { SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(a_strSql)) { DBComboBox a_cbo = (comboBox.InnerEditor) as DBComboBox; a_cbo.Items.Clear(); foreach (DataRow l_row in SSD.Data.Tables[0].Rows) { a_cbo.AddItem(l_row[s_strDisplay].ToString(), l_row[s_strValue].ToString()); } } }
public static void Register(this RepositoryItemComboBox l_edit, string a_strSql, string s_strDisplay, string s_strValue) { SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(a_strSql)) { l_edit.Items.Clear(); foreach (DataRow row in SSD.Data.Tables[0].Rows) { l_edit.Items.Add(s_strDisplay); } l_edit.TextEditStyle = TextEditStyles.Standard; } }
public static void Register(this QLComboBox comboBox, string a_strType) { string sqlStr = string.Format("select * from simple_code where simple_type ='{0}'", a_strType); SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(sqlStr)) { DBComboBox a_cbo = (comboBox.InnerEditor) as DBComboBox; a_cbo.Items.Clear(); foreach (DataRow l_row in SSD.Data.Tables[0].Rows) { a_cbo.AddItem(l_row["simple_name_cn"].ToString(), l_row["simple_no"].ToString()); } } }
public static void Register(this RepositoryItemComboBox l_edit, string a_strType) { string sqlStr = string.Format("select * from simple_code where simple_type ='{0}'", a_strType); SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(sqlStr)) { l_edit.Items.Clear(); foreach (DataRow row in SSD.Data.Tables[0].Rows) { l_edit.Items.Add(row["simple_name_cn"].ToString()); } l_edit.TextEditStyle = TextEditStyles.Standard; } }
public IActionResult Put(Data d) { try { string cmd = string.Format("execute recorrer_arrayJson '{0}'" , d.jsonstring.Trim() ); DataSet Ds = SqlServerDbConn.Ejecutar(cmd); return(Ok(Ds)); } catch (Exception err) { return(StatusCode(400, "Revise la sentencia sql" + err)); } }
public IActionResult Post(StringConnection s) { try { string cmd = string.Format("execute articulos_insert '{0}','{1}','{2}','{3}'" , s.source.Trim() , s.database.Trim() , s.user.Trim() , s.password.Trim()); DataSet Ds = SqlServerDbConn.Ejecutar(cmd); return(Ok(Ds)); } catch (Exception err) { return(StatusCode(400, "Revise la sentencia sql" + err)); } }
public IActionResult Get(string user, string pass) { try { string cmd = string.Format("execute demoLogin '{0}','{1}'" , user.Trim() , pass.Trim() ); DataSet Ds = SqlServerDbConn.Ejecutar(cmd); return(Ok(Ds.Tables)); } catch (Exception err) { string message = "[{\"status\":\"" + err.Message + "\"}]"; return(StatusCode(400, message)); } }
public IActionResult Get() { try { string cmd = string.Format("select * from usr_usuarios "); DataSet Ds = SqlServerDbConn.Ejecutar(cmd); string JSONresult; JSONresult = JsonConvert.SerializeObject(Ds.Tables[0]); string dataArray = "{\"Data\":" + JSONresult + "}"; return(Ok(dataArray)); } catch (Exception err) { string message = "[{\"status\":\"" + err.Message + "\"}]"; return(StatusCode(200, message)); } }
public static void Register(this RepositoryItemLookUpEdit l_edit, string a_strSql, string s_strDisplay, string s_strValue) { SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(a_strSql)) { l_edit.PopupFormMinSize = new System.Drawing.Size(10, 10); l_edit.PopupFormSize = new System.Drawing.Size(10, 10); l_edit.Columns.Clear(); l_edit.Columns.Add(new LookUpColumnInfo(s_strDisplay, "")); l_edit.ShowFooter = false; l_edit.ShowHeader = false; l_edit.ReadOnly = false; l_edit.DisplayMember = s_strDisplay; l_edit.ValueMember = s_strValue; l_edit.TextEditStyle = TextEditStyles.DisableTextEditor; l_edit.Properties.DataSource = SSD.Data.Tables[0]; l_edit.DropDownRows = Math.Min(10, SSD.Data.Tables[0].Rows.Count); l_edit.NullText = ""; } }
public static void Register(this RepositoryItemLookUpEdit l_edit, string a_strType) { string sqlStr = string.Format("select * from simple_code where simple_type ='{0}'", a_strType); SqlServerDbConn SSD = new SqlServerDbConn(); if (SSD.GetData(sqlStr)) { l_edit.PopupFormMinSize = new System.Drawing.Size(10, 10); l_edit.PopupFormSize = new System.Drawing.Size(10, 10); l_edit.Columns.Clear(); l_edit.Columns.Add(new LookUpColumnInfo("simple_name_cn", "")); l_edit.ShowFooter = false; l_edit.ShowHeader = false; l_edit.ReadOnly = false; l_edit.DisplayMember = "simple_name_cn"; l_edit.ValueMember = "simple_no"; l_edit.TextEditStyle = TextEditStyles.DisableTextEditor; l_edit.Properties.DataSource = SSD.Data.Tables[0]; l_edit.DropDownRows = Math.Min(10, SSD.Data.Tables[0].Rows.Count); l_edit.NullText = ""; } }
public IActionResult Post(Chat c) { try { string cmd = string.Format("exec chats_insert '{0}','{1}','{2}' ", c.ct_usr_sender.ToString() , c.ct_usr_receptor.ToString() , c.ct_mensaje.Trim()); DataSet Ds = SqlServerDbConn.Ejecutar(cmd); string JSONresult; JSONresult = JsonConvert.SerializeObject(Ds.Tables[0]); string dataArray = "{\"Data\":" + JSONresult + "}"; return(Ok(dataArray)); } catch (Exception err) { string message = "[{\"status\":\"" + err.Message + "\"}]"; return(StatusCode(200, message)); } }
public int CommitButton(AlarmInfo classValue) { if (DHCKSQLServerDatabase.comboBoxIndex == 0) { string sqlStr = "INSERT INTO 报警状态记录表 VALUES(@报警级别,@报警时间,@报警地点,@报警类型,@处理状态,@处理人,@处理时间,@处理说明)"; //string sqlStr = "INSERT INTO 报警状态记录表 VALUES(@报警级别,@报警地点,@报警类型,@处理状态,@处理人,@处理说明)"; //SqlConn = new SqlConnection(connectionString_preload); //SqlCommand sqlCommand = new SqlCommand(sqlStr,SqlConn); SqlServerDbConn sqlServerConnInfo = new SqlServerDbConn(SqlConn, GetConnInfo(sqlStr).sqlCommand); SqlCommand sqlCommand = sqlServerConnInfo.sqlCommand; sqlCommand.Parameters.Add("@报警级别", SqlDbType.Char, 8).Value = classValue.AlarmLevel; sqlCommand.Parameters.Add("@报警时间", SqlDbType.DateTime, 8).Value = classValue.AlarmDate; sqlCommand.Parameters.Add("@报警地点", SqlDbType.Char, 8).Value = classValue.AlarmLocation; sqlCommand.Parameters.Add("@报警类型", SqlDbType.Char, 8).Value = classValue.AlarmType; sqlCommand.Parameters.Add("@处理状态", SqlDbType.Char, 8).Value = classValue.ProcessState; sqlCommand.Parameters.Add("@处理人", SqlDbType.Char, 8).Value = classValue.Staff; sqlCommand.Parameters.Add("@处理时间", SqlDbType.DateTime, 8).Value = classValue.ProcessDate; sqlCommand.Parameters.Add("@处理说明", SqlDbType.Char, 8).Value = classValue.ProcessInfo; SqlConn.Open(); sqlCommand.ExecuteNonQuery(); SqlConn.Close(); return(0); } else if (DHCKSQLServerDatabase.comboBoxIndex == 1) { //string sqlStr = "SELECT * FROM 报警状态记录表 WHERE 报警地点 LIKE '%" + classValue.AlarmLocation + "%'"; string sqlStr = "SELECT * FROM 报警状态记录表 "; if (classValue.AlarmLevel != "") { sqlStr += "WHERE 报警级别 LIKE '%" + classValue.AlarmLevel + "%'"; } //if (classValue.AlarmDate.ToString() != "") //{ // sqlStr += "AND 报警时间 LIKE '%" + classValue.AlarmDate.ToString() + "%' "; //} if (classValue.AlarmLocation != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "AND "; } sqlStr += " 报警地点 LIKE '%" + classValue.AlarmLocation + "%'"; } if (classValue.AlarmType != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "AND "; } sqlStr += " 报警类型 LIKE '%" + classValue.AlarmType + "%'"; } if (classValue.ProcessState != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "AND "; } sqlStr += " 处理状态 LIKE '%" + classValue.ProcessState + "%'"; } if (classValue.Staff != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "AND "; } sqlStr += " 处理人 LIKE '%" + classValue.Staff + "%'"; } if (classValue.ProcessInfo != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "AND "; } sqlStr += " 处理说明 LIKE '%" + classValue.ProcessInfo + "%'"; } SqlConn.Open(); SqlCommand sc = new SqlCommand(sqlStr, SqlConn); SqlDataAdapter adapter = new SqlDataAdapter(sc); DataSet dstable = new DataSet(); adapter.Fill(dstable, "testTable"); SearchDstable = dstable; SqlConn.Close(); SqlConn.Dispose(); return(1); } else { string sqlStr = "SELECT * FROM 报警状态记录表 "; if (classValue.AlarmLevel != "") { sqlStr += "WHERE 报警级别 LIKE '%" + classValue.AlarmLevel + "%'"; } //if (classValue.AlarmDate.ToString() != "") //{ // sqlStr += "AND 报警时间 LIKE '%" + classValue.AlarmDate.ToString() + "%' "; //} if (classValue.AlarmLocation != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "OR "; } sqlStr += " 报警地点 LIKE '%" + classValue.AlarmLocation + "%'"; } if (classValue.AlarmType != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "OR "; } sqlStr += " 报警类型 LIKE '%" + classValue.AlarmType + "%'"; } if (classValue.ProcessState != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "OR "; } sqlStr += " 处理状态 LIKE '%" + classValue.ProcessState + "%'"; } if (classValue.Staff != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "OR "; } sqlStr += " 处理人 LIKE '%" + classValue.Staff + "%'"; } if (classValue.ProcessInfo != "") { if (sqlStr[sqlStr.Length - 1] == ' ') { sqlStr += "WHERE "; } else { sqlStr += "OR "; } sqlStr += " 处理说明 LIKE '%" + classValue.ProcessInfo + "%'"; } SqlConn.Open(); SqlCommand sc = new SqlCommand(sqlStr, SqlConn); SqlDataAdapter adapter = new SqlDataAdapter(sc); DataSet dstable = new DataSet(); adapter.Fill(dstable, "testTable"); SearchDstable = dstable; SqlConn.Close(); SqlConn.Dispose(); return(2); } }