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