private void btnOK_Click(object sender, EventArgs e)
{
OBJJKINFO = new MapApp.Entities.JKINFO();
try
{
OBJJKINFO.NDH = Convert.ToInt32(tbNDH.Text);
}
catch
{
MessageBox.Show("内点号是数字！");
tbNDH.Text = "";
tbNDH.Focus();
return;
}
try
{
OBJJKINFO.SBLX = Convert.ToInt32(cbSBLX.SelectedValue);
}
catch
{
MessageBox.Show("请选择社备类型是数字！");
cbSBLX.Focus();
return;
}
this.DialogResult = DialogResult.OK;
}
public bool EditJKINFO(MapApp.Entities.JKINFO OBJJKINFO, String MDBFileName)
{
String SQL = String.Format("UPDATE JKINFO SET NDH={0},SBLX={1} WHERE MAPINFO_ID ={2}"
, OBJJKINFO.NDH, OBJJKINFO.SBLX, OBJJKINFO.MAPINFO_ID);
return(MDBHelp.ExcuteSQL(MDBFileName, SQL));
}
public bool AddJKINFO(MapApp.Entities.JKINFO OBJJKINFO, String MDBFileName)
{
String SQL = String.Format("INSERT INTO JKINFO (NDH,SBLX)values({0},{1})"
, OBJJKINFO.NDH, OBJJKINFO.SBLX);
return(MDBHelp.ExcuteSQL(MDBFileName, SQL));
}
public bool DeleteJKINFO(Int32 NDH, String MDBFileName)
{
MapApp.Entities.JKINFO OBJJKINFO = new MapApp.Entities.JKINFO();
String SQL = String.Format("DELETE FROM JKINFO WHERE NDH={0}"
, NDH);
return(MDBHelp.ExcuteSQL(MDBFileName, SQL));
}
public EditJKINFO(MapApp.Entities.JKINFO EditJKINFO)
{
InitializeComponent();
cbSBLX.DataSource = SysInfo.TypeDataTable;
cbSBLX.ValueMember = "JKType";
cbSBLX.DisplayMember = "JKTypeName";
OBJJKINFO = new MapApp.Entities.JKINFO();
OBJJKINFO.MAPINFO_ID = EditJKINFO.MAPINFO_ID;
//tbNDH.ReadOnly = true;
tbNDH.Text = EditJKINFO.NDH.ToString();
cbSBLX.SelectedValue = EditJKINFO.SBLX;
}
public ViewJKINFO(MapApp.Entities.JKINFO EditJKINFO)
{
InitializeComponent();
tbADDR.Text = EditJKINFO.ADDR;
tbBJZ.Text = EditJKINFO.BJZ.ToString();
tbDDZ.Text = EditJKINFO.DDZ.ToString();
tbDKH.Text = EditJKINFO.DKH.ToString();
tbDW.Text = EditJKINFO.DW;
tbFZH.Text = EditJKINFO.FZH.ToString();
tbNDH.Text = EditJKINFO.NDH.ToString();
tbSBLX.Text = EditJKINFO.SBLX.ToString();
tbSJ.Text = EditJKINFO.SJ;
tbZT.Text = EditJKINFO.ZT.ToString();
}
public MapApp.Entities.JKINFO GetJKINFO(Int32 NDH, String MDBFileName)
{
MapApp.Entities.JKINFO OBJJKINFO = new MapApp.Entities.JKINFO();
String SQL = String.Format("SELECT * FROM JKINFO WHERE NDH={0}"
, NDH);
DataSet ds = MDBHelp.GetDataSet(MDBFileName, SQL);
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
else
{
OBJJKINFO.ADDR = ds.Tables[0].Rows[0]["ADDR"].ToString();
try
{
OBJJKINFO.BJZ = Convert.ToInt32(ds.Tables[0].Rows[0]["BJZ"].ToString());
}
catch
{ }
try
{
OBJJKINFO.DDZ = Convert.ToInt32(ds.Tables[0].Rows[0]["DDZ"].ToString());
}
catch
{ }
try
{
OBJJKINFO.DKH = Convert.ToInt32(ds.Tables[0].Rows[0]["DKH"].ToString());
}
catch
{ }
OBJJKINFO.DW = ds.Tables[0].Rows[0]["DW"].ToString();
try
{
OBJJKINFO.FZH = Convert.ToInt32(ds.Tables[0].Rows[0]["FZH"].ToString());
}
catch
{ }
try
{
OBJJKINFO.MAPINFO_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["MAPINFO_ID"].ToString());
}
catch
{ }
try
{
OBJJKINFO.NDH = Convert.ToInt32(ds.Tables[0].Rows[0]["NDH"].ToString());
}
catch
{ }
try
{
OBJJKINFO.SBLX = Convert.ToInt32(ds.Tables[0].Rows[0]["SBLX"].ToString());
}
catch
{ }
OBJJKINFO.SJ = ds.Tables[0].Rows[0]["SJ"].ToString();
try
{
OBJJKINFO.ZT = Convert.ToInt32(ds.Tables[0].Rows[0]["ZT"].ToString());
}
catch
{ }
return(OBJJKINFO);
}
}
public bool EditJKINFO(MapApp.Entities.JKINFO OBJJKINFO, String MDBFileName)
{
return(dalJKINFO.EditJKINFO(OBJJKINFO, MDBFileName));
}
