/// <summary>
/// 处理批量录入控件数据源
/// </summary>
/// <param name="startIndex">开始位</param>
/// <param name="fabCount">匹数</param>
/// <param name="perQty">每匹数量</param>
/// <returns>true/false 表格行数有没有改变</returns>
bool ProBatchDataSource(int startIndex, int fabCount, decimal perQty)
{
bool AddFlag = false;
int fabNo = 0; //卷号,当前已录入卷号
if (m_UCDataSource.Rows.Count < startIndex + fabCount + 1) //如果行数不足,一般不会影响，事先判断好
{
UCFabCommon.AddDtRow(m_UCDataSource, startIndex + fabCount + 1);
AddFlag = true;
}
//if (startIndex > 0)//获取上一卷号
//{
// fabNo = SysConvert.ToInt32(m_UCDataSource.Rows[startIndex - 1]["SubSeq"]);
//}
//获取最大卷号
DataRow[] drA = m_UCDataSource.Select("1=1", "SubSeq DESC");
if (drA.Length > 0)
{
fabNo = SysConvert.ToInt32(drA[0]["SubSeq"]);
}
for (int i = startIndex; i < startIndex + fabCount; i++)//开始循环赋值
{
m_UCDataSource.Rows[i]["SubSeq"] = (fabNo + i - startIndex + 1).ToString();
m_UCDataSource.Rows[i]["Qty"] = perQty;
}
return(AddFlag);
}
/// <summary>
/// 创建进度条
/// </summary>
/// <param name="dtSource">数据源，列0/1/2/:ID,Name,ColorStr</param>
void CreateBar(DataTable dtSource)
{
foreach (Control ctl in this.Controls)
{
if (ctl is UCStatusBarStandOne)
{
this.Controls.Remove(ctl);//移除控件
}
}
int modeType = UCStatusBarParamSet.GetIntValueByID(7401);//进度条模式序号：0/1/2/:默认/标准/圆角矩形
string bColorStr = UCStatusBarParamSet.GetStrValueByID(7402);//进度边框颜色，未设置使用默认色
Color ucbColor = UCStatusBarParamSet.ConvertColorByStr(bColorStr);
for (int i = 0; i < dtSource.Rows.Count; i++)
{
UCStatusBarStandItemBase ucft = CreateBar(modeType, i);
ucft.UCBackColor = UCFabCommon.ConvertColorByStr(dtSource.Rows[i][2].ToString());
ucft.UCContext = dtSource.Rows[i][1].ToString();
if (ucbColor != Color.White)
{
ucft.UCBorderColor = ucbColor;
}
this.Controls.Add(ucft);
Application.DoEvents();
}
}
/// <summary>
/// 绑定Grid
/// </summary>
void BindGrid()
{
UCFabCommon.AddDtRow(UCDataSource, UCInputCount);
gridView1.GridControl.DataSource = ConvertDataSource(UCDataSource);
gridView1.GridControl.Show();
DataSourceTotalCalcAll();//计算小计
DataSourceTotalInfoSet();
//lblFabCount.Text = "匹数:" + SysConvert.ToString(UCDataSource.Compute("COUNT(Qty)", " ISNULL(Qty,0)<>0")); //UCDataSource.Rows.Count.ToString();
//lblFabQty.Text = "数量:"+SysConvert.ToString(UCDataSource.Compute("SUM(Qty)", ""));
}
/// <summary>
/// 控件加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UCFabIGridView_Load(object sender, EventArgs e)
{
try
{
UCFabCommon.GridViewRowIndexBind(gridView1);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void UCFabLGridView_Load(object sender, EventArgs e)
{
try
{
gridView1.OptionsBehavior.ShowEditorOnMouseUp = false;
UCFabCommon.GridViewRowIndexBind(gridView1);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
void BindGrid()
{
UCFabCommon.AddDtRow(UCDataSource, UCInputCount);
gridView1.GridControl.DataSource = UCDataSource;
gridView1.GridControl.Show();
}
/// <summary>
/// 录入格子数量改变
/// </summary>
public virtual void UCInputCountChanged()
{
UCFabCommon.RemoveInputBankRow(UCDataSource); //清除录入数据源中空行
UCAct(); //执行重绘
}
/// <summary>
/// 执行绘画
/// 一般在全部赋值完成后
/// </summary>
public override void UCAct()
{
UCFabCommon.AddDtRow(UCDataSource, UCInputCount);
CreateFabTile(UCDataSource, UCColumnCount);
}
/// <summary>
/// 值改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
if (e.Column.FieldName.IndexOf("ColVal") != -1) //是值
{
int colIndex = SysConvert.ToInt32(e.Column.FieldName.Substring(6)); //列号 1开始
int rowIndex = e.RowHandle / 5; //行号，取整 0开始
if (!UCVolumeNumberShowFlag) //如果不显示卷号，就是一行数量，则行数就是GridView行号
{
rowIndex = e.RowHandle;
}
int datasourceRow = rowIndex * UCColumnCount + (colIndex - 1); //数据源行号
if (UCDataSource.Rows.Count <= datasourceRow) //溢出
{
UCFabCommon.AddDtRow(UCDataSource, datasourceRow + 2);
}
if (UCDataSource.Rows.Count > datasourceRow) //未溢出
{
if (UCVolumeNumberShowFlag) //如果显示卷号，就是两行，一行匹号，一行卷号
{
if (e.RowHandle % 5 == 0) //匹号
{
if (SysConvert.ToInt32(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["SubSeq"] = SysConvert.ToInt32(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["SubSeq"] = DBNull.Value;
}
}
else if (e.RowHandle % 5 == 1)//数量
{
if (SysConvert.ToDecimal(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["Qty"] = SysConvert.ToDecimal(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["Qty"] = DBNull.Value;
}
}
else if (e.RowHandle % 5 == 2)//公斤数
{
if (SysConvert.ToDecimal(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["Weight"] = SysConvert.ToDecimal(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["Weight"] = DBNull.Value;
}
}
else if (e.RowHandle % 5 == 3)//码数
{
if (SysConvert.ToDecimal(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["Yard"] = SysConvert.ToDecimal(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["Yard"] = DBNull.Value;
}
}
else
{
if (SysConvert.ToString(e.Value) != string.Empty)
{
UCDataSource.Rows[datasourceRow]["GoodsLevel"] = SysConvert.ToString(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["GoodsLevel"] = DBNull.Value;
}
}
}
else//如果不显示卷号，就是一行数量
{
if (e.RowHandle % 4 == 0)//数量
{
if (SysConvert.ToDecimal(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["Qty"] = SysConvert.ToDecimal(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["Qty"] = DBNull.Value;
}
}
else if (e.RowHandle % 4 == 1)//公斤数
{
if (SysConvert.ToDecimal(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["Weight"] = SysConvert.ToDecimal(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["Weight"] = DBNull.Value;
}
}
else if (e.RowHandle % 4 == 2)
{
if (SysConvert.ToDecimal(e.Value) != 0)
{
UCDataSource.Rows[datasourceRow]["Yard"] = SysConvert.ToDecimal(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["Yard"] = DBNull.Value;
}
}
else
{
if (SysConvert.ToString(e.Value) != string.Empty)
{
UCDataSource.Rows[datasourceRow]["GoodsLevel"] = SysConvert.ToString(e.Value);
}
else
{
UCDataSource.Rows[datasourceRow]["GoodsLevel"] = DBNull.Value;
}
}
}
}
DataSourceTotalCalc(e.RowHandle);//计算小计
DataSourceTotalInfoSet();
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
