private bool check()
{
string msg = "";
bool isEmpty = false;
if (string.IsNullOrEmpty(txtName.Text))
{
msg = "欄位不能為空值!";
isEmpty = true;
}
if (!isEmpty && !string.IsNullOrEmpty(txtIndex.Text) && txtIndex.Text != "0")
{
PhraseInfo view = new PhraseInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), ddlCategory.SelectedItem.ToString());
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.index.ToString(), txtIndex.Text);
if (view.calculateCount() > 0)
{
msg = "排序已存在!請重新選擇!";
}
}
if (!string.IsNullOrEmpty(msg))
{
APConfig.SweetAlert(ShowBoxType.alert, msg);
}
return(string.IsNullOrEmpty(msg) ? true : false);
}
private void phraseLoadData()
{
dgvPhrase.Rows.Clear();
DataGridViewRowCollection rows = dgvPhrase.Rows;
PhraseInfo view = new PhraseInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), ddlPhraseCategory.SelectedItem.ToString());
if (!string.IsNullOrEmpty(txtPhraseName.Text))
{
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.name.ToString(), txtPhraseName.Text);
}
if (!string.IsNullOrEmpty(txtPhraseType.Text))
{
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.type.ToString(), txtPhraseType.Text);
}
if (view.load())
{
while (!view.IsEof)
{
rows.Add(new Object[] { view.PHS_SERNO, view.PHS_NAME, view.PHS_TYPE, view.PHS_INDEX });
view.next();
}
}
lblPhraseTotal.Text = view.calculateCount().ToString();
}
private bool check()
{
string msg = "";
bool isEmpty = false;
if (string.IsNullOrEmpty(txtName.Text))
{
msg = "欄位不能為空值!";
isEmpty = true;
}
if (!isEmpty)
{
PhraseInfo view = new PhraseInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.category.ToString(), ddlCategory.SelectedItem.ToString());
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.EQname.ToString(), txtName.Text);
if (isItem)
{
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.EQsize.ToString(), txtSize.Text);
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.EQtype.ToString(), txtType.Text);
view.Conditions += " AND " + view.getCondition(PhraseInfo.ncConditions.EQcolor.ToString(), txtColor.Text);
}
if (view.calculateCount() > 0)
{
msg = "項目已存在!請確認!";
}
}
if (!string.IsNullOrEmpty(msg))
{
APConfig.SweetAlert(ShowBoxType.alert, msg);
}
return(string.IsNullOrEmpty(msg) ? true : false);
}
