landdata.cs

一个土地管理系统

using System;
using System.Data;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for LandData
/// </summary>
public class LandData
{
	public LandData()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public static DataTable getIso() //返回土地的国标分类号
    {
        DataTable t = DataOp.getData("select * from [isoCategory]");
        return t;
    }
    public static DataTable getLandPurpose()//返回土地用途
    {
        DataTable t = DataOp.getData("select * from [landPurpose]");
        return t;
    }
    public static DataTable getLandStatus()//返回土地现状
    {
        DataTable t = DataOp.getData("select * from [landStatus]");
        return t;
    }
    /// <summary>
    /// 删除土地
    /// </summary>
    /// <param name="serial"></param>
    public static void deleteLandInfo(string serial)
    {
        DataOp.updateData("delete from [landInfo] where [landSerial] = '"+serial+"'");
    }
    /// <summary>
    /// 获得土地数量
    /// </summary>
    /// <returns></returns>
    public static int getLandNum()
    {
        DataTable t = DataOp.getData("select * from [landInfo]");
        return t.Rows.Count;
    }
    /// <summary>
    /// 返回所有土地信息
    /// </summary>
    /// <returns></returns>
    public static DataTable getAllLandInfo()
    {
        string sql = "select * from [landInfo],[isoCategory],[landPurpose],[landStatus] ";
        sql+=" where landInfo.isCategory = isoCategory.isoCode ";
        sql+=" and landInfo.landPurpose = landPurpose.id ";
        sql+=" and landInfo.statusNow = landStatus.id ";
        sql+=" order by [inTime] desc,[landSerial] desc";
        DataTable t = DataOp.getData(sql);
       
        return t;

    }
    /// <summary>
    /// 查找1个土地信息
    /// </summary>
    /// <returns></returns>
    public static DataRow getOneLandInfo(string serial)
    {
        DataTable t = DataOp.getData("select * from [landInfo] where [landSerial]='"+serial+"'");
        if (t.Rows.Count > 0)
            return t.Rows[0];
        return null;
        
    }
    /// <summary>
    /// 添加新土地
    /// </summary>
    public static void addNewLand(string inTime,string iso,string landName,string landRepose,string landUser,
        string landPrice,string buyTime,string landCardNo,string landPurpose,string landNo,string mapNo,string landLevel,
        string nationalCapital,string userArea,string aloneUserFace,string aloneBuildFace,string publicArea ,string repartArea,
        string repartFace,string handlePerson,string accountPerson,string statusNow)
    {
        int year = Convert.ToDateTime(buyTime).Year;
        DataTable t = DataOp.getData("select Top 1 [landSerial] from [landInfo] where [landSerial] like '"+year+"%' order by [landSerial] desc");
        int waterNo = 0;
        if (t.Rows.Count != 0)
        {
            waterNo = Convert.ToInt32(t.Rows[0].ItemArray[0].ToString().Substring(4,4))+1;
        }
        int len = Convert.ToString(waterNo).Length;
        string waterNoStr = waterNo.ToString();
        while (len < 4)
        {
            waterNoStr = "0" + waterNoStr;
            len = waterNoStr.Length;
        }
        string landSerial = year.ToString() + waterNoStr;

        string insertSql = "insert into [landInfo]";
        insertSql += "(";
        insertSql += "[inTime],";
        insertSql += "[isCategory],";
        insertSql += "[landName],";
        insertSql += "[landSerial],";
        insertSql += "[landRepose],";
        insertSql += "[landUser],";
        insertSql += "[landPrice],";
        insertSql += "[buyTime],";
        insertSql += "[landCardNo],";
        insertSql += "[landPurpose],";
        insertSql += "[landNo],";
        insertSql += "[mapNo],";
        insertSql += "[landLevel],";
        insertSql += "[nationCapital],";
        insertSql += "[useArea],";
        insertSql += "[aloneUseFace],";
        insertSql += "[aloneBuildFace],";
        insertSql += "[publicArea],";
        insertSql += "[repartArea],";
        insertSql += "[repartFace],";
        insertSql += "[handlePerson],";
        insertSql += "[accountPerson],";
        insertSql += "[statusNow]";
        insertSql += ")";
        insertSql += "  ";
        insertSql += "values";
        insertSql += "(";
        insertSql += "'"+Convert.ToDateTime(inTime)+"',";
        insertSql +="'"+iso+"',";
        insertSql +="'"+landName+"',";
        insertSql+="'"+landSerial+"',";
        insertSql+="'"+landRepose+"',";
        insertSql+="'"+landUser+"',";
        insertSql+=landPrice+",";
        insertSql+="'"+Convert.ToDateTime(buyTime)+"',";
        insertSql+="'"+landCardNo+"',";
        insertSql+="'"+landPurpose+"',";
        insertSql+="'"+landNo+"',";
        insertSql+="'"+mapNo+"',";
        insertSql+="'"+landLevel+"',";
        insertSql+=nationalCapital+",";
        insertSql += userArea+",";
        insertSql += aloneUserFace+",";
        insertSql += aloneBuildFace+",";
        insertSql += publicArea+",";
        insertSql += repartArea+",";
        insertSql += repartFace+",";
        insertSql += "'"+handlePerson+"',";
        insertSql += "'" +accountPerson+"',";
        insertSql += "'" +statusNow+ "'";
        insertSql += ")";

        DataOp.updateData(insertSql);

    }
    /// <summary>
    /// 添加新土地
    /// </summary>
    public static void modifyLandInfo(string landSerial,string inTime, string iso, string landName, string landRepose, string landUser,
        string landPrice, string buyTime, string landCardNo, string landPurpose, string landNo, string mapNo, string landLevel,
        string nationalCapital, string userArea, string aloneUserFace, string aloneBuildFace, string publicArea, string repartArea,
        string repartFace, string handlePerson, string accountPerson, string statusNow)
    {
        string updateSql = "update [landInfo] set ";
      //  updateSql += "[inTime] = '"+Convert.ToDateTime(inTime)+"',";
        updateSql += "[isCategory] = '"+iso+"',";
        updateSql += "[landName]='"+landName+"',";
        
        updateSql += "[landRepose]='"+landRepose+"',";
        updateSql += "[landUser]='"+landUser+"',";
        updateSql += "[landPrice]="+landPrice+",";
        updateSql += "[buyTime]='"+Convert.ToDateTime(buyTime)+"',";
        updateSql += "[landCardNo]='"+landCardNo+"',";
        updateSql += "[landPurpose]='"+landPurpose+"',";
        updateSql += "[landNo]='"+landNo+"',";
        updateSql += "[mapNo]='"+mapNo+"',";
        updateSql += "[landLevel]='"+landLevel+"',";
        updateSql += "[nationCapital]="+nationalCapital+",";
        updateSql += "[useArea]="+userArea+",";
        updateSql += "[aloneUseFace]="+aloneUserFace+",";
        updateSql += "[aloneBuildFace]="+aloneBuildFace+",";
        updateSql += "[publicArea]="+publicArea+",";
        updateSql += "[repartArea]="+repartArea+",";
        updateSql += "[repartFace]="+repartFace+",";
        updateSql += "[handlePerson]='"+handlePerson+"',";
        updateSql += "[accountPerson]='"+accountPerson+"',";
        updateSql += "[statusNow]='"+statusNow+"'";
        updateSql += "where [landSerial]='"+landSerial+"'";

        DataOp.updateData(updateSql);

    }
    /// <summary>
    /// 以fieldName like key 为条件查找
    /// </summary>
    /// <param name="fieldName"></param>
    /// <param name="key"></param>
    /// <returns></returns>
    public static DataTable SearchLandInfo(string fieldName , string key)
    {
        DataTable t = DataOp.getData("select * from [landInfo] where ["+fieldName+"] like '%"+key+"%' order by [inTime] desc,[landSerial] desc");
        return t;
    }
}