public TanitsuTorokuAddServiceOutBo execute()
{
TanitsuTorokuAddServiceOutBo outBo = new TanitsuTorokuAddServiceOutBo();
using (var context = new MyContext())
{
var products = context.WordDic
.Where(x => x.ronri_name1 == this.inBo.ronrimei1TextBox)
.ToArray();
if (products.Count() > 0)
{
outBo.errorMessage = MessageConst.ERR_002;
return(outBo);
}
}
List <HenshuWordBo> wordList = new List <HenshuWordBo>();
HenshuWordBo word = new HenshuWordBo();
for (int i = 0; i < this.inBo.tanitsuDataGridView.Rows.Count; i++)
{
word = new HenshuWordBo();
word.word_id = this.inBo.tanitsuDataGridView.Rows[i].Cells["word_id"].Value.ToString().ToIntType();
word.ronri_name1 = this.inBo.tanitsuDataGridView.Rows[i].Cells["ronri_name1"].Value.ToString();
word.butsuri_name = this.inBo.tanitsuDataGridView.Rows[i].Cells["butsuri_name"].Value.ToString();
word.data_type = this.inBo.tanitsuDataGridView.Rows[i].Cells["data_type"].Value.ToString();
word.user_name = common.nullAble(this.inBo.tanitsuDataGridView.Rows[i].Cells["user_name"].Value);
word.version = common.nullAbleInt(this.inBo.tanitsuDataGridView.Rows[i].Cells["version"].Value);
word.cre_date = common.nullAble(this.inBo.tanitsuDataGridView.Rows[i].Cells["cre_date"].Value);
wordList.Add(word);
}
word = new HenshuWordBo();
word.ronri_name1 = this.inBo.ronrimei1TextBox;
word.butsuri_name = this.inBo.butsurimeiTextBox;
word.data_type = this.inBo.dataType;
wordList.Add(word);
if (this.inBo.registeredPairsFlg)
{
word = new HenshuWordBo();
word.ronri_name1 = this.inBo.butsurimeiTextBox;
word.butsuri_name = this.inBo.ronrimei1TextBox;
word.data_type = this.inBo.dataType;
wordList.Add(word);
}
outBo.wordList = wordList;
return(outBo);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
internal IkkatsuTorokuInitServiceOutBo execute()
{
IkkatsuTorokuInitServiceOutBo outBo = new IkkatsuTorokuInitServiceOutBo();
List <HenshuWordBo> wordList = new List <HenshuWordBo>();
if (!String.IsNullOrEmpty(this.inBo.clipboardText))
{
string key = this.inBo.clipboardText;
string nl = Environment.NewLine;
String[] keys = key.Split(new string[] { nl }, StringSplitOptions.None);
foreach (String ronriName in keys)
{
using (var context = new MyContext())
{
IQueryable <HenshuWordBo> words = from a in context.WordDic
join b in context.UserMst on a.user_id equals b.user_id
select new HenshuWordBo
{
word_id = a.word_id,
ronri_name1 = a.ronri_name1,
butsuri_name = a.butsuri_name,
user_name = b.user_name,
cre_date = a.cre_date,
version = (int)a.version
};
String condition = ronriName.Trim();
HenshuWordBo[] dbWords = words.Where(x => x.ronri_name1 == condition).ToArray();
if (dbWords.Length == 0)
{
HenshuWordBo w = new HenshuWordBo();
w.ronri_name1 = ronriName;
wordList.Add(w);
}
}
}
}
outBo.henshuWordBoList = wordList;
return(outBo);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public TanitsuTorokuInitServiceOutBo execute()
{
TanitsuTorokuInitServiceOutBo outBo = new TanitsuTorokuInitServiceOutBo();
List <HenshuWordBo> wordList = new List <HenshuWordBo>();
if (!String.IsNullOrEmpty(this.inBo.clipboardText))
{
string ronriName = this.inBo.clipboardText;
using (var context = new MyContext())
{
IQueryable <HenshuWordBo> words = from a in context.WordDic
join b in context.UserMst on a.user_id equals b.user_id
select new HenshuWordBo
{
word_id = a.word_id,
ronri_name1 = a.ronri_name1,
butsuri_name = a.butsuri_name,
user_name = b.user_name,
cre_date = a.cre_date,
version = (int)a.version
};
String condition = ronriName.Trim();
HenshuWordBo[] dispWords = words.Where(x => x.ronri_name1.IndexOf(condition) > -1).ToArray();
foreach (var word in dispWords)
{
HenshuWordBo w = new HenshuWordBo();
w.word_id = word.word_id;
w.ronri_name1 = word.ronri_name1;
w.butsuri_name = word.butsuri_name;
w.user_name = word.user_name;
w.cre_date = word.cre_date;
w.version = (int)word.version;
wordList.Add(w);
}
}
}
outBo.henshuWordBoList = wordList;
return(outBo);
}
