📄 datasql.cs
字号:
try
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
tele.Text = reader["Amovephone"].ToString() + "/" + reader["Amovephone"].ToString();
address.Text = reader["City"].ToString() + reader["Town"].ToString() + reader["village"].ToString();
}
reader.Close();
connection.Close();
return "ok";
}
catch (Exception exception)
{
return exception.Message.ToString();
}
}
public string kQingKuang(string workType, string village, string daozhong, string Years, Label Type, Label ActuarArea, Label area, Label Mcount, Label jqsyl)
{
try
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select_kQingKuang", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@workType", workType);
command.Parameters.Add("@ActualArea", "");
command.Parameters.Add("@village", village);
command.Parameters.Add("@daozhong", daozhong);
command.Parameters.Add("@Years", Years);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Type.Text = reader["workType"].ToString();
ActuarArea.Text = reader["ActualArea"].ToString();
area.Text = reader["area"].ToString();
Mcount.Text = reader["Mcount"].ToString();
jqsyl.Text = reader["jqsyl"].ToString();
}
reader.Close();
connection.Close();
if (jqsyl.Text == "")
{
jqsyl.Text = "0.0";
}
return "ok";
}
catch (Exception exception)
{
return exception.Message.ToString();
}
}
public bool Login(string table, string user, string pas, Label type, Label id, Label City, Label Town, Label adminiType)
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand(table, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@AIDCard", user);
command.Parameters.Add("@APassword", pas);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
id.Text = reader["AID"].ToString();
City.Text = reader["City"].ToString();
Town.Text = reader["Town"].ToString();
adminiType.Text = reader["adminiType"].ToString();
type.Text = reader["type"].ToString();
reader.Close();
connection.Close();
return true;
}
reader.Close();
connection.Close();
return false;
}
public bool Lonin(string table, string user, string pas)
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand(table, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@UIDCard", user);
command.Parameters.Add("@UPassword", pas);
connection.Open();
return command.ExecuteReader().Read();
}
public string Max_ZhuangTai()
{
try
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select max(zid)from ZhuangTai", connection);
connection.Open();
return command.ExecuteScalar().ToString();
}
catch (Exception exception)
{
return exception.Message.ToString();
}
}
public string nongtianworkQingKuang(string adminID, string workType, string daozhong, string Years, Label v, Label Type, Label ActuarArea, Label area, Label Mcount, Label jqsyl)
{
try
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select_nongtianworkQingKuang", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@adminID", adminID);
command.Parameters.Add("@workType", workType);
command.Parameters.Add("@ActualArea", "");
command.Parameters.Add("@village", "");
command.Parameters.Add("@daozhong", daozhong);
command.Parameters.Add("@Years", Years);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
v.Text = reader["village"].ToString();
Type.Text = reader["workType"].ToString();
ActuarArea.Text = reader["ActualArea"].ToString();
area.Text = reader["area"].ToString();
Mcount.Text = reader["Mcount"].ToString();
jqsyl.Text = reader["jqsyl"].ToString();
}
reader.Close();
connection.Close();
if (jqsyl.Text == "")
{
jqsyl.Text = "0.0";
}
return "ok";
}
catch (Exception exception)
{
return exception.Message.ToString();
}
}
public void PagedData(DataList Dt, int i)
{
try
{
PagedDataSource source = new PagedDataSource();
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand selectCommand = new SqlCommand(this.Select, connection);
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
source.DataSource = dataSet.Tables[0].DefaultView;
source.AllowPaging = true;
this.Count = source.Count;
source.PageSize = i;
source.CurrentPageIndex = this.CurrentPageindex - 1;
this.PageCounts = source.PageCount;
Dt.DataSource = source;
Dt.DataBind();
}
catch
{
}
}
public string QingKuangCity(string workType, string City, string daozhong, string Years, Label Type, Label ActuarArea, Label area, Label Mcount, Label jqsyl)
{
try
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select_QingKuangCity", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@workType", workType);
command.Parameters.Add("@ActualArea", "");
command.Parameters.Add("@City", City);
command.Parameters.Add("@daozhong", daozhong);
command.Parameters.Add("@Years", Years);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Type.Text = reader["workType"].ToString();
ActuarArea.Text = reader["ActualArea"].ToString();
area.Text = reader["area"].ToString();
Mcount.Text = reader["Mcount"].ToString();
jqsyl.Text = reader["jqsyl"].ToString();
}
reader.Close();
connection.Close();
if (jqsyl.Text == "")
{
jqsyl.Text = "0.0";
}
return "ok";
}
catch (Exception exception)
{
return exception.Message.ToString();
}
}
public string QingKuangTown(string workType, string City, string Town, string daozhong, string Years, Label Type, Label ActuarArea, Label area, Label Mcount, Label jqsyl)
{
try
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select_QingKuangTown", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@workType", workType);
command.Parameters.Add("@ActualArea", "");
command.Parameters.Add("@City", City);
command.Parameters.Add("@Town", Town);
command.Parameters.Add("@daozhong", daozhong);
command.Parameters.Add("@Years", Years);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Type.Text = reader["workType"].ToString();
ActuarArea.Text = reader["ActualArea"].ToString();
area.Text = reader["area"].ToString();
Mcount.Text = reader["Mcount"].ToString();
jqsyl.Text = reader["jqsyl"].ToString();
}
reader.Close();
connection.Close();
if (jqsyl.Text == "")
{
jqsyl.Text = "0.0";
}
return "ok";
}
catch (Exception exception)
{
return exception.Message.ToString();
}
}
public void QueXie(string name, HtmlTableCell t1, HtmlTableCell t2)
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select * from QueXian where type=@cards", connection);
command.Parameters.Add("@cards", name);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
t1.Visible = Convert.ToBoolean(reader["njxi"].ToString());
t2.Visible = Convert.ToBoolean(reader["addnj"].ToString());
}
reader.Close();
connection.Close();
}
public void QueXie(string name, HtmlTableCell t1, HtmlTableCell t2, HtmlTableCell t3)
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select * from QueXian where type=@cards", connection);
command.Parameters.Add("@cards", name);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
t1.Visible = Convert.ToBoolean(reader["ntdj"].ToString());
t2.Visible = Convert.ToBoolean(reader["ntxi"].ToString());
t3.Visible = Convert.ToBoolean(reader["zhuantai"].ToString());
}
reader.Close();
connection.Close();
}
public void QueXie(string name, HtmlTableCell t1, HtmlTableCell t2, HtmlTableCell t3, HtmlTableCell t4, HtmlTableCell t5, HtmlTableCell t6, HtmlTableCell t7, HtmlTableCell t8, HtmlTableCell t9, HtmlTableCell t10, HtmlTableCell t11, HtmlTableCell t12, HtmlTableCell t13, HtmlTableCell t14, HtmlTableCell t15, HtmlTableCell t16)
{
SqlConnection connection = new SqlConnection(this.Sqlconnection);
SqlCommand command = new SqlCommand("select * from QueXian where type=@cards", connection);
command.Parameters.Add("@cards", name);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -