/// <summary>
/// Load data
/// </summary>
private void LoadData()
{
BD_ProviderEvalData data = new BD_ProviderEvalData();
ITransaction tran = factory.GetLoadObject(data, hidId.Value);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_ProviderEvalData)tran.Result;
txtContentEval.Text = data.ContentEval;
txtEvalDate.Text = Func.FormatDMY(data.EvalDate);
txtComment.Text = data.Comment;
lblProviderId.Text = data.ProviderId;
BD_ProviderData dataP = new BD_ProviderData();
ITransaction tranP = factory.GetLoadObject(dataP, lblProviderId.ID);
Execute(tranP);
if (!HasError)
{
//Get Data
dataP = (BD_ProviderData)tranP.Result;
lblName.Text = dataP.Name;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAutoId_Click(object sender, EventArgs e)
{
BD_ProviderData data = new BD_ProviderData();
string prefix = Func.ParseString(Session["__BUILDINGID__"]) + "C" + hidDept.Value;
if (String.IsNullOrEmpty(prefix))
{
mvMessage.AddError("Lỗi xảy ra, hãy bấm F5 hoặc liên hệ Admin");
return;
}
int length = 10;
string tmp = String.Format("", length);
string sql = "SELECT max(maxid) from (SELECT SUBSTRING(ID, " + (prefix.Length + 1) + ", " + length + ") as maxid FROM BD_Provider where SUBSTRING(id, 1, 7) = '"+ prefix +"') as tmp WHERE maxid < '1000'";
int key = 0;
try
{
key = Convert.ToInt32(DbHelper.GetScalar(sql));
key++;
}
catch
{
key = 1;
}
bool keyFlg = true;
while (keyFlg)
{
string tmpKey = prefix + key.ToString().PadLeft(length - prefix.Length, '0');
sql = "SELECT count(*) from BD_Provider WHERE id = '" + tmpKey + "'";
if (Convert.ToInt32(DbHelper.GetScalar(sql)) != 1)
{
keyFlg = false;
}
else
{
key--;
}
}
txtAutoId.Text = prefix + key.ToString().PadLeft(length - prefix.Length, '0');
}
