/// <summary>
/// 设置单据导入状态
/// </summary>
void SetDocumentImportStatus(string statusName, DataSources.EnumImportStaus importStaus, List <SysSQLString> listSql, string order_id, string order_type)
{
DataTable dt = DBHelper.GetTable("", "tb_balance_documents", "documents_id,documents_name", string.Format("order_id='{0}'", order_id), "", "");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
Preposition pre = new Preposition();
foreach (DataRow dr in dt.Rows)
{
pre.AddID(dr["documents_id"], dr["documents_name"]);
}
listSql.AddRange(pre.GetSql(statusName, importStaus));
}
/// <summary>
/// 设置单据导入状态
/// </summary>
void SetDocumentImportStatus(string statusName, DataSources.EnumImportStaus importStaus, List<SysSQLString> listSql, bool isSelected)
{
if (dgvDocuments.RowCount == 0 && dgvDocuments2.RowCount == 0)
{
return;
}
Preposition pre = new Preposition();
foreach (DataGridViewRow dgvr in dgvDocuments.Rows)
{
if (isSelected)
{
object check = dgvr.Cells[colChk.Name].EditedFormattedValue;
if (check != null && (bool)check)
{
pre.AddID(dgvr.Cells[colOrderID.Name].Value, dgvr.Cells[colOrderName.Name].Value);
}
}
else
{
pre.AddID(dgvr.Cells[colOrderID.Name].Value, dgvr.Cells[colOrderName.Name].Value);
}
}
if (dgvDocuments2.Visible)
{
foreach (DataGridViewRow dgvr in dgvDocuments2.Rows)
{
if (isSelected)
{
object check = dgvr.Cells[colChk2.Name].EditedFormattedValue;
if (check != null && (bool)check)
{
pre.AddID(dgvr.Cells[colOrderID2.Name].Value, dgvr.Cells[colOrderName2.Name].Value);
}
}
else
{
pre.AddID(dgvr.Cells[colOrderID2.Name].Value, dgvr.Cells[colOrderName2.Name].Value);
}
}
}
listSql.AddRange(pre.GetSql(statusName, importStaus));
}
/// <summary>
/// 设置单据导入状态
/// </summary>
void SetDocumentImportStatus(string statusName, DataSources.EnumImportStaus importStaus, List<SysSQLString> listSql, string order_id, string order_type)
{
DataTable dt = DBHelper.GetTable("", "tb_balance_documents", "documents_id,documents_name", string.Format("order_id='{0}'", order_id), "", "");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
Preposition pre = new Preposition();
foreach (DataRow dr in dt.Rows)
{
pre.AddID(dr["documents_id"], dr["documents_name"]);
}
listSql.AddRange(pre.GetSql(statusName, importStaus));
}
