/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.AccessDataBase.Model.ElectronicMap model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ElectronicMap(");
strSql.Append("ElectronicMapID,ElectronicMapName,ElectronicMapDes,Map)");
strSql.Append(" values (");
strSql.Append("@ElectronicMapID,@ElectronicMapName,@ElectronicMapDes,@Map)");
SqlParameter[] parameters =
{
new SqlParameter("@ElectronicMapID", SqlDbType.Int, 4),
new SqlParameter("@ElectronicMapName", SqlDbType.NVarChar, 50),
new SqlParameter("@ElectronicMapDes", SqlDbType.NVarChar, 100),
new SqlParameter("@Map", SqlDbType.Image)
};
parameters[0].Value = model.ElectronicMapID;
parameters[1].Value = model.ElectronicMapName;
parameters[2].Value = model.ElectronicMapDes;
parameters[3].Value = model.Map;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.AccessDataBase.Model.ElectronicMap model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ElectronicMap set ");
strSql.Append("ElectronicMapName=@ElectronicMapName,");
strSql.Append("ElectronicMapDes=@ElectronicMapDes,");
strSql.Append("Map=@Map");
strSql.Append(" where ElectronicMapID=@ElectronicMapID ");
SqlParameter[] parameters =
{
new SqlParameter("@ElectronicMapName", SqlDbType.NVarChar, 50),
new SqlParameter("@ElectronicMapDes", SqlDbType.NVarChar, 100),
new SqlParameter("@Map", SqlDbType.Image),
new SqlParameter("@ElectronicMapID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ElectronicMapName;
parameters[1].Value = model.ElectronicMapDes;
parameters[2].Value = model.Map;
parameters[3].Value = model.ElectronicMapID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public FormElectronicMap(AccessDataBase.Model.ElectronicMap modelElectronicMap, OpenMode openMode)
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterParent;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Icon = GetResourcesFile.getSystemIco();
this.openMode = openMode;
if (modelElectronicMap != null)
{
this.modelElectronicMap = modelElectronicMap;
}
initUI();
if (this.openMode == OpenMode.Add)
{
}
else if (this.openMode == OpenMode.Update)
{
textBoxElectronicMapName.Text = modelElectronicMap.ElectronicMapName;
textBoxElectronicMapName.Enabled = false;
List <KryptonAccessController.AccessDataBase.Model.ElectronicMap> listElectronicMap = bllElectronicMap.GetModelList("ElectronicMapName = '" + modelElectronicMap.ElectronicMapName + "'");
textBoxElectronicMapDes.Text = listElectronicMap[0].ElectronicMapDes;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.ElectronicMap DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.ElectronicMap model = new KryptonAccessController.AccessDataBase.Model.ElectronicMap();
if (row != null)
{
if (row["ElectronicMapID"] != null && row["ElectronicMapID"].ToString() != "")
{
model.ElectronicMapID = int.Parse(row["ElectronicMapID"].ToString());
}
if (row["ElectronicMapName"] != null)
{
model.ElectronicMapName = row["ElectronicMapName"].ToString();
}
if (row["ElectronicMapDes"] != null)
{
model.ElectronicMapDes = row["ElectronicMapDes"].ToString();
}
if (row["Map"] != null && row["Map"].ToString() != "")
{
model.Map = (byte[])row["Map"];
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.ElectronicMap GetModel(int ElectronicMapID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ElectronicMapID,ElectronicMapName,ElectronicMapDes,Map from ElectronicMap ");
strSql.Append(" where ElectronicMapID=@ElectronicMapID ");
SqlParameter[] parameters =
{
new SqlParameter("@ElectronicMapID", SqlDbType.Int, 4)
};
parameters[0].Value = ElectronicMapID;
KryptonAccessController.AccessDataBase.Model.ElectronicMap model = new KryptonAccessController.AccessDataBase.Model.ElectronicMap();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.ElectronicMap DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.ElectronicMap model=new KryptonAccessController.AccessDataBase.Model.ElectronicMap();
if (row != null)
{
if(row["ElectronicMapID"]!=null && row["ElectronicMapID"].ToString()!="")
{
model.ElectronicMapID=int.Parse(row["ElectronicMapID"].ToString());
}
if(row["ElectronicMapName"]!=null)
{
model.ElectronicMapName=row["ElectronicMapName"].ToString();
}
if(row["ElectronicMapDes"]!=null)
{
model.ElectronicMapDes=row["ElectronicMapDes"].ToString();
}
if(row["Map"]!=null && row["Map"].ToString()!="")
{
model.Map=(byte[])row["Map"];
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.ElectronicMap GetModel(int ElectronicMapID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ElectronicMapID,ElectronicMapName,ElectronicMapDes,Map from ElectronicMap ");
strSql.Append(" where ElectronicMapID=@ElectronicMapID ");
SqlParameter[] parameters = {
new SqlParameter("@ElectronicMapID", SqlDbType.Int,4) };
parameters[0].Value = ElectronicMapID;
KryptonAccessController.AccessDataBase.Model.ElectronicMap model=new KryptonAccessController.AccessDataBase.Model.ElectronicMap();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
