public static List <TrainFBItem> AddNullItem(List <TrainFBItem> trainFBItemLists)
{
TrainFBItem item = new TrainFBItem(-1, string.Empty, 0);
trainFBItemLists.Add(item);
return(trainFBItemLists);
}
/// <summary>
/// 插入反馈问题选择项
/// </summary>
/// <param name="item"></param>
/// <param name="quesId"></param>
/// <returns></returns>
private static int InsertFBItem(TrainFBItem item, int quesId)
{
int pkid;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 100).Value = item.Description;
cmd.Parameters.Add(_QuesID, SqlDbType.Int).Value = quesId;
cmd.Parameters.Add(_Score, SqlDbType.Int).Value = item.Worth;
SqlHelper.ExecuteNonQueryReturnPKID("TrainFBItemInsert", cmd, out pkid);
return(pkid);
}
/// <summary>
/// 交换第id行<==>第id+1行
/// </summary>
/// <param name="id"></param>
public void TrainFBItemChangedForDownEvent(string id)
{
List <TrainFBItem> items = _IFBQuestionAndItemView.FBItemList;
int currRow = Convert.ToInt32(id);
if (currRow + 2 == items.Count)
{
return;
}
TrainFBItem tempItem = items[currRow + 1];
items[currRow + 1] = items[currRow];
items[currRow] = tempItem;
_IFBQuestionAndItemView.FBItemList = items;
}
/// <summary>
/// 在rowIndex下新增空行
/// </summary>
/// <param name="rowIndex"></param>
public void TrainFBItemForAddAtEvent(string rowIndex)
{
List <TrainFBItem> items = new List <TrainFBItem>();
for (int i = 0; i < _IFBQuestionAndItemView.FBItemList.Count; i++)
{
items.Add(_IFBQuestionAndItemView.FBItemList[i]);
if (Convert.ToInt32(rowIndex) == i)
{
TrainFBItem item = new TrainFBItem(-1, "", 0);
items.Add(item);
}
}
_IFBQuestionAndItemView.FBItemList = items;
}
/// <summary>
/// 得到反馈问题下的反馈选择项
/// </summary>
/// <param name="quesId"></param>
/// <returns></returns>
private static List <TrainFBItem> GetFBItemsByQuesId(int quesId)
{
List <TrainFBItem> items = new List <TrainFBItem>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_QuesID, SqlDbType.Int).Value = quesId;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetTrainFBItemByQuesID", cmd))
{
while (sdr.Read())
{
int pkid = (Int32)sdr[_DBPKID];
string name = sdr[_DBName].ToString();
int score = (Int32)sdr[_DBScore];
TrainFBItem item = new TrainFBItem(pkid, name, score);
items.Add(item);
}
return(items);
}
}
