带参数的方法
/// <summary>
/// 根据运输证带出可用数量
/// </summary>
public bool Transportation(int Row)
{
bool IsSuccess = true;
int currentRow = Row;
tRANSFER_LINES2s.SetCurrentRow(currentRow);//获取当前页面的行
double b = 0.00;
if (TRANSFER_LINES2s.TransferLine != "")
{
int Listsheng = 0;
IList<IDictionary> records = null;
string sql = @"SELECT T1.U_TransportarNo ,T1.U_FromDate ,T1.U_ToDate
FROM [@TRANSFER_LINES1] T0 ,[@TRANSPORTAR] T1
WHERE T0.DocEntry='{0}' AND T0.LineId='{1}' AND T1.U_ItemCode=T0.U_ItemCode";
sql = string.Format(sql,DocEntry,tRANSFER_LINES2s.TransferLine);
records = Context.DiUtility.FindRecordsBySql(sql);
string sql1 = "SELECT COUNT(*) FROM [@TRANSFER_LINES2] WHERE U_TransportarId='{0}' AND U_LineStatus='C'";
double convert1 = Convert.ToDouble(Context.DiUtility.ExecSql(string.Format(sql1, this.tRANSFER_LINES2s.TransportarId)));//运输证已使用过的次数
string sql2 = " SELECT T0.U_Counts FROM [@TRANSPORTAR] T0 WHERE T0.U_TransportarNo='{0}'";
double convert2 = Convert.ToDouble(Context.DiUtility.ExecSql(string.Format(sql2, this.tRANSFER_LINES2s.TransportarId)));//运输证的有效次数
Matrix matrix = Parent.Items.Item("509").Specific as Matrix;
ComboBox LineStatus;
LineStatus = matrix.Columns.Item("5").Cells.Item(tRANSFER_LINES2s.Count).Specific as ComboBox;
for (int i = 1; i <= matrix.RowCount; i++)
{
if (Convert.ToString((matrix.Columns.Item("25").Cells.Item(i).Specific as EditText).Value)
== Convert.ToString((matrix.Columns.Item("25").Cells.Item(TRANSFER_LINES2s.Count).Specific as EditText).Value))//判断运输证是否相同
{
Listsheng++;
}
}
if (records.Count == 0)
{
throw new TransportationIsNoException();
}
else
{
if (LineStatus.Value == "C" || LineStatus.Value == "A")//当行状态为添加和未执行时判断运输证的剩余数量和剩余有效次数
{
if (convert2 - convert1 - Listsheng >= 0)
{
TRANSFER_LINES2s.CanUse = Convert.ToString(TransportationSum(b));//传递运输证的剩余数量
Context.Application.MessageBox(
Context.Message.GetMessage("该运输证的剩余可用次数为" + (convert2 - convert1 - Listsheng).ToString()), 2,
Context.Message.GetMessage("btnOk"), "");
}
else
{
Context.Application.MessageBox(
Context.Message.GetMessage("该运输证有效次数已用完，请重新选择!"), 2,
Context.Message.GetMessage("btnOk"), "");
IsSuccess = false;
return IsSuccess;
}
}
}
tRANSFER_LINES2s.UpdateRow();
}
return IsSuccess;
}
/// <summary>
/// 订购的数量不能大于运输证可用的数量
/// </summary>
public double TransportationSum(double b)
{
Matrix matrix;
Matrix matrix1;
matrix = Parent.Items.Item("505").Specific as Matrix;
matrix1 = Parent.Items.Item("509").Specific as Matrix;
ComboBox LineStatus;
LineStatus = matrix1.Columns.Item("5").Cells.Item(tRANSFER_LINES2s.Count).Specific as ComboBox;
string sql = " SELECT U_Quantity FROM [@TRANSPORTAR] WHERE U_TransportarNo='{0}'";
double convert1 = Convert.ToDouble(Context.DiUtility.ExecSql(string.Format(sql, this.tRANSFER_LINES2s.TransportarId)));//运输证的数量
string sql1 = @"SELECT SUM(T1.U_Quantity)
FROM [@TRANSFER] T0,[@TRANSFER_LINES1] T1 ,[@TRANSFER_LINES2] T2
WHERE T2.U_TransportarId='{0}' AND
T0.DocEntry=T1.DocEntry AND T1.DocEntry=T2.DocEntry AND T2.U_LineStatus='C'";//当为已完成状态时，才会添加到数据库里面
double convert2 = Convert.ToDouble(Context.DiUtility.ExecSql(string.Format(sql1, this.tRANSFER_LINES2s.TransportarId)));//运输证已经用掉的额度
double a = 0.00;
string id = "";
for (int i = 1; i <= matrix1.RowCount; i++)
{
if (LineStatus.Value == "C" || LineStatus.Value == "A")//当行状态为添加和未执行时判断
{
id = Convert.ToString((matrix1.Columns.Item("7").Cells.Item(i).Specific as EditText).Value);
if (Convert.ToString((matrix1.Columns.Item("25").Cells.Item(i).Specific as EditText).Value)
== Convert.ToString((matrix1.Columns.Item("25").Cells.Item(TRANSFER_LINES2s.Count).Specific as EditText).Value))
{
a += getid(matrix, id);
}
}
}
if (LineStatus.Value == "C" || LineStatus.Value == "A")//当行状态为添加和未执行时判断
{
b=convert1 - convert2 - a;
}
if (b < 0)
{
throw new TransportationConntMaxSum();
}
else
{
return b;
}
}
/// <summary>
/// 传递Matrix中的参数，获取行号
/// </summary>
/// <param name="matrix"></param>
/// <param name="id"></param>
/// <returns></returns>
private double getid(Matrix matrix, string id)
{
Matrix matrix2;
matrix2 = Parent.Items.Item("509").Specific as Matrix;
ComboBox LineStatus;
LineStatus = matrix2.Columns.Item("5").Cells.Item(tRANSFER_LINES2s.Count).Specific as ComboBox;
double list = 0;
for (int i = 1; i <= matrix.RowCount; i++)
{
if (Convert.ToString((matrix.Columns.Item("1").Cells.Item(i).Specific as EditText).Value) == id)
{
list += Convert.ToDouble((matrix.Columns.Item("29").Cells.Item(i).Specific as EditText).Value);//订购的数量
}
}
return list;
}
