/// <summary>
/// 得到一个对象实体
/// </summary>
//public Maticsoft.Model.tb_DingDian GetModel(string DingDianName,string X,string Y,string Z)
public Maticsoft.Model.tb_DingDian GetModel(string DingDianName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
//strSql.Append("select DingDianName, X, Y, Z ");
strSql.Append(" from tb_DingDian ");
//strSql.Append(" where DingDianName=@DingDianName and X=@X and Y=@Y and Z=@Z ");
strSql.Append(" where DingDianName=@DingDianName ");
SqlParameter[] parameters =
{
new SqlParameter("@DingDianName", SqlDbType.VarChar, 50)
//,
//new SqlParameter("@X", SqlDbType.VarChar,50),
//new SqlParameter("@Y", SqlDbType.VarChar,50),
//new SqlParameter("@Z", SqlDbType.VarChar,50)
};
parameters[0].Value = DingDianName;
//parameters[1].Value = X;
//parameters[2].Value = Y;
//parameters[3].Value = Z;
Maticsoft.Model.tb_DingDian model = new Maticsoft.Model.tb_DingDian();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.DingDianName = ds.Tables[0].Rows[0]["DingDianName"].ToString();
model.X = ds.Tables[0].Rows[0]["X"].ToString();
model.Y = ds.Tables[0].Rows[0]["Y"].ToString();
model.Z = ds.Tables[0].Rows[0]["Z"].ToString();
model.Precision = ds.Tables[0].Rows[0]["Precision"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.tb_DingDian model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_DingDian set ");
//strSql.Append(" DingDianName = @DingDianName , ");
strSql.Append(" X = @X , ");
strSql.Append(" Y = @Y , ");
strSql.Append(" Z = @Z , ");
strSql.Append(" precision = @Precision ");
//strSql.Append(" where DingDianName=@DingDianName and X=@X and Y=@Y and Z=@Z ");
strSql.Append(" where DingDianName=@DingDianName ");
SqlParameter[] parameters =
{
new SqlParameter("@DingDianName", SqlDbType.VarChar, 50),
new SqlParameter("@X", SqlDbType.VarChar, 50),
new SqlParameter("@Y", SqlDbType.VarChar, 50),
new SqlParameter("@Z", SqlDbType.VarChar, 50),
new SqlParameter("@Precision", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.DingDianName;
parameters[1].Value = model.X;
parameters[2].Value = model.Y;
parameters[3].Value = model.Z;
parameters[4].Value = model.Precision;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void dataGridViewDingDian_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
tb_DingDianModel = tb_DingDianBLL.GetModel(dataGridViewDingDian.SelectedRows[0].Cells[0].Value.ToString()
//,
//dataGridViewDingDian.SelectedRows[0].Cells[1].Value.ToString(),
//dataGridViewDingDian.SelectedRows[0].Cells[2].Value.ToString(),
//dataGridViewDingDian.SelectedRows[0].Cells[3].Value.ToString()
);
txtDingDian.ReadOnly = false;
txtDingDian.Text = tb_DingDianModel.DingDianName;
txtDingDian.ReadOnly = true;
txtDingDianX.Text = tb_DingDianModel.X;
txtDingDianY.Text = tb_DingDianModel.Y;
txtDingDianZ.Text = tb_DingDianModel.Z;
dingPrecision.Text = tb_DingDianModel.Precision;
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Maticsoft.Model.tb_DingDian model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_DingDian(");
strSql.Append("DingDianName,X,Y,Z");
strSql.Append(") values (");
strSql.Append("@DingDianName,@X,@Y,@Z");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@DingDianName", SqlDbType.VarChar, 50),
new SqlParameter("@X", SqlDbType.VarChar, 50),
new SqlParameter("@Y", SqlDbType.VarChar, 50),
new SqlParameter("@Z", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.DingDianName;
parameters[1].Value = model.X;
parameters[2].Value = model.Y;
parameters[3].Value = model.Z;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
