public static void UpdateGDDK(GDDK gddk)
{
StringBuilder sql = new StringBuilder();
sql.Append("update ");
sql.Append("gdqk");
sql.Append(" set ");
sql.Append("DZJGH=@DZJGH,");
sql.Append("YDDW=@YDDW,");
sql.Append("GDMJ=@GDMJ,");
sql.Append("DG=@DG, ");
sql.Append("BZ=@BZ, ");
sql.Append("TDYT=@TDYT, ");
sql.Append("TDZL=@TDZL ");
sql.Append("where ");
sql.Append("ID= @ID ");
MySqlParameter[] pt = new MySqlParameter[] {
new MySqlParameter("@ID", gddk.Id),
new MySqlParameter("@DZJGH", gddk.Dzjgh),
new MySqlParameter("@YDDW", gddk.Xmmc),
new MySqlParameter("@GDMJ", gddk.Gdmj),
new MySqlParameter("@DG", gddk.Dgmj),
new MySqlParameter("@BZ", gddk.Bz),
new MySqlParameter("@TDZL", gddk.Tdzl),
new MySqlParameter("@TDYT", gddk.Tdyt)
};
try {
Helper.MySqlHelper.ExecuteNonQuery(Method.Conntection(), CommandType.Text, sql.ToString(), pt);
} catch (MySqlException ex) {
throw ex;
}
}
/// <summary>
/// 盘活批次导出生成行
/// </summary>
/// <param name="data">源数据</param>
/// <param name="index">序号</param>
/// <param name="dt">表</param>
/// <returns></returns>
private static DataRow DataRowPHInitialize(Data data, NZYDK nzydk, GDDK gddk, int index, DataTable dt)
{
DataRow row = dt.NewRow();//读至供地数据开始写入行
row[0] = index;
row[1] = "海宁市";
row[3] = data.GetArea() * 15;
row[4] = data.Nzy;
row[5] = nzydk.Dkmc;
row[6] = "是";
row[7] = nzydk.Dkmj * 15;
row[10] = nzydk.SYMJ() * 15;//地块剩面积
if (gddk != null)
{
row[11] = gddk.Dzjgh;
row[12] = gddk.Xmmc;
row[13] = gddk.Gdmj * 15;
row[15] = gddk.Tdyt;
row[14] = gddk.Tdzl;
}
else
{
}
return(row);
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (lswNZY.SelectedItems.Count > 0)
{
GDDK gddk = (GDDK)lswGDDK.SelectedItems[0].Tag;
DataOperation.DeleteGDDK(gddk);
MessageBox.Show("删除成功");
}
}
private void btnADD_Click(object sender, EventArgs e)
{
GDDK gddk = new GDDK();
Form2 fm = new Form2(gddk, true);
if (fm.ShowDialog() == DialogResult.OK)
{
DataOperation.GddkToMySQL(nzydk.Guid, gddk);
}
}
private void lswGDDK_DoubleClick(object sender, EventArgs e)
{
if (lswNZY.SelectedItems.Count > 0)
{
GDDK gddk = (GDDK)lswGDDK.SelectedItems[0].Tag;
Form2 fm = new Form2(gddk, false);
if (fm.ShowDialog() == DialogResult.OK)
{
DataOperation.UpdateGDDK(gddk);
}
}
}
public static void DeleteGDDK(GDDK gddk)
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from gdqk where ID =");
sql.Append(gddk.Id);
try {
Helper.MySqlHelper.ExecuteNonQuery(Method.Conntection(), CommandType.Text, sql.ToString(), null);
} catch (MySqlException ex) {
throw ex;
}
}
public static void MySQLGDRead(NZYDK nzydk)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"SELECT * FROM info.gdqk where DKGUID='");
sql.Append(nzydk.Guid);
sql.Append(@"'");
//MySqlParameter[] pt = new MySqlParameter[] {
// new MySqlParameter("@NZY", data.Guid)
//};
MySqlDataReader reader;
try {
reader = Helper.MySqlHelper.ExecuteReader(Method.Conntection(), CommandType.Text, sql.ToString(), null);
} catch (Exception) {
throw;
}
nzydk.Gddk = new List <GDDK>();
while (reader.Read())
{
GDDK gddk = new GDDK();
gddk.Guid = nzydk.Guid;
gddk.Dzjgh = reader.GetString("DZJGH");
gddk.Gdmj = reader.GetDecimal("GDMJ");
gddk.Xmmc = reader.GetString("YDDW");
gddk.Dgmj = reader.GetDecimal("DG");
gddk.Bz = (reader.IsDBNull(6)) ? "" : reader.GetString("BZ");
gddk.Id = reader.GetInt32("ID");
gddk.Tdyt = (reader.IsDBNull(4)) ? "":reader.GetString("TDYT");
gddk.Tdzl = (reader.IsDBNull(8)) ? "":reader.GetString("TDZL");
nzydk.Gddk.Add(gddk);
}
sql = new StringBuilder();
sql.Append(@"SELECT * FROM info.czfs where GUID='");
sql.Append(nzydk.Guid);
sql.Append(@"'");
try {
reader = Helper.MySqlHelper.ExecuteReader(Method.Conntection(), CommandType.Text, sql.ToString(), null);
} catch (Exception) {
throw;
}
while (reader.Read())
{
for (int i = 0; i < nzydk.Czfs.Length; i++)
{
nzydk.Czfs[i] = reader.GetDecimal((i + 20).ToString());
}
nzydk.Sx = reader.GetInt32(34.ToString());
}
}
public Form2(GDDK gddk, bool isNew)
{
InitializeComponent();
this.gddk = gddk;
if (!isNew)
{
tbxDZJGH.Text = gddk.Dzjgh.ToString();
tbxXMMC.Text = gddk.Xmmc.ToString();
tbxGDMJ.Text = gddk.Gdmj.ToString();
tbxDGMJ.Text = gddk.Dgmj.ToString();
tbxBZ.Text = gddk.Bz.ToString();
tbxTDYT.Text = gddk.Tdyt.ToString();
tbxTDZL.Text = gddk.Tdzl.ToString();
}
}
/// <summary>
/// 生成行
/// </summary>
/// <param name="data">源数据</param>
/// <param name="index">序号</param>
/// <param name="dt">表</param>
/// <returns></returns>
private static DataRow DataRowInitialize(Data data, NZYDK nzydk, GDDK gddk, int index, DataTable dt)
{
DataRow row = dt.NewRow();//读至供地数据开始写入行
row[0] = index;
row[1] = "海宁市";
row[2] = data.Nzy;
row[3] = ChangePCMC(data.Nzy);
row[4] = data.Pzwh;
row[5] = data.Pzrq.ToString("yyyy/M/d");
row[6] = nzydk.Dkmc;
row[7] = nzydk.Dkmj * 15;
row[8] = "是";
row[14] = nzydk.SYMJ() * 15;//地块剩余面积
row[36] = "周青峰";
row[37] = "0573-87289249";
if (gddk != null)
{
row[9] = gddk.Dzjgh;
row[10] = gddk.Xmmc;
row[11] = gddk.Gdmj * 15;
row[12] = gddk.Tdyt;
row[13] = data.GetSYMJ() * 15;//批次剩余面积
row[38] = nzydk.Bz + @"|" + gddk.Bz;
}
else
{
row[13] = data.GetSYMJ() * 15;//批次剩余面积
row[38] = nzydk.Bz;
}
for (int i = 0; i < 14; i++)
{
row[i + 19] = nzydk.Czfs[i] * 15;
}
if (nzydk.Sx != 0)
{
row[32 + nzydk.Sx] = "√";
}
return(row);
}
/// <summary>
/// 供地情况写入数据库
/// </summary>
/// <param name="guid"></param>
/// <param name="gddk"></param>
public static void GddkToMySQL(Guid guid, GDDK gddk)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into gdqk (");
sql.Append("DKGUID,");
sql.Append("DZJGH,");
sql.Append("YDDW,");
sql.Append("GDMJ,");
sql.Append("DG, ");
sql.Append("BZ, ");
sql.Append("TDZL, ");
sql.Append("TDYT ");
sql.Append(") values (");
sql.Append("@DKGUID,");
sql.Append("@DZJGH,");
sql.Append("@YDDW,");
sql.Append("@GDMJ,");
sql.Append("@DG,");
sql.Append("@BZ,");
sql.Append("@TDZL, ");
sql.Append("@TDYT )");
MySqlParameter[] pt = new MySqlParameter[] {
new MySqlParameter("@DKGUID", guid),
new MySqlParameter("@DZJGH", gddk.Dzjgh),
new MySqlParameter("@YDDW", gddk.Xmmc),
new MySqlParameter("@GDMJ", gddk.Gdmj),
new MySqlParameter("@DG", gddk.Dgmj),
new MySqlParameter("@BZ", gddk.Bz),
new MySqlParameter("@TDZL", gddk.Tdzl),
new MySqlParameter("@TDYT", gddk.Tdyt)
};
try {
Helper.MySqlHelper.ExecuteNonQuery(Method.Conntection(), CommandType.Text, sql.ToString(), pt);
} catch (Exception) {
throw;
}
}
private static List <Data> MySQLViewRead()
{
//Hashtable datas = new Hashtable();
List <Data> datas = new List <Data>();
StringBuilder sql = new StringBuilder();
sql.Append(@"SELECT * FROM info.nzy_view;");
MySqlDataReader reader;
try {
reader = Helper.MySqlHelper.ExecuteReader(Method.Conntection(), CommandType.Text, sql.ToString(), null);
} catch (Exception ex) {
throw new Exception(ex.Message);
}
while (reader.Read())
{
///初始化DATA
Data data = new Data();
///读取批次GUID
Guid guid = reader.GetGuid("GUID");
bool unExistData = true;//判断是是否存在该批次
foreach (Data origin in datas)
{
if (origin.Guid == guid)
{
data = origin;
unExistData = false;
break;
}
}
if (unExistData) //如果该批次存在
{
data.Guid = guid;
data.Nzy = reader.GetString("PCMC"); //批次名称
data.Pzwh = reader.GetString("PZWH"); //批准文号
data.Pzrq = reader.GetDateTime("PZRQ"); //批准日期
data.Pzmj = reader.GetDecimal("PZMJ"); //批准面积
datas.Add(data);
}
string dkmc = reader.GetString("DKMC");//地块名称
//NZYDK nzydk = data.IsExist(dkmc);//是否已存在该地块
NZYDK nzydk = new NZYDK();
bool unExist = true;//判断是否已存在该 农转用地块
foreach (NZYDK new_nzydk in data.Dk)
{
if (new_nzydk.Dkmc == dkmc)
{
nzydk = new_nzydk;
unExist = false;
}
}
if (unExist) //如果不存在
{
nzydk.Guid = reader.GetGuid("DKGUID"); //农转用地块GUID
nzydk.Dkmc = reader.GetString("DKMC"); //地块名称
nzydk.Dkmj = reader.GetDecimal("DKMJ"); //地块面积
///读取处置方式内容20-34列
for (int i = 20; i < 34; i++)
{
nzydk.Czfs[i - 20] = (reader.IsDBNull(i - 4)) ? 0 : reader.GetDecimal(i.ToString());
}
nzydk.Sx = (reader.IsDBNull(30)) ? 0 : reader.GetInt32("34");
data.Dk.Add(nzydk);
}
string yddw = (reader.IsDBNull(11)) ? "" : reader.GetString("YDDW"); //获取用地单位，如果不存在则为空
if (!string.IsNullOrEmpty(yddw)) //始果用地单位存在
{
GDDK gddk = new GDDK();
gddk.Xmmc = yddw;
gddk.Dzjgh = (reader.IsDBNull(10)) ? "" : reader.GetString("DZJGH"); //获取电子监管号，如果不存在则为空
gddk.Gdmj = reader.GetDecimal("GDMJ"); //获取供地面积
gddk.Dgmj = reader.GetDecimal("DG"); //获取带供面积
gddk.Tdzl = (reader.IsDBNull(31)) ? "" : reader.GetString("TDZL"); //土地坐落
gddk.Tdyt = (reader.IsDBNull(13)) ? "" : reader.GetString("TDYT"); //获取电子监管号，如果不存在则为空
gddk.Bz = ((reader.IsDBNull(8)) ? "" : reader.GetString("DKBZ"))
+ "|" +
((reader.IsDBNull(15)) ? "" : reader.GetString("BZ"));//获取备注，如果不存在则为空
nzydk.Gddk.Add(gddk);
}
}
//List<Data> result = new List<Data>();
//foreach (Data data in datas.Values) {
// result.Add(data);
//}
return(datas);
}
private static List <Data> DatatableRead(DataTable dt)
{
List <Data> result = new List <Data>();
Data data = new Data();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string pzwh = dr["批准文号"].ToString();
#region 如果不存在该批准文号并且该栏不为空
if (!IsExist(result, pzwh) && !String.IsNullOrWhiteSpace(pzwh))
{
data = new Data(pzwh);
//data.Pzwh = pzwh;
data.Nzy = dr["批次名称"].ToString();
try {
DateTime pzrq = new DateTime();
if (DateTime.TryParse(dr["批准时间"].ToString(), out pzrq))
{
data.Pzrq = pzrq;
}
} catch (Exception) {
throw new Exception("wrong datetime");
}
result.Add(data);
}
#endregion
NZYDK nzydk = new NZYDK();
string dkmc = dr["地块名称"].ToString();
#region 如果该栏不为空
if (!String.IsNullOrWhiteSpace(dkmc))
{
nzydk = data.IsExist(dkmc);
//nzydk.Dkmc = dkmc;
Decimal dkmj = new decimal();
try {
if (Decimal.TryParse(dr["地块面积"].ToString(), out dkmj))
{
nzydk.Dkmj = dkmj;
}
} catch (Exception) {
throw new Exception(dkmc);
}
//data.Dk.Add(nzydk);
}
#endregion
if (!string.IsNullOrEmpty(dr["出让面积"].ToString()))
{
GDDK gddk = new GDDK();
gddk.Dzjgh = dr["供地文号"].ToString();
gddk.Xmmc = dr["用地单位"].ToString();
gddk.Gdmj = Decimal.Parse(dr["出让面积"].ToString());
if (string.IsNullOrWhiteSpace(dr["带供"].ToString()))
{
gddk.Dgmj = 0;
}
else
{
gddk.Dgmj = Decimal.Parse(dr["带供"].ToString());
}
gddk.Bz = dr["备注"].ToString();
nzydk.Gddk.Add(gddk);
}
}
return(result);
}
