public Replaceitem(Form1 mpform)
{
InitializeComponent();
m_parent = mpform;
checkedListBox1.Items.Clear();
checkedListBox2.Items.Clear();
checkedListBox1.Items.Add("二分鐘仰臥起坐", false);
checkedListBox1.Items.Add("二分鐘俯地挺身", false);
checkedListBox1.Items.Add("三千公尺徒手跑步", false);
try
{
center_code = System.Configuration.ConfigurationManager.AppSettings["centercode"].ToString();
//Lib.DataUtility du_center = new Lib.DataUtility();
//DataTable dt_center = du_center.getDataTableByText("select distinct C.center_code as center_code, C.center_name as center_name from Result R, Center C where R.center_code = C.center_code ");
//if (dt_center.Rows.Count == 1)
//{
// center_code = dt_center.Rows[0]["center_code"].ToString();
// center_name = dt_center.Rows[0]["center_name"].ToString();
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
d.Add("center_code", center_code);
DataTable dt_isSwin = du.getDataTableByText("select IsSwin from Center where center_code = @center_code", d);
DataTable dt = new DataTable();
if (dt_isSwin.Rows.Count > 0)
{
d.Clear();
//有游泳項目
if (Convert.ToBoolean(dt_isSwin.Rows[0]["IsSwin"]))
{
d.Add("Gender", m_parent.Gender);
dt = du.getDataTableBysp("GetRepMent", d);
}
else
{ //沒有游泳項目
d.Add("Gender", m_parent.Gender);
dt = du.getDataTableBysp("GetRepMentNonSwin", d);
}
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
checkedListBox2.Items.Add(dt.Rows[i]["rep_title"].ToString(), false);
}
}
}
catch (Exception ex)
{
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (RB_Standard.Checked == true)
{
if (!string.IsNullOrEmpty(TB_FileName.Text))
{
Dictionary <string, object> d = new Dictionary <string, object>();
Lib.DataUtility du = new Lib.DataUtility();
string[] FileLists = Directory.GetFiles(TB_FileName.Text);
int Total = 0;
foreach (string Name in FileLists)
{
var reader = new StreamReader(File.OpenRead(@Name), Encoding.GetEncoding("Big5"));
int count = 0;
while (reader.Peek() >= 0)
{
var line = reader.ReadLine();
string[] operater = { "," };
string[] values = line.Split(operater, StringSplitOptions.None);
if (values.Length > 0)
{
if (values[0] != "項目" && values.Length == 6)
{
d.Clear();
d.Add("item", values[0]);
d.Add("gender", values[1]);
d.Add("agemin", values[2]);
d.Add("agemax", values[3]);
d.Add("standard", values[4]);
d.Add("score", values[5]);
du.executeNonQueryByText(@"Insert into Standard (item, gender, agemin, agemax, standard, score) values (@item, @gender, @agemin, @agemax, @standard, @score)", d);
du.executeNonQueryByText(@"Insert into StandardEncrypt (item, gender, agemin, agemax, standard, score) values (@item, @gender, @agemin, @agemax, @standard, @score)", d);
count++;
}
}
}
Total += count;
//MessageBox.Show("Load File " + Name + " 共" + count + "筆成績");
}
MessageBox.Show("Load score success." + " 共" + Total + "筆.");
}
}
else
{
if (!string.IsNullOrEmpty(TB_FileName.Text))
{
Dictionary <string, object> d = new Dictionary <string, object>();
Lib.DataUtility du = new Lib.DataUtility();
string[] FileLists = Directory.GetFiles(TB_FileName.Text);
int Total = 0;
foreach (string Name in FileLists)
{
var reader = new StreamReader(File.OpenRead(@Name), Encoding.GetEncoding("Big5"));
int count = 0;
while (reader.Peek() >= 0)
{
var line = reader.ReadLine();
string[] operater = { "," };
string[] values = line.Split(operater, StringSplitOptions.None);
if (values.Length > 0)
{
if (values[0] != "項目" && values.Length == 5)
{
d.Clear();
d.Add("item_id", values[0]);
d.Add("gender", values[1]);
d.Add("start", values[2]);
d.Add("end", values[3]);
d.Add("standard", values[4]);
du.executeNonQueryByText(@"Insert into ReplaceStandard (item_id, gender, start, [end], standard) values (@item_id, @gender, @start, @end, @standard)", d);
du.executeNonQueryByText(@"Insert into ReplaceStandardEncrypt (item_id, gender, start, [end], standard) values (@item_id, @gender, @start, @end, @standard)", d);
count++;
}
}
}
Total += count;
//MessageBox.Show("Load File " + Name + " 共" + count + "筆成績");
}
MessageBox.Show("Load score success." + " 共" + Total + "筆.");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}