110,008
社区成员




int op=0;
string cu="";
int gs, gs1;
string st="", st1="", ay="", ax="";
st = UCase(Text1.Text.Trim()) ;
st1 = UCase(Text2.Text.Trim());
gs = st.Length;
gs1 = st1.Length;
if (gs > gs1)
{
for (int i = 1; i < gs; i++)
{
ay = st.Substring(i, 1);
ax = st1.Substring(i, 1);
if (ay != ax)
{
op++;
cu += ay;
if (st.Length >= i)
{
st = st.Substring(0, i - 1) + st.Substring(st.Length - i, i);
i = i - 1;
}
else
{
//这里有个空操作
}
}
}
if (Option1.Value)
txtSql = "select 批次大 from 出入库明细表 where 批次大='" + UCase(Text1.Text) + "'";
if (Option2.Value)
txtSql = "select 批次大 from 鞋面大底出入库明细表 where 批次大='" + UCase(Text1.Text) + "'";
myrecord = ExecuteSQL(txtsql, msgtext); //myrecord类型不明,这里以.net中的DataReader代替
for (int io = 1; io < myrecord.RecordCount; io++)
{
myrecord("批次大") = Text2.Text.Trim();
myrecord.Update();
}
for (int i = 1; i < cu.Length; i++)
{
sttu1 = cu.Substring(i, 1);
sttu = UCase(Text1.Text.Trim()).Substring(i, 1) + sttu1;
if (Option1.Value)
{
txtsql = "select 批次大,批次 from 出入库明细表 where 批次='" + sttu + "'";
}
if (Option2.Value)
{
txtsql = "select 批次大,批次 from 鞋面大底出入库明细表 where 批次='" + sttu + "'";
}
myrecord = ExecuteSQL(txtsql, msgtext); //myrecord类型不明,这里以.net中的DataReader代替
if (myrecord.RecordCount > 0)
{
for (int io = 1; io < myrecord.RecordCount; io++)
{
myrecord("批次大") = Text2.Text.Trim();
myrecord.Update();
}
}
}
MessageBox.Show("执行成功");
}
else
{
for (int io = 1; io < myrecord.RecordCount; io++)
{
myrecord("批次大") = Text2.Text.Trim();
myrecord.Update();
}
MessageBox.Show("执行成功");
}