//private void importExcel(string dir, string file)
//{
// IFormatProvider culture = new System.Globalization.CultureInfo("vi-VN", true);
// string Excelstrcon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dir + file + @";Extended Properties=""Excel 8.0;HDR=YES;""";
// string SQLstr = "SELECT * FROM [Sheet1$]";
// OleDbConnection ExcelCon = new OleDbConnection(Excelstrcon);
// ExcelCon.Open();
// OleDbCommand dbCommand = new OleDbCommand(SQLstr, ExcelCon);
// OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
// DataTable dTable = new DataTable();
// try
// {
// dataAdapter.Fill(dTable);
// int idx = 1;
// DateTime NgayChet = DateTime.MinValue;
// DateTime currNgay = DateTime.MinValue;
// string StrIDCaSau = "";
// string StrDaBung = "";
// string StrDaPhanLoai = "";
// string StrDau = "";
// string LyDo = "";
// foreach (DataRow r in dTable.Rows)
// {
// NgayChet = DateTime.Parse(r["Ngay"].ToString() + "/" + r["Thang"].ToString() + "/" + r["Nam"].ToString() + " 22:00:00", culture);
// if (NgayChet != currNgay)
// {
// if (StrIDCaSau != "")
// {
// string fail = csCont.CaSauChet(StrIDCaSau, currNgay, UserId, LyDo, StrDaBung, StrDaPhanLoai, StrDau);
// if (fail != "")
// {
// int sidx = idx - 1;
// lblMessage.Text += "<br/>Dòng " + sidx.ToString() + ":" + fail;
// }
// StrIDCaSau = "";
// StrDaBung = "";
// StrDaPhanLoai = "";
// StrDau = "";
// }
// currNgay = NgayChet;
// }
// string s = csCont.CaSau_Chet_GetCaByLoaiCaByChuongAtDate(Convert.ToInt32(r["LoaiCa"]), r["Chuong"].ToString(), Convert.ToInt32(r["SL"]), NgayChet);
// string sTemp = s.Replace("@", "");
// if ((s.Length - sTemp.Length) / 2 != Convert.ToInt32(r["SL"]))
// {
// lblMessage.Text += "<br/>Dòng " + idx.ToString() + " không import do số lượng cá không đủ.";
// idx++;
// continue;
// }
// StrIDCaSau += s;
// if (r["SanPham"] != DBNull.Value && r["SanPham"].ToString() != "")
// {
// if(r["SanPham"].ToString() == "-1")
// {
// for(int i = 0; i<Convert.ToInt32(r["SL"]); i++)
// {
// StrDaBung += "@0@";
// StrDaPhanLoai += "@4@";
// StrDau += "@1@";
// }
// }
// else
// {
// for (int i = 0; i < Convert.ToInt32(r["SL"]); i++)
// {
// StrDaBung += "@" + r["SanPham"].ToString() + "@";
// StrDaPhanLoai += "@4@";
// StrDau += "@0@";
// }
// }
// }
// else
// {
// for (int i = 0; i < Convert.ToInt32(r["SL"]); i++)
// {
// StrDaBung += "@0@";
// StrDaPhanLoai += "@4@";
// StrDau += "@0@";
// }
// }
// idx++;
// }
// if (StrIDCaSau != "")
// {
// string fail = csCont.CaSauChet(StrIDCaSau, currNgay, UserId, LyDo, StrDaBung, StrDaPhanLoai, StrDau);
// if (fail != "")
// {
// int sidx = idx - 1;
// lblMessage.Text += "<br/>Dòng " + sidx.ToString() + ":" + fail;
// }
// }
// // dispose used objects
// dTable.Dispose();
// dataAdapter.Dispose();
// dbCommand.Dispose();
// ExcelCon.Close();
// ExcelCon.Dispose();
// lblMessage.Text += "<br/>Đã import xong!";
// }
// catch (Exception ex)
// {
// // dispose used objects
// dTable.Dispose();
// dataAdapter.Dispose();
// dbCommand.Dispose();
// ExcelCon.Close();
// ExcelCon.Dispose();
// Response.Write(ex.ToString());
// }
//}
private void importExcel(string dir, string file)
{
IFormatProvider culture = new System.Globalization.CultureInfo("vi-VN", true);
string Excelstrcon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dir + file + @";Extended Properties=""Excel 8.0;HDR=YES;""";
string SQLstr = "SELECT * FROM [Sheet1$]";
OleDbConnection ExcelCon = new OleDbConnection(Excelstrcon);
ExcelCon.Open();
OleDbCommand dbCommand = new OleDbCommand(SQLstr, ExcelCon);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
DataTable dTable = new DataTable();
try
{
dataAdapter.Fill(dTable);
int idx = 1;
DateTime NgayChet = DateTime.MinValue;
string StrIDCaSau = "";
string StrDaBung = "";
string StrDaPhanLoai = "";
string StrDau = "";
string StrPPM = "";
string StrLDC = "";
string StrKL = "";
string LyDo = "";
int hh = 11;
int mm = 10;
int ss = 10;
string TenChuong = "";
int So = 0;
string BienBan = "";
foreach (DataRow r in dTable.Rows)
{
//NgayChet = DateTime.Parse(r["Ngay"].ToString() + "/" + r["Thang"].ToString() + "/" + r["Nam"].ToString() + " 22:00:00", culture);
NgayChet = DateTime.Parse(r["Ngay"].ToString() + "/" + r["Thang"].ToString() + "/" + r["Nam"].ToString() + " " + hh.ToString() + ":" + mm.ToString() + ":" + ss.ToString(), culture);
ss++; if (ss > 59)
{
ss = 10; mm++; if (mm > 59)
{
mm = 10; hh++;
}
}
csCont.ParseChuong(r["Chuong"].ToString().Trim(), out TenChuong, out So);
string s = csCont.CaSau_Chet_GetCaByLoaiCaByChuongAtDate(Convert.ToInt32(r["LoaiCa"]), TenChuong, So, Convert.ToInt32(r["SL"]), NgayChet, Convert.ToBoolean(r["Giong"]));
string sTemp = s.Replace("@", "");
if ((s.Length - sTemp.Length) / 2 != Convert.ToInt32(r["SL"]))
{
lblMessage.Text += "<br/>Dòng " + idx.ToString() + " không import do số lượng cá không đủ.";
idx++;
continue;
}
if (r["BienBan"] != DBNull.Value)
{
BienBan = r["BienBan"].ToString();
}
else
{
BienBan = "";
}
StrIDCaSau = s;
if (r["SanPham"] != DBNull.Value && r["SanPham"].ToString() != "")
{
if (r["SanPham"].ToString() == "-1")
{
for (int i = 0; i < Convert.ToInt32(r["SL"]); i++)
{
StrDaBung += "@0@";
StrDaPhanLoai += "@4@";
StrDau += "@1@";
StrPPM += "@CL@";
StrLDC += "@" + r["LyDoChet"].ToString() + "@";
StrKL += "@" + r["KhoiLuong"].ToString().Replace(",", ".") + "@";
}
}
else
{
for (int i = 0; i < Convert.ToInt32(r["SL"]); i++)
{
StrDaBung += "@" + r["SanPham"].ToString() + "@";
StrDaPhanLoai += "@" + r["PhanLoai"].ToString() + "@";
StrDau += "@0@";
StrPPM += "@" + r["PPM"].ToString() + "@";
StrLDC += "@" + r["LyDoChet"].ToString() + "@";
StrKL += "@" + r["KhoiLuong"].ToString().Replace(",", ".") + "@";
}
}
}
else
{
for (int i = 0; i < Convert.ToInt32(r["SL"]); i++)
{
StrDaBung += "@0@";
StrDaPhanLoai += "@4@";
StrDau += "@0@";
StrPPM += "@CL@";
StrLDC += "@" + r["LyDoChet"].ToString() + "@";
StrKL += "@" + r["KhoiLuong"].ToString().Replace(",", ".") + "@";
}
}
if (StrIDCaSau != "")
{
string fail = csCont.CaSauChet(StrIDCaSau, NgayChet, UserId, StrDaBung, StrDaPhanLoai, StrDau, StrPPM, StrLDC, StrKL, BienBan, "-1", "");
if (fail != "")
{
lblMessage.Text += "<br/>Dòng " + idx.ToString() + ":" + fail;
}
StrIDCaSau = "";
StrDaBung = "";
StrDaPhanLoai = "";
StrDau = "";
StrPPM = "";
StrLDC = "";
StrKL = "";
}
else
{
StrDaBung = "";
StrDaPhanLoai = "";
StrDau = "";
StrPPM = "";
StrLDC = "";
StrKL = "";
}
idx++;
}
// dispose used objects
dTable.Dispose();
dataAdapter.Dispose();
dbCommand.Dispose();
ExcelCon.Close();
ExcelCon.Dispose();
lblMessage.Text += "<br/>Đã import xong!";
}
catch (Exception ex)
{
// dispose used objects
dTable.Dispose();
dataAdapter.Dispose();
dbCommand.Dispose();
ExcelCon.Close();
ExcelCon.Dispose();
Response.Write(ex.ToString());
}
}
protected void btnChuyen_Click(object sender, EventArgs e)
{
if (Request.QueryString["type"] == "chuyentrangthai")
{
if (Session["DSCaSauChuyenTrangThai"] != null && Session["DSCaSauChuyenTrangThai"].ToString() != "")
{
IFormatProvider culture = new System.Globalization.CultureInfo("vi-VN", true);
if (DateTime.Parse(txtThoiDiemChuyen.Text, culture) < Config.NgayKhoaSo())
{
Page.ClientScript.RegisterStartupScript(typeof(string), "chuyenfail", "<script language=javascript>alert('Ngày chuyển không được trước ngày khóa sổ');</script>", false);
return;
}
if (ddlTrangThai.SelectedValue == "-3")
{
string res = csCont.ChuyenTrangThai_CaBan(Session["DSCaSauChuyenTrangThai"].ToString(), DateTime.Parse(txtThoiDiemChuyen.Text, culture), UserId);
if (res != "")
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Một số cá không chuyển trạng thái được có ID: " + res.Substring(1, res.Length - 2).Replace("@@", ", ") + "');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
else if (ddlTrangThai.SelectedValue == "-1" || ddlTrangThai.SelectedValue == "-4")
{
string StrDaBung = "";
string StrDaPhanLoai = "";
string StrDau = "";
string StrPPM = "";
string StrLDC = "";
string StrKL = "";
string LyDo = "";
string StrVatTu = "";
foreach (GridViewRow r in grvSPTH.Rows)
{
CheckBox chkDau = (CheckBox)(r.FindControl("chkDau"));
TextBox txtDaBung = (TextBox)(r.FindControl("txtDaBung"));
DropDownList ddlDaPhanLoai = (DropDownList)(r.FindControl("ddlDaPhanLoai"));
DropDownList ddlPPM = (DropDownList)(r.FindControl("ddlPPM"));
DropDownList ddlLyDoChet = (DropDownList)(r.FindControl("ddlLyDoChet"));
TextBox txtKhoiLuong = (TextBox)(r.FindControl("txtKhoiLuong"));
if (txtDaBung.Text == "")
{
txtDaBung.Text = "0";
}
StrDaBung += "@" + txtDaBung.Text + "@";
StrDaPhanLoai += "@" + ddlDaPhanLoai.SelectedValue + "@";
StrDau += "@" + Convert.ToInt32(chkDau.Checked).ToString() + "@";
StrPPM += "@" + ddlPPM.SelectedValue + "@";
StrLDC += "@" + ddlLyDoChet.SelectedValue + "@";
StrKL += "@" + txtKhoiLuong.Text.Replace(",", ".") + "@";
PlaceHolder dsVatTu = (PlaceHolder)(r.FindControl("dsVatTu"));
string sVatTu = CreateSVatTu(dsVatTu, false);
StrVatTu += "*" + sVatTu + "*";
}
string res = csCont.CaSauChet(Session["DSCaSauChuyenTrangThai"].ToString(), DateTime.Parse(txtThoiDiemChuyen.Text, culture), UserId, StrDaBung, StrDaPhanLoai, StrDau, StrPPM, StrLDC, StrKL, txtBienBan.Text.Trim(), ddlTrangThai.SelectedValue, StrVatTu);
if (res != "")
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Một số cá không chuyển trạng thái được có ID: " + res.Substring(1, res.Length - 2).Replace("@@", ", ") + "');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
else
{
string res = csCont.ChuyenTrangThai_CaSong(Session["DSCaSauChuyenTrangThai"].ToString(), int.Parse(ddlTrangThai.SelectedValue), DateTime.Parse(txtThoiDiemChuyen.Text, culture), UserId);
if (res != "")
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Một số cá không chuyển trạng thái được có ID: " + res.Substring(1, res.Length - 2).Replace("@@", ", ") + "');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
}
}
else if (Request.QueryString["type"] == "editchuyentrangthai")
{
if (hdIDCaSau.Value != "0")
{
IFormatProvider culture = new System.Globalization.CultureInfo("vi-VN", true);
if (DateTime.Parse(txtThoiDiemChuyen.Text, culture) < Config.NgayKhoaSo())
{
Page.ClientScript.RegisterStartupScript(typeof(string), "chuyenfail", "<script language=javascript>alert('Ngày chuyển không được trước ngày khóa sổ');</script>", false);
return;
}
if (ddlTrangThai.SelectedValue == "-3")
{
int res = csCont.EditChuyenTrangThai_CaBan(int.Parse(hdIDBienDong.Value), int.Parse(hdIDCaSau.Value), DateTime.Parse(txtThoiDiemChuyen.Text, culture), UserId);
if (res == 0)
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Không chuyển trạng thái được!');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
else if (ddlTrangThai.SelectedValue == "-1" || ddlTrangThai.SelectedValue == "-4")
{
int RealDaBung = 0;
int RealDaPhanLoai = 0;
int RealDau = 0;
string RealPPM = "";
int RealLDC = 0;
decimal RealKL = 0;
string LyDo = "";
string sVatTu = "";
foreach (GridViewRow r in grvSPTH.Rows)
{
CheckBox chkDau = (CheckBox)(r.FindControl("chkDau"));
TextBox txtDaBung = (TextBox)(r.FindControl("txtDaBung"));
DropDownList ddlDaPhanLoai = (DropDownList)(r.FindControl("ddlDaPhanLoai"));
DropDownList ddlPPM = (DropDownList)(r.FindControl("ddlPPM"));
DropDownList ddlLyDoChet = (DropDownList)(r.FindControl("ddlLyDoChet"));
TextBox txtKhoiLuong = (TextBox)(r.FindControl("txtKhoiLuong"));
if (txtDaBung.Text == "")
{
txtDaBung.Text = "0";
}
RealDaBung = int.Parse(txtDaBung.Text);
RealDaPhanLoai = int.Parse(ddlDaPhanLoai.SelectedValue);
RealDau = Convert.ToInt32(chkDau.Checked);
RealPPM = ddlPPM.SelectedValue;
RealLDC = int.Parse(ddlLyDoChet.SelectedValue);
RealKL = decimal.Parse(txtKhoiLuong.Text.Trim());
PlaceHolder dsVatTu = (PlaceHolder)(r.FindControl("dsVatTu"));
sVatTu = CreateSVatTu(dsVatTu, false);
}
int res = csCont.EditCaSauChet(int.Parse(hdIDBienDong.Value), int.Parse(hdIDCaSau.Value), DateTime.Parse(txtThoiDiemChuyen.Text, culture), RealDaBung, RealDaPhanLoai, RealDau, RealPPM, RealLDC, RealKL, UserId, txtBienBan.Text.Trim(), ddlTrangThai.SelectedValue, sVatTu);
if (res == 0)
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Không chuyển trạng thái được!');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
else
{
int res = csCont.EditChuyenTrangThai_CaSong(int.Parse(hdIDBienDong.Value), int.Parse(hdIDCaSau.Value), int.Parse(ddlTrangThai.SelectedValue), DateTime.Parse(txtThoiDiemChuyen.Text, culture), UserId);
if (res == 0)
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Không chuyển trạng thái được!');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
}
}
else if (Request.QueryString["type"] == "editchuyentrangthaigroup")
{
if (hdIDBienDongGroup.Value != "0")
{
IFormatProvider culture = new System.Globalization.CultureInfo("vi-VN", true);
if (DateTime.Parse(txtThoiDiemChuyen.Text, culture) < Config.NgayKhoaSo())
{
Page.ClientScript.RegisterStartupScript(typeof(string), "chuyenfail", "<script language=javascript>alert('Ngày chuyển không được trước ngày khóa sổ');</script>", false);
return;
}
string res = csCont.UpdateBienDongGroup(int.Parse(hdIDBienDongGroup.Value), DateTime.Parse(txtThoiDiemChuyen.Text, culture), ddlTrangThai.SelectedValue, UserId);
if (res != "")
{
Page.ClientScript.RegisterStartupScript(typeof(string), "fail", "<script language=javascript>alert('Một số cá không chuyển được:" + res.Substring(1, res.Length - 2).Replace("@@", ", ") + "');</script>", false);
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "updated", "<script language=javascript>alert('Đã chuyển xong!');window.opener.finishEdit();self.close();</script>", false);
}
}
}
}
