/// <summary>
/// 检验字符型字段的长度，主要用于解决查询结果因代码表转换后，长度比代码要长，按元数据定义的长度无法写入结果数据到数据库中。
/// </summary>
/// <param name="_col"></param>
/// <param name="_dt"></param>
private static void CheckLength(MD_PATable_Column _col, DataTable _dt)
{
string _fieldName = _col.ColumnName;
foreach (DataRow _dr in _dt.Rows)
{
string _s = _dr[_fieldName].ToString();
int _len = _s.Length * 2;
if (_len > _col.ColumnLength)
{
_col.ColumnLength = _len;
}
}
_col.ColumnType = "VARCHAR2";
}
public static void SaveToPAnalize(DevExpress.XtraGrid.Views.Base.BaseView _bv)
{
DataTable _savedt = null;
Dialog_SelectPAnalize _f = new Dialog_SelectPAnalize();
_f.InitData();
if (_f.ShowDialog() == DialogResult.OK)
{
DataView _dv = _bv.DataSource as DataView;
DataTable _dt = _dv.Table;
string _tname = _f.TableDisplayName;
List <MD_PATable_Column> columnDefine = new List <MD_PATable_Column>();
if (_bv is GridView)
{
MD_PATable_Column _col = null;
GridView _gridview = _bv as GridView;
foreach (GridColumn _gc in _gridview.Columns)
{
MDQuery_TableColumn _cdefine = _gc.Tag as MDQuery_TableColumn;
DataColumn _dc = _dt.Columns[_gc.FieldName];
if (_cdefine == null)
{
_col = new MD_PATable_Column("", "", "", _gc.FieldName, _gc.Caption, CovertColumnType(_dc.DataType), _dc.MaxLength, _gc.VisibleIndex);
}
else
{
_col = new MD_PATable_Column("", "", "", _gc.FieldName, _gc.Caption, _cdefine.ColumnDataType,
_cdefine.ColumnLength, _gc.VisibleIndex, _cdefine.RefDMB, _cdefine.DisplayFormat, _cdefine.RefWord);
}
columnDefine.Add(_col);
}
}
//验证有无MAINID字段
//bool _findMainID = false;
//foreach (MD_PATable_Column _col in columnDefine)
//{
// if (_col.ColumnName == "MAINID")
// {
// _findMainID = true;
// }
//}
//没有则添加
//if (!_findMainID)
//{
//
//}
//代码表和字符串类型长度验证
foreach (MD_PATable_Column _col in columnDefine)
{
switch (_col.ColumnType)
{
case "VARCHAR2":
case "NVARCHAR2":
case "VARCHAR":
case "NVARCHAR":
case "CHAR":
CheckLength(_col, _dt);
break;
default:
if (_col.RefDMB == null || _col.RefDMB == "")
{
}
else
{
//转换
CheckLength(_col, _dt);
}
break;
}
}
#region 判断是否存在计算字段
bool _haveComputData = false;
foreach (DataColumn _dc in _dt.Columns)
{
if (_dc.Expression.Length > 0)
{
_haveComputData = true;
break;
}
}
if (_haveComputData)
{
_savedt = new DataTable();
foreach (MD_PATable_Column _col in columnDefine)
{
switch (_col.ColumnType)
{
case "VARCHAR2":
case "NVARCHAR2":
case "VARCHAR":
case "NVARCHAR":
case "CHAR":
_savedt.Columns.Add(_col.ColumnName, typeof(string));
break;
default:
if (_col.RefDMB.Length > 0)
{
//转换
_savedt.Columns.Add(_col.ColumnName, typeof(string));
}
else
{
_savedt.Columns.Add(_col.ColumnName, _dt.Columns[_col.ColumnName].DataType);
}
break;
}
}
foreach (DataRow _dr in _dt.Rows)
{
DataRow _newrow = _savedt.NewRow();
foreach (MD_PATable_Column _col in columnDefine)
{
_newrow[_col.ColumnName] = _dr[_col.ColumnName];
}
_savedt.Rows.Add(_newrow);
}
}
else
{
_savedt = _dt;
}
#endregion
//所有数据都添加新主建
_savedt = _savedt.Copy();
columnDefine.Add(new MD_PATable_Column("", "", "", "PAMAINID", "主键", "VARCHAR2", 50, 0));
_savedt.Columns.Add("PAMAINID", typeof(string));
foreach (DataRow _dr in _savedt.Rows)
{
_dr["PAMAINID"] = Guid.NewGuid().ToString();
}
_savedt.AcceptChanges();
//存入个人分析空间
//if (SinoSZQueryConfig.MetaDataFactroy.SaveDataToPAnalize(_f.CurrentProject, _f.TableDisplayName, columnDefine, _savedt))
//{
// XtraMessageBox.Show("保存成功！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
//else
//{
// XtraMessageBox.Show("保存失败！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
}
}
