/// <summary>
/// Đưa giá trị từ bản vào form, tên cột trùng tên control tương ứng
/// </summary>
/// <param name="ctr">Vùng control cần đưa dữ liệu</param>
/// <param name="table">Bảng cần dưa dữ liệu</param>
public static void SetValueForm(Control ctr, DataTable table)
{
for (int i = 0; i < table.Columns.Count; i++)
{
Control _ctr = FindControl(ctr, table.Columns[i].ColumnName);
if (_ctr != null)
{
if (_ctr is Lib.Controls.textBox)
{
Lib.Controls.textBox txt = (Lib.Controls.textBox)_ctr;
txt.Text = LibConvert.ObjectToString(table.Rows[0][i]);
}
else if (_ctr is Lib.Controls.drop)
{
((Lib.Controls.drop)_ctr).SelectedValue = LibConvert.ObjectToString(table.Rows[0][i]);
}
else if (_ctr is Lib.Controls.checkBox)
{
((Lib.Controls.checkBox)_ctr).Checked = LibConvert.ObjectToBool(table.Rows[0][i]);
}
else if (_ctr is HiddenField)
{
((HiddenField)_ctr).Value = LibConvert.ObjectToString(table.Rows[0][i]);
}
}
}
}
/// <summary>
/// Tìm dòng có cột bằng với giá trị truyền
/// </summary>
/// <param name="table">Bảng cần tìm</param>
/// <param name="name">Tên cột</param>
/// <param name="val">Giá trị truyền</param>
public static int FindIndexRow(DataTable table, string name, object val)
{
if (!isNullOrEmtyTable(table))
{
string str = LibConvert.ObjectToString(val);
for (int i = 0; i < table.Rows.Count; i++)
{
if (!(table.Rows[i][name] is DBNull) && (LibConvert.ObjectToString(table.Rows[i][name]) == str))
{
return(i);
}
}
}
return(-1);
}
public static DataRow FindUser(string userName)
{
DataRow row = null;
DataTable table = (DataTable)HttpContext.Current.Application["connec"];
int num = LibTable.FindRowByColumn(table, "user", userName);
if (num >= 0)
{
row = table.Rows[num];
}
//lưu connecstring
DataOra _ora = new DataOra();
_ora.connecString = LibConvert.ObjectToString(row["connec"]);
return(row);
}
public static void Initialization()
{
try
{
DataSet set = new DataSet();
set.ReadXml(HttpContext.Current.Server.MapPath("~/htdns/config.xml"));
DataTable table = (DataTable)HttpContext.Current.Application["connec"];
table.AcceptChanges();
DataTable table2 = set.Tables["info"];
if (table2 != null)
{
int count = table2.Rows.Count;
if (count != 0)
{
for (int i = 0; i < count; i++)
{
DataRow row2 = table2.Rows[i];
bool flag = true;
for (int j = 0; j < i; j++)
{
DataRow row3 = table2.Rows[j];
if ((((row3["ip"].ToString() == row2["ip"].ToString()) && (row3["db"].ToString() == row2["db"].ToString())) && ((row3["loai"].ToString() == row2["loai"].ToString()) && (row3["dbo"].ToString() == row2["dbo"].ToString()))) && ((row3["ma_dvi"].ToString() == row2["ma_dvi"].ToString()) && (row3["nsd"].ToString() == row2["nsd"].ToString())))
{
flag = false;
break;
}
}
if (flag)
{
DataRow row = table.NewRow();
row["loai"] = row2["loai"];
row["dbo"] = row2["dbo"];
row["user"] = row2["user"];
row["nsd"] = row2["nsd"];
if (row2["loai"].ToString() == "ORA")
{
row["connec"] = string.Concat(new object[] { "User ID=", row["nsd"], "; Password="******"pas"], ";" });
row["connec"] = row["connec"] + "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)";
row["connec"] = string.Concat(new object[] { row["connec"], "(HOST=", row2["ip"], ")(PORT=", row2["port"], "))" });
row["connec"] = string.Concat(new object[] { row["connec"], "(CONNECT_DATA=(SID=", row2["db"], ")))" });
}
else if (LibConvert.ObjectToString(row2["loai"]) == "MSSQL")
{
row["connec"] = string.Concat(new object[] { "User ID =", row["nsd"], "; Data Source=", row2["ip"], "; Initial Catalog=", row2["db"], ";" });
if (LibConvert.ObjectToString(row2["pas"]) != "")
{
row["connec"] = string.Concat(new object[] { row["connec"], " Password="******"pas"], ";" });
}
row["dbo"] = "dbo";
}
table.Rows.Add(row);
}
}
table.AcceptChanges();
}
}
}
catch (Exception e)
{
throw new Exception("loi:Lỗi khởi tạo tham số kết nối " + e.Message + " :loi");
}
}