private void lbSceneryApply_Click(object sender, EventArgs e)
{
ApplyScenery applyScenery = new ApplyScenery();
applyScenery.ASSYId = SYId;
applyScenery.ASDTId = DTId;
if (ApplySceneryAccess.AddApply(applyScenery))
{
MessageBox.Show("申请成功！等待审批...");
}
else
{
MessageBox.Show("申请失败！请重新申请....");
}
}
public static bool AddApply(ApplyScenery applyScenery)
{
SqlConnection con = DBConnect.DBOpen();
SqlCommand cmd = new SqlCommand("insert into " + DBConfig.ApplyScenery + "([ASDTId],[ASSYId])" +
"values(@ASDTId,@ASSYId)", con);
cmd.Parameters.AddWithValue("@ASDTId", applyScenery.ASDTId);
cmd.Parameters.AddWithValue("@ASSYId", applyScenery.ASSYId);
int count = cmd.ExecuteNonQuery();
if (count == 1)
{
DBConnect.DBClose();
return(true);
}
DBConnect.DBClose();
return(false);
}
